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 [Links visible only for registered users] plugin instead which is compatible with serialized tables.