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.

 
Brian replied on at Permalink Reply
Ok so I had my ISP restore a prior back-up of the home folder and database and the site appears to work fine now.

Is it safe to say that the auto-upgrade is not quite ready for prime time?
tallacman replied on at Permalink Reply
tallacman
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...
12345j replied on at Permalink Reply
12345j
didn't work for me either though
Jay3402 replied on at Permalink Reply
Jay3402
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.
jordanlev replied on at Permalink Reply
jordanlev