Possible Bug. All theme settings are blown away when updating domain url thorugh the WP DB.
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
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.