This isn't exactly related the the plugin, but I do need some help with a default theme mess I've gotten myself into.
Prior to activating the Default Blogs Template plugin – which works great, thank you very much – I had been setting the default theme for all blogs by renaming the twentyten folder and then naming my default theme's folder twentyten. Then came twentyeleven and I finally got around to implementing the Default Blogs Template.
My problem now is that many existing blogs throw the blank white page of doom with an Appearance notice that the "theme is broken". Easily fixed, but members freak out thinking their blog is gone. The other issue is that other existing non-supporter blogs are now using the Twenty Eleven theme, which we have enabled only for Supporters.
So my question: Is there any way to easily determine which blogs are using what themes without looking at them all (2700+) individually? Perhaps via PHP MyAdmin? Any way to identify which blogs are using twentyten? This would at least help me narrow down which blogs I need to fix.
Thanks.
NOTE TO ALL: Consider this a strong recommendation for using the Default Blogs Template or Default Theme plugin rather than renaming your default theme folder! :-\
This isn't exactly related the the plugin, but I do need some help with a default theme mess I've gotten myself into.
Prior to activating the Default Blogs Template plugin – which works great, thank you very much – I had been setting the default theme for all blogs by renaming the twentyten folder and then naming my default theme's folder twentyten. Then came twentyeleven and I finally got around to implementing the Default Blogs Template.
My problem now is that many existing blogs throw the blank white page of doom with an Appearance notice that the "theme is broken". Easily fixed, but members freak out thinking their blog is gone. The other issue is that other existing non-supporter blogs are now using the Twenty Eleven theme, which we have enabled only for Supporters.
So my question: Is there any way to easily determine which blogs are using what themes without looking at them all (2700+) individually? Perhaps via PHP MyAdmin? Any way to identify which blogs are using twentyten? This would at least help me narrow down which blogs I need to fix.
Thanks.
NOTE TO ALL: Consider this a strong recommendation for using the Default Blogs Template or Default Theme plugin rather than renaming your default theme folder! :-\
NOTE TO ALL: Consider this a strong recommendation for using the Default Blogs Template or Default Theme plugin rather than renaming your default theme folder! :-\
Responses (4)
Sales & Support Pro — 27th July 2011 17:15 #
Hiya!
Amen to that! ;)
Quite a pickle you've gotten into there but there is hope....
http://designgala.com/how-to-change-wordpress-theme-directly-from-database/
That link will tell you were to look in the database. It relates to single-site installs so you'll need to add the _n for each blog.
You could use a PHP script to loop through each wp_n_options table in your database, checking the values and changing them if necessary.
Highly recommend you do that on a test database first ;)
Phil
Member — 27th July 2011 22:36 #
Thanks! That is helpful. Now if only I can figure out how to write that script for looping through all of the sites. :-\
Sales & Support Pro — 28th July 2011 08:35 #
You'd need to write a PHP loop a bit like this;
That does assume that you know the number of wp_options tables and that they are numbered sequentially.
Phil
Member — 28th July 2011 13:47 #
Thanks again for your help.
Become a member