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 Attachment

 
VPenkov replied on at Permalink Reply
VPenkov
There's no straightforward way to resolve your issue, it would require step-by-step debugging.
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.
hutman replied on at Permalink Reply
hutman
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.
jmlitch99 replied on at Permalink Reply 1 Attachment
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.
hutman replied on at Permalink Reply
hutman
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-...
Myq replied on at Permalink Reply
Myq
You can add the missing column to the database by running the following SQL command:
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.