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'")
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'")
JohntheFish--> THANK YOU! Solved my problem lickety split.
Phew! Thank you JohntheFish. Got me out of a sticky wicket there. I'll never trust MOJO Marketplace upgrade scripts again.
Cheers
Cheers
To quickly jump back to a previous version, you can edit the version number in the /config/site.php
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.
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.
That's handy mate. Haven't had to do it yet, but good info...
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/...