problem with upgrade
Permalink
hello,
i'm looking for anyone who may be able to help.
i just attempted to upgrade my site from 5.4.4.2 to 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")
_________________
when i try to go to any page on the site - i get the same error.
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:
_______________________
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")
________________________
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.
thanks in advance.
i'm looking for anyone who may be able to help.
i just attempted to upgrade my site from 5.4.4.2 to 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")
_________________
when i try to go to any page on the site - i get the same error.
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:
_______________________
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")
________________________
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.
thanks in advance.
Hi Ryan,
omg. thank you so much.
i figured it might be something to do with the database, but didn't know where to begin.
but yes - you're right - looks like that fixed it.
i thought i'd set up the database with all privileges checked... but not.
thank you.
i really appreciate your help!!
omg. thank you so much.
i figured it might be something to do with the database, but didn't know where to begin.
but yes - you're right - looks like that fixed it.
i thought i'd set up the database with all privileges checked... but not.
thank you.
i really appreciate your help!!
You're very welcome.
Great to see another Aussie on the forums here too!
Great to see another Aussie on the forums here too!
the second error message you posted seems to indicate that the database user set up for your database doesn't have enough permissions to update the database as part of the upgrade. That might be why the upgrade failed in your first attempt.
It depends a bit on your hosting, but if you have something like cPanel, you would need to log into that, find in your MySQL section the part that allows you edit/update database users. Then you'd edit the inter130_c5admin user, and make sure it has all the database privileges ticked (update, insert, index, etc, etc).
Then you'd try the manual update again.
Great to hear though that you backed up your database. If you can't get this to work, you'll need to restore that database dump and the concrete folder from 5.4.4.2.
Cheers
-Ryan