Page 1 of 1

Locked out of Admin, can I enable Maintenance Mode via ftp?

Posted: Fri Feb 07, 2014 6:45 am
by TAC
Hi,

I am having some awful problems with 4 websites in this thread http://forum.opencart.com/posting.php?m ... 0&t=118826

I was at Spring Fair yesterday and gave out loads of my business cards and my sites look a mess :(

I am locked out of Admin too so want to know if I can enable Maintenance Mode via ftp somehow?

Thank you :)

Re: Locked out of Admin, can I enable Maintenance Mode via f

Posted: Fri Feb 07, 2014 7:00 am
by ThePath
What do you mean you are locked out of the admin? Does that mean your username/pass doesnt work anymore or you dont see the login screen at all?

Looks like you are getting a lot of log errors etc. You say its different versions of OC you are running and getting same errors...definitely seems to be a hosting issue in my eyes. Reckon you are getting fobbed off by them.

If you can see the admin login page however you could use phpmyadmin to change your username and/or password or there is a way to access admin with a wee trick using ftp if you can see the login screen.

Re: Locked out of Admin, can I enable Maintenance Mode via f

Posted: Fri Feb 07, 2014 7:04 am
by TAC
Thank you ThePath, I can see the admin screen, just cannot login. I think I've added that to the other thread now.

Re: Locked out of Admin, can I enable Maintenance Mode via f

Posted: Fri Feb 07, 2014 7:08 am
by TAC
I have been back to the hosts and said:

"I have posted this in the OC forums and they seem to think it is a hosting problem as there is no reason for 3 different versions of OC to suddenly throw errors on 3 different domains and 4 different installations..... "

Re: Locked out of Admin, can I enable Maintenance Mode via f

Posted: Fri Feb 07, 2014 8:52 am
by nvedia
using phpmyadmin
set the "config_maintenance" option in the setting table to 0

Re: Locked out of Admin, can I enable Maintenance Mode via f

Posted: Sat Feb 08, 2014 2:32 am
by TAC
Thank you nvedia,

Do you mean the one in this image?
Screen Shot 2014-02-07 at 18.28.50.png

Screen Shot 2014-02-07 at 18.28.50.png (57.6 KiB) Viewed 3946 times

If so, that was already set to 0.

Re: Locked out of Admin, can I enable Maintenance Mode via f

Posted: Sat Feb 08, 2014 5:19 am
by butte
(1) TAC, that might have been a slip, try maintenance as 1 (I'll look in a moment at one).

NOT-MAINTENANCE IS 0 AND MAINTENANCE IS 1. In phpMyAdmin just go to the table named setting (there may be a prefix like oc_) and then find the record (row) for config_maintenance, then in the value field (column, usually right side) find the cell where they intersect (field x record, column x row), and in that cell edit the 0 to 1.

(2) Back up database(s) now, using phpMyAdmin / Export. Before (3).

(3) As for getting in, remember (you've seen it before) ocreset.php, there is no mail, admin pass is reset on the spot. Download at http://www.jaygilford.com/download/ocreset but first read instructions at http://forum.opencart.com/viewtopic.php?t=15626. Be certain to delete it afterward.

(4) Your OP link goes to an edit page, difficult to navigate. You evidently mean your http://forum.opencart.com/viewtopic.php ... 15#p474484 in his http://forum.opencart.com/viewtopic.php ... 15#p472487.

(5) Those problems owe to server or hacker. You already long since turned off error reporting (to screen), in more than one OC. Several of different vintages went inexplicably bonkers, inexplicably at once, without your having helped. There may have been a php.exe, Plesk, phpMyAdmin, or mysql upgrade done. Support is obviously not being either straight or helpful. If you look at your host's own landing or inside Plesk you should find a URL for server status. If the server was down or being upgraded, explanations will be very short. Since they are coming back one by one, odds shift toward the host being responsible, but you won't rule out hacking without seeing it in ftp and Plesk.

Note http://forum.opencart.com/viewtopic.php ... 64#p474764 . . .

Re: Locked out of Admin, can I enable Maintenance Mode via f

Posted: Sat Feb 08, 2014 9:45 pm
by TAC
Thanks yet again butte :)

Yes the link was wrong, thank you for the correction.

I didn't put the sites into maintenance mode after all as the host 'fixed' them. It may be a temporary fix and the discussion continues in http://forum.opencart.com/viewtopic.php?f=20&t=118826

I am in the middle of a reply on that thread :)

Re: Locked out of Admin, can I enable Maintenance Mode via f

Posted: Sun Feb 09, 2014 3:31 am
by butte
You might still try using phpMyAdmin to change 0 to 1 and back to 0, so that you can just do it whenever you might need to reset that without admin access.

Ditto, add there (http://forum.opencart.com/viewtopic.php ... 92#p474992).