Login not working
Permalink
Hi all,
I made a site for a customer a couple of years back and have not been on it in a while. Nobody has logged in or made any changes to it and it has just been running fine. All of hte pages work and there are no problems with the links. I can not, however, loogin to the site any more. it gives the below message after I type in my login and password:
An unexpected error occurred.
mysql error: [1146: Table 'tissuepa_main.CollectionVersionBlockStyles' doesn't exist] in EXECUTE("select bID, arHandle, csrID from CollectionVersionBlockStyles where cID = '5' and cvID = '1' and csrID > 0")
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'tissuepa_main.Logs' doesn't exist] in EXECUTE("insert into Logs (logType, logText, logIsInternal) values ('exceptions', 'Exception Occurred: mysql error: [1146: Table \'tissuepa_main.CollectionVersionBlockStyles\' doesn\'t exist] in EXECUTE("select bID, arHandle, csrID from CollectionVersionBlockStyles where cID = \'5\' and cvID = \'1\' and csrID > 0")\n\n#0 /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw(\'mysql\', \'EXECUTE\', 1146, \'Table \'tissuepa...\', \'select bID, arH...\', false, Object(ADODB_mysql))\n#1 /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute(\'select bID, arH...\')\n#2 /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1543): ADOConnection->Execute(\'select bID, arH...\', Array)\n#3 /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1380): AD in /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Obviously there is a table missing but how the hell could that happen when nobody has been doing anything on the site at all????
I made a site for a customer a couple of years back and have not been on it in a while. Nobody has logged in or made any changes to it and it has just been running fine. All of hte pages work and there are no problems with the links. I can not, however, loogin to the site any more. it gives the below message after I type in my login and password:
An unexpected error occurred.
mysql error: [1146: Table 'tissuepa_main.CollectionVersionBlockStyles' doesn't exist] in EXECUTE("select bID, arHandle, csrID from CollectionVersionBlockStyles where cID = '5' and cvID = '1' and csrID > 0")
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'tissuepa_main.Logs' doesn't exist] in EXECUTE("insert into Logs (logType, logText, logIsInternal) values ('exceptions', 'Exception Occurred: mysql error: [1146: Table \'tissuepa_main.CollectionVersionBlockStyles\' doesn\'t exist] in EXECUTE("select bID, arHandle, csrID from CollectionVersionBlockStyles where cID = \'5\' and cvID = \'1\' and csrID > 0")\n\n#0 /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw(\'mysql\', \'EXECUTE\', 1146, \'Table \'tissuepa...\', \'select bID, arH...\', false, Object(ADODB_mysql))\n#1 /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(993): ADOConnection->_Execute(\'select bID, arH...\')\n#2 /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1543): ADOConnection->Execute(\'select bID, arH...\', Array)\n#3 /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb.inc.php(1380): AD in /home5/tissuepa/public_html/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
Obviously there is a table missing but how the hell could that happen when nobody has been doing anything on the site at all????
a) Take a database backup of what you currently have
b) Check whether the tables are actually there or not
Hosts change the environment your site executes in, like changing php versions, apache versions and mysql versions. It may be that a change by your host has affected one of these.