Can't access site after 5.5.1 upgrade

Permalink February 21, 2012 at 12:37 PM

I just upgraded to 5.5.1 on my main domain, but when I upgraded my sub-domain, I get this error when trying to access my site:

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

I'm pretty new to concrete5 so please excuse me if this is something simple. Thanks!

slaminteractive replied on Feb 22, 2012 at 4:33 pm Permalink Reply

Hi, I just had the same problem. I checked community threads and this helped me out.

http://www.concrete5.org/community/forums/installation/upgraded-to-...

If you read the first reply, it will show you how to revert your site back to the previous Concrete5 version you had installed. I know this isn't a solution to fix the upgrade but it'll get your site back up and running while you figure out how to upgrade successfully.

Maybe the error occurs because you are running the install on a subdomain - my site had exactly the same problem after upgrading and I'm serving it on a subdomain too. If anyone can shed any light on this then I would appreciate some help as well. Many thanks.