Posted 2 months ago #
Per blog theme setting suddenly stopped working after upgrade to 2.8.1a. No matter how many times I click the checkbox next to theme name and save, the changes are not saved.
Does anyone know which MYSQL entry has this information? Since I can't change via the admin page, I'd like to try if I can manually set via phpmyadmin.
Hm...works for me. But, it's not totally intuitive. It enables themes for a specific blog that are disabled site-wide. So, if you have all your themes enabled site-wide, then using site admin > blogs > edit > theme isn't going to do anything. (I'm assuming that's the real path you're talking about, right?)
Anyway, the value is stored in that blogs options tables, so in wp_[blogid]_options table look for an option called "allowed themes." Here's an example of allowing the Andreas theme:
a:1:{s:12:"wp-andreas01";s:2:"on";}
Posted 2 months ago #
I found out the database entry last night, but the entry looks encrypted to me. :-)
Does anybody know what each number means?
a:1:{s:12:"wp-andreas01";s:2:"on";}
Posted 2 months ago #
a:1:{s:12:"wp-andreas01";s:2:"on";}
That is a smart query, or a PHP-serialized list of values. You can use the PHP function unserialize to break that back down into its original form and manipulate it. Then serialize it again and store it in the database.
"s:12:"wp-andreas01""
String coming up:12 characters in length "wp-andreas01" (which has 12 characters)
So, s:2:"on" mean a strin gof 2 characters, with a value of "on".
You must log in to post.
