By scott@romack.net on

I did an install (actually a Mediatemple 1 click install) and did the obvious thing while learning.
I clicked the take site offline button. this is a very silly 'feature'.
Anyway where is this stored in the database so i can get my site back up??

this is kinda a big deal as i'm doing this for a client!

⋅ Categories: Drupal 6.x

Comments

Moonshine’s picture

Moonshine commented

You'll need it at some point. :) Assuming you're still logged in as the 'admin' you should be able to see all the pages and use the admin pages to toggle it back online. If you're not logged in then got to /user to do so. This is from the admin page:

When set to "Online", all visitors will be able to browse your site normally. When set to "Off-line", only users with the "administer site configuration" permission will be able to access your site to perform maintenance; all other visitors will see the site off-line message configured below. Authorized users can log in during "Off-line" mode directly via the user login page.

scott@romack.net’s picture

scott@romack.net commented

i already hacked my db to clear it out.
for posterity,
there is a table called drupal_variable with a row called site_offline with a value of s:1'1' set it to s:1'0'
go to table drupal_cache and drop row variables
and your back in...

Yes /user lets you in..

cog.rusty’s picture

cog.rusty commented

By the way, you can find a handy feature in the comments in settings.php file, line 173 (the $conf array), where you can temporarily override any variable of the variables tables without going to the database (assuming you know the variable's name).

narenpg’s picture

narenpg commented

I installed drupal6 and it was working fine. I changed mysql host from localhost to remotehost and then changed back to localhost. Now it is showing site off-line. I tried the sql queries to update the variable, but it is still showing site off-line. Can you please help me?