Disaster with new install!
Permalink
Website has completely gone and can't navigate anywhere as 'return home' button does not work. Only showing this error message
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 = '47'")
Help, please!
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 = '47'")
Help, please!
I instaled the new update but didn't like it so clicked the restore button from my recent backup and this is what happened.
I can't get access to any part of Concrete, and I wouldn't know how to find the file you mentioned. I am a complete novice so you can imagine my panic!
Could you please give me detailed step by step instructions for a complete dummy :)
I'm with Just Host if that makes any difference.
I can't get access to any part of Concrete, and I wouldn't know how to find the file you mentioned. I am a complete novice so you can imagine my panic!
Could you please give me detailed step by step instructions for a complete dummy :)
I'm with Just Host if that makes any difference.
I have found the Concrete file folder on my hosting site and have searched the file you mentioned but there is no record of it.
It's not a file that is missing, it is a field in your database.
Something has gone wrong with the restore it seems. I get the impression that it restored the database to the previous version, but the site itself thinks it is the newer version.
I think you best bet is to apply the upgrade again. The newer version of concrete5 is pretty good in my opinion, worth it for the speed improvements.
I'd try going to yoursite.com/index.php/tools/upgrade/
and see if you can trigger off the upgrade again (if it is available).
Something has gone wrong with the restore it seems. I get the impression that it restored the database to the previous version, but the site itself thinks it is the newer version.
I think you best bet is to apply the upgrade again. The newer version of concrete5 is pretty good in my opinion, worth it for the speed improvements.
I'd try going to yoursite.com/index.php/tools/upgrade/
and see if you can trigger off the upgrade again (if it is available).
Hi Ryan, thank you so much all is working again!
The only thing I didn't like was the new dashboard; the statistics don't show exactly how many people have visited that day anymore and the Concrete Hit Count app doesn't support the new version.
Many, many thanks again :)
The only thing I didn't like was the new dashboard; the statistics don't show exactly how many people have visited that day anymore and the Concrete Hit Count app doesn't support the new version.
Many, many thanks again :)
Excellent, glad I was able to help!
Oh, just a note about the statistics - if you are really interested in them, you're probably better setting up something like Google Analytics, or Clicky. The built in statistics are pretty simplistic.
Have you done any updates to concrete5 or any restores of your database?
Did this happen after anything in particular? Can you log into your database and check to see if this field exists?