Cannot put site back On-Line, Cannot reach site-maintenance page.

Posted by MurrMo on November 24, 2012 at 4:11pm

I took my drupal site off-line and now cannot reach the site-maintenance page to bring it back on-line.
When I go to

mysite.com/admin/settings/site-maintenance

I see the "operating in offline mode"

and below a message

"There are security updates available for one or more of your modules or themes..." I would appreciate anyone's assistance as my site has been off-line for a few days and I cant seem to understand what the issue is.

Comments

=-=

Posted by VM on November 24, 2012 at 6:02pm

this post belongs in the post installation forum. Please edit the opening post and move it. Thanks.

Post Moved thanks for the

Posted by MurrMo on November 25, 2012 at 11:09pm

Post Moved thanks for the heads up mate

=-=

Posted by VM on November 25, 2012 at 11:24pm

make sure you are logged in to the site first, yoursite.com/?q=user/login

yes i am logged in, and still

Posted by MurrMo on November 25, 2012 at 11:31pm

yes i am logged in, and still cannot reach the site-maintenance page. As well, when i select some of the admin menus it says "you do not have any administrative items"

=-=

Posted by VM on November 25, 2012 at 11:36pm

are you sure you are logged in as user 1?

else you will have to do this manually in the db in the variables table by settings the row site_offline to a status of 0.

back up the DB first.

I am user 3, but do have

Posted by MurrMo on November 25, 2012 at 11:37pm

I am user 3, but do have administrative access.

=-=

Posted by VM on November 26, 2012 at 12:05am

evidently not enough administration access. Log in as UID 1 and test.

I appreciate your assistance.

Posted by MurrMo on November 26, 2012 at 11:18pm

I appreciate your assistance. But is there a way to retrieve UID 1 login info? We could continue this convo on skype?

=-=

Posted by VM on November 27, 2012 at 5:46am

from the user table of the database. may need to alter the email address, note the username and request a new password as the password in the DB is salted.

I got into the Database,

Posted by MurrMo on November 27, 2012 at 9:35pm

I got into the Database, Altered the email, and noted the USER, but how do I reset User1 password?
*at mysite.com/user when I click "request new password" it takes me to the "Site Off-Line" Page.*

=-=

Posted by VM on November 27, 2012 at 11:06pm

makes sense totally forgot about the site being offline. see: http://drupal.org/node/1023428 for resetting admin password

Ive successfully attained UID

Posted by MurrMo on November 27, 2012 at 11:11pm

Ive successfully attained UID login info, I am logged in as UID 1 but still cannot reach mysite.com/admin/settings/site-maintenance.
The "Site Configuration" page just pops up and displays the same page with the following message:

"Operating in off-line mode." <--- clicking this just refreshes page*
"There are security updates available for one or more of your modules or themes. To ensure the security of your server, you should update immediately! See the available updates page for more information."

Actions
.....
ImageAPI
.....
JStats
Logging and alerts
......

=-=

Posted by VM on November 27, 2012 at 11:30pm

edit settings.php are you forcing the site offline through a conf setting?

http://drupal.org/node/264476

thank you for your continued

Posted by MurrMo on November 28, 2012 at 10:57pm

thank you for your continued help, I managed to get into the database and set site_offline to s:1'0' but don't understand what it means to "drop row variables in 'cache' table" could you please explain how I can do that or if it is even necessary ?

=-=

Posted by VM on November 29, 2012 at 12:48am

clear the cache, it will regenerate