URGENT PROBLEM

Permalink
I have updated concrete 5 and making a backup before and the update seems to have broken the website i get error

mysql error: [1054: Unknown column 'Blocks.btCachedBlockRecord' in 'field list'] in EXECUTE("select CollectionVersionBlocks.isOriginal, Blocks.btCachedBlockRecord, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbDisplayOrder, Blocks.bIsActive, Blocks.bID, Blocks.btID, bName, bDateAdded, bDateModified, bFilename, btHandle, Blocks.uID from CollectionVersionBlocks inner join Blocks on (CollectionVersionBlocks.bID = Blocks.bID) inner join BlockTypes on (Blocks.btID = BlockTypes.btID) where CollectionVersionBlocks.arHandle = 'Sidebar' and CollectionVersionBlocks.cID = '1' and (CollectionVersionBlocks.cvID = '72' or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = '25'")

senatetraining
 
JohntheFish replied on at Permalink Best Answer Reply
JohntheFish
That looks like the updater did not complete or was not run. The missing column is added to the table in 5.6.0+ for the new cache mechanism.

This howto gives info on running the update manually:
http://www.concrete5.org/documentation/how-tos/developers/manually-...

The part you need is probably
"Method 2, Step 2: Run the upgrade script manually"

But you may have to run through other parts of the process.

You also need to not jump too many c5 versions in the upgrade process, see a about 1/3 of the way down:
http://www.concrete5.org/developers/downloads/...
imJack replied on at Permalink Reply
imJack
JohntheFish--> THANK YOU! Solved my problem lickety split.
acurrall replied on at Permalink Reply
acurrall
Phew! Thank you JohntheFish. Got me out of a sticky wicket there. I'll never trust MOJO Marketplace upgrade scripts again.
Cheers
TheRealSean replied on at Permalink Reply
TheRealSean
To quickly jump back to a previous version, you can edit the version number in the /config/site.php

//ie
//My current site is running 
define('DIRNAME_APP_UPDATED', 'concrete5.6.1.2_updater');
//if I change it to be my previous version
define('DIRNAME_APP_UPDATED', 'concrete5.6.0.1');
//the version must be present in your /root/updates/concere5.X.X


This will change the version used it will not fix the issue but can get you out of a sticky situation whilst you resolve the problem.
PatrickCassidy replied on at Permalink Reply
PatrickCassidy
That's handy mate. Haven't had to do it yet, but good info...