Forums

Error on upgrade from 5.4.2.2 to 5.5.1

Permalink
My host is doing an auto script install of C5.5 now and all my sites are in 5.4.2.2 - I have yet to have a seamless upgrade. I did a test (luckily) of the install and sure enough its come up with an error.

mysql error: [1054: Unknown column 'ctIsInternal' in 'field list'] in EXECUTE("SELECT ctID, ctHandle, ctIsInternal, ctName, ctIcon, pkgID from PageTypes where ctHandle = 'right_sidebar'")

Any idea anyone? What is the best way to upgrade to 5.5.1 getting really frustrated with it as it refuses to work. Every other auto install I did to 5.5 I had to roll the concrete folder back to 5.4.2.2 (taking about an hour on my bandwidth) before the site would work. There must be a better way!!
chassa2556
 
TorstenKelsch replied on at Permalink Reply
TorstenKelsch
I had the same problems when upgrading from 5.4.2.2 to 5.5.1.1 The only chance to fix these errors was to manually change the database.

You can try the following (no guarantee!), and please do a backup before! Of course, you have to change the usr_xxxxxx_1 to the name of your database.

CREATE TABLE `usr_xxxxxx_1`.`btCoreScrapbookDisplay` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
CREATE TABLE `usr_xxxxxx_1`.`CollectionVersionRelatedEdits` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
) DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
CREATE TABLE `usr_xxxxxx_1`.`ComposerTypes` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (Id)
) DEFAULT CHARSET=utf8;
CREATE TABLE `usr_xxxxxx_1`.`Stacks` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`Id`)
) DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;
Viewing 15 lines of 57 lines. View entire code block.
chassa2556 replied on at Permalink Reply
chassa2556
Hi - thanks for the tip - I can't risk this as the install is going on a live site. I have now manually installed 5.4.2.2 and all is fine.