MySQL-Error after upgrade

Permalink December 27, 2013 at 10:24 AM

Hi all

After upgrading his site, my dad now gets the following error message on his C5-site (www.konsultation-gg.de):

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

Now, I've found this problem already mentioned in here, but the supposed solution (adding missing privileges to the db user) did not do me any good. There apparently is no DB or data backup of the site from before the upgrade...

Any suggestions?
Thanks!

RizzzO replied on Dec 27, 2013 at 10:49 am Permalink Reply

I temporarily fixed it be manually changing the version in the site.php file... site works for now, though I'm not sure it that's a stable solution.

mhawke replied on Dec 27, 2013 at 1:56 pm Permalink Reply

It's possible the server 'timed-out' before actually completing the changes to the database structure, hence your missing a column. You can try putting this in the browser to ask concrete5 to try to upgrade again:

www.www.yourdomain.de/index.php/tools/required/upgrade...