Upgrade disaster
Permalink 1 user found helpful
Hello,
I have really messed up my site. I tried to upgrade a few times automatically and each time it would tell me it succeeded in updating to 5.4.0.3 instead to 5.4.1 as I had chosen to do.
I searched the forums and found this thread;
http://www.concrete5.org/community/forums/installation/update-issue... and then proceeded to follow its instructions leaving this as the last line in my site.php file.
When I tried the last time to update it broke my site and I am now left with the following being returned when I try to enter my site;
"
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/burtsgh8/public_html/updates/concrete5.4.1/concrete/libraries/ in /home/burtsgh8/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78"
I have been a moron and done this without a current back-up although I like all morons really do normally back up!
Any ideas on what I might do to A/ recover my site and B/ properly undate to latest version.
I have really messed up my site. I tried to upgrade a few times automatically and each time it would tell me it succeeded in updating to 5.4.0.3 instead to 5.4.1 as I had chosen to do.
I searched the forums and found this thread;
http://www.concrete5.org/community/forums/installation/update-issue... and then proceeded to follow its instructions leaving this as the last line in my site.php file.
When I tried the last time to update it broke my site and I am now left with the following being returned when I try to enter my site;
"
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/burtsgh8/public_html/updates/concrete5.4.1/concrete/libraries/ in /home/burtsgh8/public_html/updates/concrete5.4.1/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78"
I have been a moron and done this without a current back-up although I like all morons really do normally back up!
Any ideas on what I might do to A/ recover my site and B/ properly undate to latest version.
I did the "push here to upgrade" and was once again struck by the wonderful simplicity of concrete5. Upgrade was flawless although I did indeed back up the database beforehand. Just in case...
didn't work for me either though
I was hit with the same problem. I hit back in the browser after getting the same errors... went to the DB and enabled all permissions; hit the update button again and it worked. (I'm not sure what permission that I enabled to make the changes.. but heck, it worked.
Is it safe to say that the auto-upgrade is not quite ready for prime time?