site not working at all after upgrade

Permalink
hi,

i just attempted to upgrade my site from 5.4.4.2 to the latest version 5.5.2.1.

i backed up my database and clicked upgrade in the dashboard...

i got the following error message:

An unexpected error occurred.
mysql error: [1054: Unknown column 'Pages.cIsActive' in 'field list'] in EXECUTE("select Pages.cID, Pages.pkgID, Pages.cPointerID, Pages.cPointerExternalLink, Pages.cIsActive, Pages.cIsSystemPage, 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")

< Back to Home


when i click "Back to Home" or just click back using the browser's back button or in fact when i just try to go to the homepage or any page on the site - i get the same error.

yikes!!!

i have been to the "Troubleshooting concrete5 updates: database and core versions" page in the how-to's on the c5 site - i checked my database and has the SITE_APP_VERSION as 5.4.4.2 and also when i check the version.php file it says it's running 5.4.4.2 ...
i have also checked the "Manually upgrade concrete5" how-to page and have tried to do the upgrade manually according to instructions there -
but when i go to thehttp://www.your-concrete5-site.com/index.php/tools/required/upgrade... page and try to run the upgrade from there i get the following error:


Upgrade concrete5

An Unexpected Error occurred while upgrading: mysql error: [1142: INDEX command denied to user 'integ130_c5admin'@'localhost' for table 'Areas'] in EXECUTE("DROP INDEX arIsGlobal ON Areas")

Back to Home

the error that i got originally still occupies all pages of the site.

if anyone has any ideas as to what might have happened or what i can do - i'd really appreciate your help.

i did back up my database prior to attempting to upgrade, but am a little nervous, perhaps mildly panicked about having the site "disappear" like this.

thanks in advance.

dolorescupcake
 
dolorescupcake replied on at Permalink Reply
dolorescupcake
i have had this issue resolved - with thanks to mesuva - see answer here -http://www.concrete5.org/community/forums/jobs1/problem-with-upgrad...

thanks again!