Issues with Concrete5 and Database
Permalink
We are running version 5.5.2.1 and seem to be having issues between Concrete5 and our database. A couple add things are happening.
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 5.6.3.3 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/concrete5.6.3.3/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/concrete5.6.3.3/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/concrete5.6.3.3/concrete/libraries/3rdpart in /home/atayne/public_html/updates/concrete5.6.3.3/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.
Thanks,
Jeremy
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 5.6.3.3 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/concrete5.6.3.3/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/concrete5.6.3.3/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/concrete5.6.3.3/concrete/libraries/3rdpart in /home/atayne/public_html/updates/concrete5.6.3.3/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.
Thanks,
Jeremy
Your Server 500 error is likely a timeout error if you site is bigger it will run longer than your server timeout.
To upgrade from 5.5.2.1 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.
To upgrade from 5.5.2.1 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.
Thanks for the response. The step update makes sense. There is only one issue. When I go into update in our admin panel, it only gives the option to update to 5.6.3.3. See attached.
This article has good step by step instructions on 2 different ways to upgrade your site, that should get you going in the right direction.
http://www.concrete5.org/documentation/how-tos/developers/manually-...
http://www.concrete5.org/documentation/how-tos/developers/manually-...
You can add the missing column to the database by running the following SQL command:
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.
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.
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.