Can't edit wordpress after changing domain in settings-general

  • I noticed that my wordpress website (thetruthbehindscience.com) was not displaying correctly outside my LAN. I used the tester https://tools.pingdom.com/fpt/ to check what was wrong, and I noticed that many of the files are linking to my internal IP address (xxx.xxx.myip.xx/wp-includes/js/, xxx.xxx.myip.xx/wp-content/uploads/201, etc). I tried to fix it by changing the domain settings under settings-general to my domain, but now I can’t access my wordpress at all. I have content on my website, so I’d rather not have to do a fresh install. My server is running debian.

Viewing 2 replies - 1 through 2 (of 2 total)

  • the problem is when you tranfered the DB you did not updates the links. The easiest way to transfer your site is by using the WB migrate plugin.

    For use in phpMyAdmin, here is some SQL code that can fix things for you after being edited a bit:

    UPDATE pref_options SET option_value = replace(option_value, 'https://www.olddomain.com', 'https://www.newdomain.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE pref_posts SET guid = replace(guid, 'https://www.olddomain.com', 'https://www.newdomain.com');
UPDATE pref_posts SET post_content = replace(post_content, 'https://www.olddomain.com', 'https://www.newdomain.com');

    note: Edit ‘pref’ (three places above) to your own table_prefix and change ‘https://www.olddomain.com’ and ‘https://www.newdomain.com’ as required (three places each and with no trailing slashes).

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Can't edit wordpress after changing domain in settings-general’ is closed to new replies.