Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #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 answers

    okay!

    I go in my database an would like a manuel query!

    here: UPDATE wp_posts SET post_content = REPLACE(post_content, ‘%id=’3595’%’, ‘%id=’4760’%’) WHERE post_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 SET post_content = REPLACE(post_content, ‘[av_slide_full slide_type=’image’ id=’3595”, ‘[av_slide_full slide_type=’image’ id=’4760”) WHERE post_content LIKE ‘%[av_slide_full slide_type=’image’ id=’3595’%’ COLLATE utf8mb4_bin

    UPDATE wp_posts SET post_content = REPLACE(post_content, ‘%[av_slide_full slide_type=’image’ id=’3595’%’, ‘%[av_slide_full slide_type=’image’ id=’4760’%’) WHERE post_content LIKE ‘%%[av_slide_full slide_type=’image’ id=’3595’%%’ COLLATE utf8mb4_bin

    Can you help me please???

    so many thanks strumpel

    #1426114

    Hey 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

Viewing 2 posts - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.