Error upgrading from 26 to 27

[kingcruisers]

I am getting the following error when attempting to upgrade from 26 to 27. This error happens after entering customer number at upgrade.php.

Upgrade Progress

• Upgrading to 5.0.0 Beta 27
• Step 1 - Mapping customized stylevars to new stylevars
• Step 2 - Altering video Table (1 of 3)
• Altering video Table (2 of 3)
• Altering video Table (3 of 3)
• Step 3 - Altering permission Table (1 of 1)
• Altering messagefolder Table (1 of 1)
• An error has occurred with your database. Please contact vBulletin Support for assistance.
  Module: 500b27, Step 4 Database Error:-1
  Specified key was too long; max key length is 767 bytes
  Query:
  
  ### vBulletin Database Alter ### ALTER TABLE messagefolder ADD UNIQUE INDEX userid_title_titlephrase (userid,title,titlephrase)

[DivisionByZero]

same here... it's an innodb thing, nothing to do really but reduce the size of the column.

[kingcruisers]

So at first I thought it could be the user titles being too long. I went through and shortened them all but that didn't work. Any suggestions?

[DivisionByZero]

im looking through the install files now, i'll post or PM you a fix

[kingcruisers]

Is reducing the column size the solution that worked for you? If so, how is that done?

[DivisionByZero]

the code is fine, its the size of the columns, which are WAY too big. in the table messagefolder, change title and titlephrase to varchar(60) and rerun the installer. that should do it. There's no WAY those columns need to be that big!

do you have PHPmyADMIN access? that's the best way? if not, i can walk you through doing it on the shell if you have SSH access. you COULD have done it in your admnicp, but i'm guessing your install is still broken

[kingcruisers]

Fixed that...thanks for the instructions, however I got this error:

Action Required

Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>Specified key was too long; max key length is 767 bytes

[DivisionByZero]

how did you upload the files to the server? did you unzip it on the server, or upload them individually?

[kingcruisers]

unzipped locally and uploaded per instructions

[DivisionByZero]

hmmmmmm

[kingcruisers]

I am having no luck with this upgrade to 27. I have tried many of the suggestions found on various threads with similar issues and still no luck.

[kleinergeist191]

same at me:

• Upgrading to 5.0.0 Beta 27
• Step 4 - Altering messagefolder Table (1 of 1)
• An error has occurred with your database. Please contact vBulletin Support for assistance.
  Module: 500b27, Step 4 Database Error:-1
  Specified key was too long; max key length is 767 bytes
  Query:
  
  ### vBulletin Database Alter ### ALTER TABLE messagefolder ADD UNIQUE INDEX userid_title_titlephrase (userid,title,titlephrase)

[BulliM]

I have the same error! Difference is 1000 instead of 767 bytes.

An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: 500b27, Step 4 Database Error:-1
Specified key was too long; max key length is 1000 bytes
Query:

### vBulletin Database Alter ### ALTER TABLE messagefolder ADD UNIQUE INDEX userid_title_titlephrase (userid,title,titlephrase)

[beishe8]

Action Required
An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: 500b27, Step 4 Database Error:-1
Specified key was too long; max key length is 1000 bytes

[Trevor Hannant]

I've confirmed the Bug report here:

http://tracker.vbulletin.com/browse/VBV-7530