Issues with Concrete5 and Database
1) When we try to run a back-up through the Concrete5 Admin, we keep getting an error, Server Error 500. Attached is a screen shot of the error.
2) We have been trying to update to 18.104.22.168 however, every time we try, our site goes down. I reached out to our server company (Liquidweb) and they are seeing the following error message. They said that it appears that the upgrade process for Concrete5 is not updating the database with the proper rows (there are missing columns in the database).
[10-Feb-2016 16:21:25 UTC] PHP 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/atayne/public_html/updates/concrete22.214.171.124/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysqlt 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 \\\'iframe\\\'. Could not find package controller file: \\\'/home/atayne/public_html/packages/iframe/controller.php\\\'\\n\', 0, NULL)")\n (1054)\n\n#0 /home/atayne/public_html/updates/concrete126.96.36.199/concrete/libraries/3rdparty/adodb/adodb.inc.php(1074): adodb_throw(\'mysqlt\', \'EXECUTE\', 1054, \'Unknown column ...\', \'insert into Log...\', false, Object(ADODB_mysqlt))\n#1 /home/atayne/public_html/updates/concrete188.8.131.52/concrete/libraries/3rdpart in /home/atayne/public_html/updates/concrete184.108.40.206/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
If any one has any thoughts on why this is happening it would be great.
I can do this for you but I'm gonna need FTP access to your website.
If you are comfortable with this, drop me a PM.
To upgrade from 220.127.116.11 you will need to go to 5.6.0, 5.6.3 and then the newest version, you can't do it all in one jump. If you have Advanced Permissions turned on in your current version you will want to upgrade to 5.6.0 and then re-enable as permissions were completely reworked from 5.5 to 5.6.
ALTER TABLE Logs ADD COLUMN logUserID INT(10) UNSIGNED AFTER logIsInternal;
You could also use PHPMyAdmin or some other GUI to create a logUserID column like that in the Logs table.
Then request <your-domain>/index.php/tools/required/upgrade?force=1 to continue the upgrade process.