Possible Bug. All theme settings are blown away when updating domain url thorugh the WP DB.

edited September 2016 in Other
Hello,

We were working on a clients site and when we went to switch the domains over, we went into the db and did a 

update wp_options set option_value=replace(option_value,'www.devsiteURL.com,'www.NewURL.com');

When this was done, all the theme options were reset to their defaults and we had to go in and change them all back. Any reason why this would happen?

-pxlounge

Comments

  • Hi,

    if you probably saw the database, inside options table, there is betheme tag where the following content is:

    a:276:{s:8:"last_tab";s:10:"custom-css";s:10:"responsive";s:1:"1";s:11:"nice-scroll";s:1:"1";s:13:"prev-next-nav";s:1:"1";s:5:"share";s:1:"1";s:19:"pagination-show-all";s:1:"1";s:13:"title-heading";s:1:"1";s:13:"page-comments";s:1:"0";s:10:"static-css";s:1:"0";s:8:"no-hover";s:0:"";s:13:"no-section-bg";s:0:"";s:17:"nice-scroll-speed";s:2:"40";s:11:"prettyphoto";s:10:"pp_default";s:17:"prettyphoto-title";s:1:"0";s:17:"prettyphoto-width";s:0:"";s:18:"prettyphoto-height";s:0:"";s:23:"math-animations-disable";s:1:"0";s:7:"mfn-seo";s:1:"1";s:16:"meta-description";s:27:"Just another WordPress

    it's serialized and this is the reason why your SQL request does not work. We recommend to use WP Migrate DB plugin instead which is compatible with serialized tables.
  • Thank you for the reply. I will make note of this in the future.
Sign In or Register to comment.