Tagged: better search replace, database, picture, slider, sql query
-
AuthorPosts
-
November 20, 2023 at 10:30 pm #1426101
Dear support,
i use the database tool Better search replace ….
But this tool blocked every searchs and replace in my wp_post table …. support from tool i write a message … but i get dont answersokay!
I go in my database an would like a manuel query!
here: UPDATE
wp_posts
SETpost_content
= REPLACE(post_content
, ‘%id=’3595’%’, ‘%id=’4760’%’) WHEREpost_content
LIKE ‘%id=’3595’%’But here i get a lot errors
My reason for this query is the change of a slider image in over 120 pages…
Following path: [av_slide_full slide_type=’image’ id=’3595′
I want to change it to:
[av_slide_full slide_type=’image’ id=’4760′
My wp_post spit out over 1030 entries about it.
But my sql commands are all wrong…
Here’s another one that doesn’t work
UPDATE
wp_posts
SETpost_content
= REPLACE(post_content
, ‘[av_slide_full slide_type=’image’ id=’3595”, ‘[av_slide_full slide_type=’image’ id=’4760”) WHEREpost_content
LIKE ‘%[av_slide_full slide_type=’image’ id=’3595’%’ COLLATE utf8mb4_binUPDATE
wp_posts
SETpost_content
= REPLACE(post_content
, ‘%[av_slide_full slide_type=’image’ id=’3595’%’, ‘%[av_slide_full slide_type=’image’ id=’4760’%’) WHEREpost_content
LIKE ‘%%[av_slide_full slide_type=’image’ id=’3595’%%’ COLLATE utf8mb4_binCan you help me please???
so many thanks strumpel
November 21, 2023 at 5:17 am #1426114Hey strumpumpel,
Thank you for the inquiry.
What are the errors that occur after doing the query? Please note that the builder elements are also saved in a custom field called _aviaLayoutBuilderCleanData, which is also attached to the pages. You will have to update these entries as well. We recommend using a search and replace plugin instead of manually doing the query. Select the wp_postmeta table before running search/replace, and make sure that the “dry run” option is off.
Best regards,
Ismael -
AuthorPosts
- You must be logged in to reply to this topic.