[Resolved] Widgets disappeared after running an SQL query to update links
This is my first post here, but I’ve been using the forums for years to muddle through my own tech problems. I can’t find a solution to this problem though!
Today I asked my web host to move my website to a new domain, which they did without problem. The old URL (still online) is http://www.mslogica.com. The new URL (also online) is http://www.planetmillie.com.
Having read instructions about moving websites between domains, I knew that I would have to update the URLs within my site once the database had been moved.
I went on the database once the move had been done, and ran the following three SQL queries through phpMyAdmin. I had read on the web that this would update the links across the whole website:
UPDATE wp_options SET option_value = REPLACE(option_value, ‘http://mslogica.com‘, ‘http://planetmillie.com‘)
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, ‘http://mslogica.com‘, ‘http://planetmillie.com‘)
UPDATE wp_posts SET guid = REPLACE(guid, ‘http://mslogica.com‘, ‘http://planetmillie.com‘)
Since I did this, all the widgets have disappeared from my site. If you have a look at http://www.planetmillie.com, you’ll see there is no left hand column. It appears that the URLs within the posts was updated as intended, as the image file paths have changed (if you inspect the element of any images within posts, they come up as hosted at “planetmillie.com/….”).
I have logged into the WordPress admin area of my site and the widget boxes have actually disappeared from the admin area too. They’re not in the inactive or the active widgets list.
Does anyone know which SQL query might have caused the widgets to disappear, and more importantly, does anyone know how to fix it??
I don’t know if it matters, but I’m running a child theme of Twenty Twelve which I created myself. I can’t see any other errors at the moment except that I appear to have also taken my self-hosted email address offline with the same SQL queries, but I will worry about that later!
- The topic ‘[Resolved] Widgets disappeared after running an SQL query to update links’ is closed to new replies.