Reset eveyone's theme settings via database query?

[<?netwire>]

Hello, I'm wanting to reset the theme that all members have selected by using a database query. The reason is that I have recently re-installed 1.1.4 using a backup after a crash and we now do not have some themes we once did and people are getting copyright errors from what looks like the classic theme (not altered in any way, just downloaded with webinstall).

[perplexed]

hve you tried resetting everyone's theme via the admin panel?

admin > configuration > themes and layout >  reset everyone to...

[<?netwire>]

hve you tried resetting everyone's theme via the admin panel?

admin > configuration > themes and layout >  reset everyone to...

I cannot do that because my theme for my account was set to one that is no longer in place. When I login it takes me to the classic style theme with the copyright error.

[perplexed]

do you have the default theme installed?  if so try tacking ?theme=1 on to the end of your forum url

or to get to the admin panel

http://www.yoursite.com/forum/index.php?action=admin;theme=1



edited to fix typo

[<?netwire>]

Hmm, I was poking around with the themes table and noticed that some of the values refered to old themes that where no longer in place so I changed them to the default ones... now the page loads blank. Any thoughts?

[greyknight17]

Do you have any mods installed on your forum or those that you don't mind reinstalling again? If you don't mind losing them and reinstalling, I suggest uploading fresh theme files again to make sure you don't run into these issues again. Use repair_settings.php and make sure that the database information is correct. Then click on the Recommended values. Save the changes. That should restore your forum back to working order. Delete the repair_settings.php file once you are done.