Just found my site has gone and showing this error can anyone help!
Permalink
I cannot login to update
An unexpected error occurred.
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")
An unexpected error occurred.
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")
That type of error is typical of a situation where the version of c5 the database is configured for is different to the version of c5 code that is running.
Ways this could happen (not exclusive, there are no doubt many others)
- An incomplete core update
- Editing config/sys and making a mistake
- Restoring a database backup made with a previous core version
Ways this could happen (not exclusive, there are no doubt many others)
- An incomplete core update
- Editing config/sys and making a mistake
- Restoring a database backup made with a previous core version
Hi thanks for coming back to me.
Can I see in the database which version it is configured for?
Can I see in the database which version it is configured for?
Look in the Config table using phpMyAdmin.
Also look in config/site.php
Also check the dashboard Environment page.
The versions should all match.
Also look in config/site.php
Also check the dashboard Environment page.
The versions should all match.
Just what i says "cPendingAction" column is missing, or the query is invalid.
You can test SQL queries with PhpMyAdmin!
..