Tried restoring backup and the site is gone
Permalink
Help!
I saved a backup of the website before I installed a necessary update. The update looked fine, but one of my pages wasn't loading correctly. So I decided to load and restore my back up. When I tried that, things only got worse.
Now theres nothing on my website except for some error code that says,
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 = 'Header Image' and CollectionVersionBlocks.cID = '1' and (CollectionVersionBlocks.cvID = '64' or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = '28'")
Can someone tell me what this means and what I need to do.
I saved a backup of the website before I installed a necessary update. The update looked fine, but one of my pages wasn't loading correctly. So I decided to load and restore my back up. When I tried that, things only got worse.
Now theres nothing on my website except for some error code that says,
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 = 'Header Image' and CollectionVersionBlocks.cID = '1' and (CollectionVersionBlocks.cvID = '64' or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = '28'")
Can someone tell me what this means and what I need to do.
There might be different or added tables and/or table columns in a newer version and when you restore the old database to a new core you might get errors like this.
You could go back to your earlier core version and restore your database again to get your site up and running. You can post here again when your site is up and we can try to help you out with the page that is not working as expected.