MySQL Error Help

Permalink
Can anyone please advise why i'm getting the following error, I uploaded some changes to the site and the database. In the past this hasn't been a problem, but I'm not getting this:

Thanks

mysql error: [1054: Unknown column 'cPendingAction' 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")

BHWW
 
Brainakazariua replied on at Permalink Reply
Brainakazariua
The 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.

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 database user, and make sure it has all the database privileges ticked (update, insert, index, etc, etc).

Then you'd try the updates again.

Another possible option is that you have a newer concrete core running but haven't upgraded your site yet, run a /tools/upgrade?force=1 on your site to make sure it's up to date
BHWW replied on at Permalink Reply
BHWW
Hi, Thanks but thats not resolved the issue...?

I have ensured that all privileges are set/given to the user for that database, and i have also run the force upgrade which seems to work, but when i click back to home i see the same error message?

Any other ideas?

Thanks
hursey013 replied on at Permalink Reply
hursey013
Having the same issue - were you able to get this resolved? I'm using a fresh install 5.6.1.2.
clocktower replied on at Permalink Reply
clocktower
We just ran into that issue with an installation. I will try to have an update or check back for one should we not able to figure one.

mysql error: [1054: Unknown column 'cPendingAction' 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 = NULL")
JohntheFish replied on at Permalink Reply
JohntheFish
The updater code that is run with each update to the core often adds columns to database tables. Maybe one step of an update sequence (some updates assume other updates have already been made - see the notes 1/3 of the way down the downloads page) has been missed, or the update was not run for that step, or did not complete for that step.
http://www.concrete5.org/developers/downloads/...

I suspect (but am not sure) that the column you are missing was part of the 5.6.0 update from 5.5.2.1 because 5.6 introduced workflows. Maybe someone who knows about workflows and approval can confirm/correct my suspicions above?
hursey013 replied on at Permalink Reply
hursey013
FYI - I discovered this error was from my own mistake. Basically what had happened was I accidentally pointed my new 5.6.1.2 install at an old 5.4.2.2 database in my config.php - obviously in that old database the column cPendingAction didn't exist, just as the error message indicated...whoops.
gailsedotes replied on at Permalink Reply
So how did you fix it?
nerdess replied on at Permalink Reply
nerdess
this was the issue in my case too....total facepalm ;)