Unable to login to Administrator back-end
Posted: Thu Apr 13, 2017 6:30 pm
The website has been restored on a new server. The website itself works OK but I unable to login to Administrator. When trying to login with the correct password, it shows the original login page.
When I try to login with the wrong password an error message is displayed - so this is good.
After I set $debug= '1' in configuration.php, one of the queries that is shown is
UPDATE `jos_session`
SET `time`='1492106615',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='1',`data`='__default|a:7:{s:15:\"session.counter\";i:3;s:8:\"registry\";O:9:\"JRegistry\":3:.........etc
When I do the same on a working joomla login, the query looks different
UPDATE `jos_session`
SET `time`='1492106534',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',.......etc
I suspect that some in formation in user related tables got messed up (because I had to restore a few tables that were corrupt) and it does not recognize Admin as Admin.
Please help me figure it out.
Thank you
When I try to login with the wrong password an error message is displayed - so this is good.
After I set $debug= '1' in configuration.php, one of the queries that is shown is
UPDATE `jos_session`
SET `time`='1492106615',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='1',`data`='__default|a:7:{s:15:\"session.counter\";i:3;s:8:\"registry\";O:9:\"JRegistry\":3:.........etc
When I do the same on a working joomla login, the query looks different
UPDATE `jos_session`
SET `time`='1492106534',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',.......etc
I suspect that some in formation in user related tables got messed up (because I had to restore a few tables that were corrupt) and it does not recognize Admin as Admin.
Please help me figure it out.
Thank you