Can not update post content in database

  • I recently moved my wordpress site and have successfully updated the url site wide except the text in the posts content area.

    For some reason the URL links in the post content have not updated and I can not find the text in the database??

    The post_content table only shows a description of the post not the actual text in the post?

    So I was wondering where I can find the actual text that are in the posts so that I can update it?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Use the plugin “better search replace”. Search, in all tables, for https://oldexample.com and replace with https://newexample.com.

    Thread Starter cambob

    (@cambob)

    I tried that, searched all the tables and the log said no instances were repplaced. And checking the posts they stillhave the old url in the text/html section of the post.

    Thats why I would like to find this text/html in the database so that I can change it with sql.

    Thanks all the same

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Please provide a link to a page on your site where we can see this. Thanks. Note: Your link will be public and we will not later remove it.

    Thread Starter cambob

    (@cambob)

    you cant see it in the text because the URLs are html links to images. But for example if you click on the name across from “download comp” it will take you to an old URL (different domain) and the image to download wont be there because the path has not been updated.

    https://www.zenmaps.art/wm006-117/

    thanks

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Try again with “better search replace”.

    Search for https://www.zenstream.net and replace with https://www.zenmaps.art. Make sure the ‘dry run’ box is unchecked.

    Thread Starter cambob

    (@cambob)

    as mentioned above I tried the plugin “better search replace”. tried it twice now but same result as above.

    that is why i want to change it directly in the database via sql but I cant find the content?

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    BSR *does the replacment in the database*. Did you search all tables? IF it’s not finding matches, then then the URLs might be coded someplace else.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Can not update post content in database’ is closed to new replies.