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")
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")
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
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
Having the same issue - were you able to get this resolved? I'm using a fresh install 5.6.1.2.
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")
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?
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?
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.
So how did you fix it?
this was the issue in my case too....total facepalm ;)
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