Need to turn theme off through database - how?

Posted by Jupiter on August 4, 2007 at 2:27pm

Hello,

I modified the niftyCorners theme. While preparing for the update to 5.2, I attempted to turn off my niftyCorner mod, but something went wrong (surprise, surprise, hehehe...).

I'd like to either disable the theme from the database (I haven't found the field yet), generaly or by forcing the garland theme on my user's line in the theme field.

What should I put in the theme field in the user table for my user?

Description of my problem - For some reason, the theme does not show any content, forms, etc, and now I can't change the theme in my profile to garland (or do anything else for that matter).

Interestingly, I am having another simultaneous problem which prevents me from modifying the content of my sites/all/themes folder - and only that folder, 553 permission denied - which prevents me from overwriting the custom theme files with the original niftyCorners files to see if that helps.

Thanks for any help!

Comments

Better way

Posted by yelvington on August 4, 2007 at 5:20pm

Remove the theme directory (move it elsewhere on the server). Log in as admin, deauthorize the theme, move it back, begin your repair work.

Thanks! I also found for

Posted by Jupiter on August 4, 2007 at 7:16pm

Thanks! I also found for anybody who finds this post because of a similar problem regarding niftyCorners :

http://drupal.org/node/131927

1. go to /themes/niftyCorners

2. replace all "form_render" with "drupal_render" in niftyCorners template.php file

3. save and replace template.php file in themes/niftyCorners

My site crashed, but this helped

Posted by abhinya on February 26, 2009 at 12:12pm

My site crashed, but this helped
abhinya - February 26, 2009 - 17:41
new

While playing with the themes, i messed pretty bad.
The best part is i damaged the production site.

I go to the site and we all were getting blank page.
chaning the database name did not help so had to try out some thing.

Went to the themes folder and deleted the theme that was configured as default

Next went to
http://www.yoursite.com/admin/build/themes
and changes to another available theme as default theme

Now the site was back on line (Gods Grace)

Next uploaded a fresh folder of the original theme

then went back and change to the theme that i messed up with in the first place.

thank God the site came Back.

Two things:

1. Thank you guys for the forum and the answers
2. some times we might have to sit back and see where the error could happen.
3. we need to seal all site configuration changes and then neven touch the production site untill every thing is tried and tested and sanctioned.

Almost lost my JOB

Insha Allah

Regards
Abhinya

Right - I have copies of the

Posted by Jupiter on February 28, 2009 at 5:13pm

Right - I have copies of the theme from which to work when I'm doing theme work on a production site. If I'm working with a theme called bigtheme, I'll make a copy called bigtheme_dev and work on that. Normally all will work fine unless some paths are hard coded of theme functions use the theme name instead of phptemplate.

This worked for me

Posted by unlvincent on September 15, 2009 at 2:34pm

I was having the same problem with a theme and found this post on how reset the theme back to a working theme via the database:

http://drupal.org/node/200774

Worked great!

System Table

Posted by ishmael-sanchez on September 16, 2009 at 1:35am

In the system table you can turn on and off themes and modules. Browse the table and edit the record, status 1 means the theme or module is on, status 0 it's off. Good luck!