Getting error when upgrading C5
Permalink
I've been trying to upgrade a site from 5.3.x to 5.4.1 and keep getting this error:
An Unexpected Error occurred while upgrading: mysql error: [1054: Unknown column 'ocID' in 'Files'] in EXECUTE("alter table Files modify column ocID int unsigned not null default 0")
Now, if I go to another page in the site I get this message:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'Pages.cPointerExternalLinkNewWindow' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren, ctName, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = 1") ' in /home/joannear/public_html/test/updates/concrete5.4.1.1/concrete/lib in /home/joannear/public_html/test/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I've tried doing this 3 times now and keep getting the same result. If I move the site to a new directory, the site will show back up but will not be upgraded.
What could be causing this issue? How can I fix it? Do I need to modify or remove something from my database?
An Unexpected Error occurred while upgrading: mysql error: [1054: Unknown column 'ocID' in 'Files'] in EXECUTE("alter table Files modify column ocID int unsigned not null default 0")
Now, if I go to another page in the site I get this message:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'Pages.cPointerExternalLinkNewWindow' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cPointerExternalLinkNewWindow, Pages.cFilename, Collections.cDateAdded, Pages.cDisplayOrder, Collections.cDateModified, cInheritPermissionsFromCID, cInheritPermissionsFrom, cOverrideTemplatePermissions, cPendingAction, cPendingActionUID, cPendingActionTargetCID, cPendingActionDatetime, cCheckedOutUID, cIsTemplate, uID, cPath, Pages.ctID, ctHandle, ctIcon, ptID, cParentID, cChildren, ctName, cCacheFullPageContent, cCacheFullPageContentOverrideLifetime, cCacheFullPageContentLifetimeCustom from Pages inner join Collections on Pages.cID = Collections.cID left join PageTypes on (PageTypes.ctID = Pages.ctID) left join PagePaths on (Pages.cID = PagePaths.cID and PagePaths.ppIsCanonical = 1) where Pages.cID = 1") ' in /home/joannear/public_html/test/updates/concrete5.4.1.1/concrete/lib in /home/joannear/public_html/test/updates/concrete5.4.1.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I've tried doing this 3 times now and keep getting the same result. If I move the site to a new directory, the site will show back up but will not be upgraded.
What could be causing this issue? How can I fix it? Do I need to modify or remove something from my database?
Seems like this happens in helpers/concrete/upgrade/version_5411.php and the ocID column should already be there if the 541 upgrade is correctly run. Dunno, why it does not work.
You could try out adding the column manually to the DB before upgrading:
You could try out adding the column manually to the DB before upgrading:
alter table Files add column ocID int unsigned not null default 0;
My solution ... it must have been a bad database export or import. I redid the process, and all works great. So, I'd say my issue was just a corrupt database.
How did you resolve this?