upgrade to 5.4.1 error
Permalink 1 user found helpful
Uploaded the new concrete folder and clicked the upgrade button. Checked and doublechecked that all the files transferred but I still get this error. Any ideas on what's missing here?
An Unexpected Error occurred while upgrading: 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 = 0")
An Unexpected Error occurred while upgrading: 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 = 0")
Got it. I just had to install the previous upgrades.
Which upgrades, out of interest? I'm coming from 5.3.3.1 and seeing the same thing. I'll go hunt a bit and add something to this when I find out what upgrades work - thanks for the tip.
I was upgrading from 5.3.3.1.
I downloaded 5.4.0.5 - and installed that first. This worked fine. The upgrade to 5.4.1 then worked fine as well.
Had one other issue with an incorrectly named custom block controller (not using proper camel case). This resulting in the page failing to load if caching was enabled. Once resolved the site was working fine.
Pretty good if you ask me (er, actually, darm good!). Took about 10m end to end, including backups (you are doing backups, right?)
I downloaded 5.4.0.5 - and installed that first. This worked fine. The upgrade to 5.4.1 then worked fine as well.
Had one other issue with an incorrectly named custom block controller (not using proper camel case). This resulting in the page failing to load if caching was enabled. Once resolved the site was working fine.
Pretty good if you ask me (er, actually, darm good!). Took about 10m end to end, including backups (you are doing backups, right?)
