TOTAL DISASTER!!!

Permalink
Hey Guys,

I updated to 5.6.0 but I didnt like it, so I tried to restore to the backup I made before I updated, but when I did I got this "Fatal Error" thing.

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'logUserID' in 'field list'] in EXECUTE("insert into Logs (logType, logText, logIsInternal, logUserID) values ('exceptions', 'Exception Occurred: /home/tcswebhost/electricbaboontattoo.com/updates/concrete5.6.0.2/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysql error: [1054: Unknown column \'ptID\' in \'field list\'] in EXECUTE("select cvID, cvIsApproved, cvIsNew, cvHandle, cvName, cvDescription, cvDateCreated, cvDatePublic, cvAuthorUID, cvApproverUID, cvComments, ptID, CollectionVersions.ctID, ctHandle, ctName from CollectionVersions left join PageTypes on CollectionVersions.ctID = PageTypes.ctID where cID = \'1\' and cvID = \'4\'")\n (1054)\n\n#0 /home/tcswebhost/electricbaboontattoo.com/updates/concrete5.6.0.2/concrete/libraries/3rdparty/adodb/adodb.inc.php(1037): adodb_throw(\'mysql\', \'EXECUTE\', 1054, \'Unknown column ...\', \'select cvID, cv...\', false, Object(ADODB_mysql))\n#1 /home/tcsw in /home/tcswebhost/electricbaboontattoo.com/updates/concrete5.6.0.2/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78


If Someone could help me as soon as possible, that would be greatly appriciated.

Thanks,
Webmaster64

Webmaster64
View Replies:
Phallanx replied on at Permalink Reply
Phallanx
Did you delete the reference to the update in the site.php?

It will be something like
<?php define('DIRNAME_APP_UPDATED', 'cc5600');?>
Webmaster64 replied on at Permalink Reply
Webmaster64
No.

Should I have?
Phallanx replied on at Permalink Reply
Phallanx
@Webmaster64
Yes. That entry tells Concrete5 which core to use.

You will find it in
[root]/config/site.php

Delete that entry in the file, and Concrete5 will revert to the old core.

The issue *maybe* that you are still using the new core which is accessing fields in the database that no longer exist because you have reverted the database.
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;

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