Scary error message after updating

Permalink 1 user found helpful
Hi,

I receive the following error after trying to upgrade. I was upgrading from 5.4.1 to the latest 5.5.1 and this is the error message I get:

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

Please help!

kevinschueller
 
kevinschueller replied on at Permalink Reply
kevinschueller
Just to be more specific...I get this error message when trying to view the homepage or login on the site. When I go to index.php/tools/upgrade I get the message. You must first upgrade your site to version 5.4.2.2.
rfairbairn replied on at Permalink Reply
rfairbairn
Did you do a straight upgrade from 5.4.1 to 5.5.1?

If you did thats your issue, as it says you must first upgrade to 5.4.2.2
s2d replied on at Permalink Reply
s2d
According to the current upgrade docs (found athttp://www.concrete5.org/documentation/installation/upgrading_concr... you should be able to do a straight upgrade from v5.3.3. If that is no longer the case with v5.5, I hope someone gets around to updating the instructions soon. It would be nice to know that before attempting an upgrade.
Mnkras replied on at Permalink Reply
Mnkras
You CANNOT have a version that is LESS than 5.4.2.2 in order to upgrade to 5.5+. You can try, but its not going to work.

Mike
s2d replied on at Permalink Reply
s2d
How would Mr. Schueller have known that before attempting the upgrade? As I said, I hope someone updates the instructions soon.
Mnkras replied on at Permalink Reply
Mnkras
There should be a note on that page tomorrow, but it was already on the download page:http://www.concrete5.org/developers/downloads/...
s2d replied on at Permalink Reply
s2d
And what about the upgrade link from the Dashboard? Does that prompt you to upgrade to the next available version from the currently installed one?
kevinschueller replied on at Permalink Reply
kevinschueller
Yes, I did use the update button in the Dashboard. No warning, just this error message throughout my site. Does anyone know how to fix this? Any help would be greatly appreciated.
sesscouts replied on at Permalink Reply
The obvious answer is to revert to your backup of your files and database before you did the upgrade?

You did backup?
kevinschueller replied on at Permalink Reply
kevinschueller
Unfortunately, one of my clients applied the update from the dashboard and didn't back-up. Thanks for the obvious answer, but that won't work in this situation. It's clearly a database issue, but I'm wondering if anyone has the knowledge here to help repair it. I tried upgrading manually to no avail. I also tried reverting to the old version, no such luck.
coptrs replied on at Permalink Reply
coptrs
I have the same issue, but gladly I DID backup :)
However, i replaced the Concrete folder on the server with my backup folder, and I erased the SQL database with my backup file, but when I go to my site, nothing works.. I just get a blank page... Maybe I'm missing a step in restoring the site, but I can't find out what's going wrong...
s2d replied on at Permalink Reply
s2d
I agree with sesscouts, the best course is to restore your backups to revert to the version you had prior to attempting to upgrade, then running incremental upgrades to get it to the latest version.

If that is not an option, the error message refers to a missing field in one of the tables. If that is the only field missing, perhaps manually adding the referred-to field (column) may clear up that issue, but then that may give rise to other issues.
s2d replied on at Permalink Reply
s2d
Well, reading my last response, I decided that was a little lame. What can I say, the caffeine hadn't quite kicked in by then.

I checked the release notes on 5.4.1 and later, and there is no information about any changes made to the data structure. However, you could find out anything you need to know by comparing the ../concrete/config/install/schema.sql files of each version. This would probably give you all the information you need to repair the database, if you know what you're doing.

Without the right tools, it would be a pretty tedious process, full of potholes. If you're not familiar with what would be involved in doing this, I would definitely recommend hiring someone who is.
jedininja replied on at Permalink Reply
jedininja
I had 5.4.2.2 and just upgraded to 5.5.2 and get the same message. But I wasn't able to upgrade from the dashboard area (I had no access to the site because c5 crashed my server and they suspended my account); had to upload it to the updates folder and edit the config file.
JanJ replied on at Permalink Reply
Hello,
I have a new C5 5.5 installation and I get the same message as above when trying to use the database I used in 5.4.2. What's the right procedure to follow to be able to use content from an earlier installation (5.4.2.2) in a new C5 5.5.1 installation?
Thanks!
TorstenKelsch replied on at Permalink Reply
TorstenKelsch
The upgrade works on some hosts, on others it fails. It seems to depend on your web hoster’s configuration. In my case, the following SQL code helped a bit, but after all I found it easier to do a fresh install. Of course, you must have a backup of your texts to fill your pages with after the installation.

And in the code below, you have to replace usr_web656_1 with your database’s name!

CREATE TABLE `usr_web656_1`.`btCoreScrapbookDisplay` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
CREATE TABLE `usr_web656_1`.`CollectionVersionRelatedEdits` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
) DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
CREATE TABLE `usr_web656_1`.`ComposerTypes` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (Id)
) DEFAULT CHARSET=utf8;
CREATE TABLE `usr_web656_1`.`Stacks` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
) DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
ConcreteOwl replied on at Permalink Reply
ConcreteOwl
Very long shot I know but how about putting concrete5.4.2.2 in the updates folder and then running index.php/tools/upgrade?

concrete5.4.2.2 can be downloaded fromhttp://www.concrete5.org/developers/downloads/...

If that succeeds then do the same with concrete5.5.1