Upgrade to 5.5.1 problem
Permalink
I had a perfectly functioning 5.4.2.2 website. In the Dashboard, after backing up the files, I pressed the Update button. I left the website and came back, and instead of my home page, I got this error message:
An unexpected error occurred. mysql error: [1054: Unknown olumn '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 = '49'")
So I then went to the godaddy.com hosting, ftp area and deleted the latest 5.5 update file. When I tried to open the website again, instead of the home page, I get this warning message:
require(updates/concrete5.5.1/concrete/dispatcher.php) [function.require]: failed to open stream: No such file or directory in /home/content/j/g/r/jgraves001/html/concrete/startup/updated_core_check.php on line 8 Fatal error: require() [function.require]: Failed opening required 'updates/concrete5.5.1/concrete/dispatcher.php' (include_path='.:/usr/local/php5/lib/php') in /home/content/j/g/r/jgraves001/html/concrete/startup/updated_core_check.php on line 8
So now what do I do? The website can't be seen at all (joelcgraves.com).
An unexpected error occurred. mysql error: [1054: Unknown olumn '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 = '49'")
So I then went to the godaddy.com hosting, ftp area and deleted the latest 5.5 update file. When I tried to open the website again, instead of the home page, I get this warning message:
require(updates/concrete5.5.1/concrete/dispatcher.php) [function.require]: failed to open stream: No such file or directory in /home/content/j/g/r/jgraves001/html/concrete/startup/updated_core_check.php on line 8 Fatal error: require() [function.require]: Failed opening required 'updates/concrete5.5.1/concrete/dispatcher.php' (include_path='.:/usr/local/php5/lib/php') in /home/content/j/g/r/jgraves001/html/concrete/startup/updated_core_check.php on line 8
So now what do I do? The website can't be seen at all (joelcgraves.com).
Thanks for the quick reply. I cannot get into the website or dashboard, and I don't see anything like template default.php in the FTP File Manager on Godaddy. Is there a way to get to the dashboard when I can't get into the website? Thanks
Well, I got one reply and it didn't work.
Deleted 5.5 and 5.4.2.2 from Godaddy Hosting Control FTP.
Reinstalled 5.5.
Was able to get the opening page.
Typed in all nec info, but it said 119 files in database, so wouldn't complete.
Went to Godaddy Hosting Control, MySQL and exported copy of database to Desktop.
Deleted all 119 files in database.
Then start up page completed actions and everything worked.
Imported database from Desktop back to MySQL.
BUT the new dashboard will not allow me to Restore the old database.
ANY ideas on how to force it to do that? Will it work out okay?
OR am I going to have to recreate everything - again? Thanks
Deleted 5.5 and 5.4.2.2 from Godaddy Hosting Control FTP.
Reinstalled 5.5.
Was able to get the opening page.
Typed in all nec info, but it said 119 files in database, so wouldn't complete.
Went to Godaddy Hosting Control, MySQL and exported copy of database to Desktop.
Deleted all 119 files in database.
Then start up page completed actions and everything worked.
Imported database from Desktop back to MySQL.
BUT the new dashboard will not allow me to Restore the old database.
ANY ideas on how to force it to do that? Will it work out okay?
OR am I going to have to recreate everything - again? Thanks
I had similar challenges and solved it very easily as I figured out I was missing this line of code in my template default.php:
It has to be right before your </body> tag
see if that solves the problem...