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.
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.
thanks again!