Settings won't save

Not too sure why this would be – how was the database moved from dev to live?

Thanks for your quick response. I just did a SQL dump from the dev site and imported it into the live site (phpMyAdmin interface on both ends). I did have to set the file to be compatible with MySQL40 because I ran into with the live site rejecting the “utf8mb4_unicode_ci” character set. Then I used searchreplacedb2 (InterconnectIT.com) to replace the dev URL with the live URL. Done this countless times before without incident–including sites with this plugin. The only difference this time was the compatibility issue on the receiving end.

Weirder still is that the options technically DO save to the database; I see them in the _options table. The plugin just doesn’t seem to see them, and thus doesn’t work.

Sorry – don’t have any suggestions here – I’ve used the plugin in a number of sites and migrated the dbs manually and via deploy tools and not come across this issue – please let me know if you do find a resolution.

Unfortunately, I had to use a different solution for this project. Technically, this issue is “resolved”.

FWIW – I came across this issue on an old site I inherited, seems that the issue is to do with the wp_options table and its format.

Specifically in wp-config.php I had this defined

/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');

But the wp_options table was set to latin_swedish

I changed it to match utf8

So you can either comment out the constant in wp-config.php, probably a bad idea, better to change the collation on the table to match the constant.

Much appreciated! Will keep it in mind if I run into this problem again.