Forums

Update from 5.5 to 5.6 crashed my site

Permalink
Downloaded the offered updater. Backed up the database. Ran the updater and now every page shows this...

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqli error: [1054: Unknown column 'logUserID' in 'field list'] in EXECUTE("insert into Logs (logType, logText, logIsInternal, logUserID) values ('exceptions', 'Exception Occurred: /home/pranzare/public_html/_CoCoMR/updates/concrete5.6.3.5_remote_updater/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysqli error: [1054: Unknown column \'logUserID\' in \'field list\'] in EXECUTE("insert into Logs (logType, logText, logIsInternal, logUserID) values (\'packages\', \'Warning - failed to load package with pkgHandle \\\'cobalt\\\'. Could not find package controller file: \\\'/home/pranzare/public_html/_CoCoMR/packages/cobalt/controller.php\\\'\\n\', 0, \'1\')")\n (1054)\n\n#0 /home/pranzare/public_html/_CoCoMR/updates/concrete5.6.3.5_remote_updater/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw(\'mysqli\', \'EXECUTE\', 1054, \'Unknown column ...\', \'insert into Log...\', false, Object(ADODB_mysqli))\n#1 /home/pranzare in /home/pranzare/public_html/_CoCoMR/updates/concrete5.6.3.5_remote_updater/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
gewald
 
Myq replied on at Permalink Reply
Myq
It seems like this same issue might have been solved here:https://www.concrete5.org/community/forums/installation/fatal-error-...
Myq replied on at Permalink Reply
Myq
After some extra trial and error on this same problem, you can solve the problem like this:
add the missing column to the database by running the following SQL command:
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.