Error migrating from 5.7.0.4 to 5.7
Permalink 1 user found helpful
Grabbed the latest download. Uploaded to site. Extracted files then moved them to my web site directory (public_html) on cPanel type system. Change permissions of the folders to 777. Tried accessing the web site and I get the following error message:
An unexpected error occurred.
An exception occurred while executing 'select CollectionVersionBlocks.isOriginal, CollectionVersionBlocks.cbIncludeAll, Blocks.btCachedBlockRecord, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbOverrideBlockTypeCacheSettings, 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 = ? and CollectionVersionBlocks.cID = ? and (CollectionVersionBlocks.cvID = ? or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = ?' with params ["Main", "139", "1", "49"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CollectionVersionBlocks.cbOverrideBlockTypeCacheSettings' in 'field list'
< Back to Home
I can get to the login page and I can access the admin menu. I did try "cleaning the cache" but no joy, still get this same error each time I attempt to access the "live" site. I can see that the site map has my pages in it, but I can't access any of those pages without getting this error.
An unexpected error occurred.
An exception occurred while executing 'select CollectionVersionBlocks.isOriginal, CollectionVersionBlocks.cbIncludeAll, Blocks.btCachedBlockRecord, BlockTypes.pkgID, CollectionVersionBlocks.cbOverrideAreaPermissions, CollectionVersionBlocks.cbOverrideBlockTypeCacheSettings, 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 = ? and CollectionVersionBlocks.cID = ? and (CollectionVersionBlocks.cvID = ? or CollectionVersionBlocks.cbIncludeAll=1) and CollectionVersionBlocks.bID = ?' with params ["Main", "139", "1", "49"]: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'CollectionVersionBlocks.cbOverrideBlockTypeCacheSettings' in 'field list'
< Back to Home
I can get to the login page and I can access the admin menu. I did try "cleaning the cache" but no joy, still get this same error each time I attempt to access the "live" site. I can see that the site map has my pages in it, but I can't access any of those pages without getting this error.
Yes, this is an undocumented change to the upgrade procedure. Performing backups is now a permission that can be assigned in the task permissions section of the dashboard. Unless you're logged in as the super user or someone who can perform the upgrade you won't be able to get to that page. (Note: there is a config switch you can throw in an emergency to disable this permission check.)
<yoursite>/index.php/login
<yoursite>/index.php/ccm/system/upgrade
Ran the script and now all is fine.