i upgraded my site and now i get an error msg

Permalink 1 user found helpful
hi please help me.... i recently upgraded my site and now it is broken... i now get this error message

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")

if anyone knows how to fix this please please help me :(

poshpiglet
 
JohntheFish replied on at Permalink Reply
JohntheFish
There is a possibility that the upload of the database did not complete. If that is the case, a simple solution to try is to manually re-run the upgrade by entering the url:
yoursite.com/index.php/tools/upgrade?force=1
poshpiglet replied on at Permalink Reply
poshpiglet
hi thanks for the reply, i have tried that and still get the same problem, the website is called 47vids.com, any other suggestions?

thank you for replying me


error msg
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")
JohntheFish replied on at Permalink Reply
JohntheFish
You should check manually by FTP that the update folder contains the update and that it has been unzipped (you don't need to check every file).

siteroot/updates/concrete5.6.2.1/concrete/

etc.

Then check the last line in:

siteroot/config/site.php

Has a definition that specifies the same version
define('DIRNAME_APP_UPDATED', 'concrete5.6.2.1')

What version was your customer on before updating? If it was many versions ago another possibility is that they missed out on key steps of the upgrade process.
poshpiglet replied on at Permalink Reply
poshpiglet
it was updated to from 5.2, how do i check via ftp? i know i sound so dumb right now, sorry ....
JohntheFish replied on at Permalink Reply
JohntheFish
Or use the file manager or filespace explorer or whatever it is called in your host's cPanel.