Database Restore Error -

Permalink 1 user found helpful March 01, 2012 at 8:15 AM

I attempted to restore a database to an older version and subsequently got an error on my site, and now I am unable to access the site itself.

The error I see on the screen is:

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

Can anyone urgently help?
Many thanks

ceanndesign replied on Mar 1, 2012 at 10:35 am Permalink Best Answer Reply

UPDATE:
After more searching I came across this posting which helped resolve the issue.

http://www.concrete5.org/community/forums/installation/restoring-a-...