Moved WordPress Domain, Image links broken

  • wambamboo

    (@agatha1)


    11 years, 1 month ago

    Hi
    I’ve recently moved my wordpress installation from a sandbox to the client’s domain. I’ve done this before but this time the image links are not updating. I have used this code in PHPmyadmin:

    UPDATE wp_posts SET post_content=(REPLACE (post_content, '{old url}','{new url}'))

    and tried the old and new urls both with and without http://www.,trailing slashes and wp-content/ at the end but nothing seems to make a difference. I’ve also tried logging out of WordPress and back in, and have been through the whole process twice.
    Does anyone have any suggestions? Thanks

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator t-p

    (@t-p)

    11 years, 1 month ago

    – have tried clearing cache?
    – also try different browser/computer

    -if that not resolve the issue, you may need to search and replace in your database to clean that up. There are plugins that can do that as well (look for search and replace plugins).

    Make sure you backup everything (including your database) before doing any actions, just in case.

    Thread Starter wambamboo

    (@agatha1)

    11 years, 1 month ago

    Yes, tried clearing the cache and using a different browser. I think it’s definitely a database problem. Tried Velvet Blues plugin but it didn’t work for me. Are there any other good search and replace plugins?

    Thanks

    Thread Starter wambamboo

    (@agatha1)

    11 years, 1 month ago

    This is an update on my issue and its related problems:

    I have recently moved a wordpress site from one domain to another, but am having a few problems.

    1) My image links did not update
    2) The image on Really Simple Captcha no longer works
    3) My custom 404 page is no longer styled.

    I tried to update the permalinks in the database using the following queries:

    UPDATE wp_options SET option_value = replace(option_value, 'http://www.oldurl', 'http://www.newurl') WHERE option_name = 'home' OR option_name = 'siteurl';

UPDATE wp_posts SET guid = replace(guid, 'http://www.oldurl','http://www.newurl');

UPDATE wp_posts SET post_content = replace(post_content, 'http://www.oldurl', 'http://www.newurl');

UPDATE wp_postmeta SET meta_value = replace(meta_value,'http://www.oldurl','http://www.newurl');

    but it does not seem to have worked. I have also tried the Plugin Velvet Blues but this didn’t work either.

    Any help would be great
    Thanks

    Thread Starter wambamboo

    (@agatha1)

    11 years, 1 month ago

    Hi
    I have managed to get images and Captcha back by manually searching my database and updating all URLs.

    However I am still having the problem with the 404 page. I am going to start a new thread for this as it seems to be a different issue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Moved WordPress Domain, Image links broken’ is closed to new replies.