Forums

Fatal Error help

Permalink
I tried upgrading my version of concrete5 and now my site is down. Below is the error message I receive. Where do I start in order retrieve my old version and restore the site the way it was.

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1054: Unknown column 'logUserID' in 'field list'] in EXECUTE("insert into Logs (logType, logText, logIsInternal, logUserID) values ('exceptions', 'Exception Occurred: /home/rivolife/cometotheriver.com/updates/concrete5.6.3.2/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysqlt error: [1146: Table \'cometotheriver_com.PermissionKeys\' doesn\'t exist] in EXECUTE("select pkID, pkName, pkDescription, pkHandle, pkCategoryHandle, pkCanTriggerWorkflow, pkHasCustomClass, PermissionKeys.pkCategoryID, pkCategoryHandle, PermissionKeys.pkgID from PermissionKeys inner join PermissionKeyCategories on PermissionKeyCategories.pkCategoryID = PermissionKeys.pkCategoryID")\n (1146)\n\n#0 /home/rivolife/cometotheriver.com/updates/concrete5.6.3.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw(\'mysqlt\', \'EXECUTE\', 1146, \'Table \'cometoth...\', \'select pkID, pk...\', false, Object(ADODB_mysqlt))\n#1 /home/rivolife/c in /home/rivolife/cometotheriver.com/updates/concrete5.6.3.2/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
 
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Take a look at this thread, should be just what you need..
https://www.concrete5.org/community/forums/installation/fatal-error-...
Myq replied on at Permalink Reply
Myq
You can add the missing column to the database by running the following SQL command through PHPMyAdmin or the MySQL command line:
ALTER TABLE
    Logs
ADD COLUMN 
    logUserID INT(10) UNSIGNED
AFTER
    logIsInternal;

Then request <your-domain>/index.php/tools/required/upgrade?force=1 to continue the upgrade process.