Upgrade failed to 5.6
Permalink
My upgrade to 5.6. failed utterly!!
I used Softaculous on my web suppliers site.
I get the following error after the installation completed, it seems like a column in the database is missing...:
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 = 'Main' and CollectionVersionBlocks.cID = '124' and (CollectionVersionBlocks.cvID = '2' or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = '14'")
I used Softaculous on my web suppliers site.
I get the following error after the installation completed, it seems like a column in the database is missing...:
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 = 'Main' and CollectionVersionBlocks.cID = '124' and (CollectionVersionBlocks.cvID = '2' or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = '14'")
Always best to upgrade manually. Hopefully you made a backup before the upgrade...
I can only agree, it's best to do it manually, if you can choose. The upgrade worked on one of my two sites. :-(
I remembered to take a backup, though :-)
I remembered to take a backup, though :-)
I tied to navigate back to my "upgrade page"
After a while I got OK from the installation (Your upgrade to 5.6 was successful) and the site is up and running... :-) :-)
http://www.yourwebsite.com/index.php/tools/required/upgrade?source=dashboard_update
After a while I got OK from the installation (Your upgrade to 5.6 was successful) and the site is up and running... :-) :-)
Hi,
I am from the Softaculous team. We do provide the URL to upgrade the database :
so that the user can visit it upgrade the database.
Did you get that URL on the upgrade page ?
I am from the Softaculous team. We do provide the URL to upgrade the database :
http://www.yourwebsite.com/index.php/tools/required/upgrade?source=dashboard_update
so that the user can visit it upgrade the database.
Did you get that URL on the upgrade page ?
