[CFodder]

Trying to install v1.0.14 on VB 3.8.1 PL1, getting the following error:

Database error in vBulletin 3.8.1:

Invalid SQL:

CREATE TABLE IF NOT EXISTS gwowroster_charinfo_prof (
`locale` VARCHAR( 2 ) NOT NULL ,
`realm` VARCHAR( 100 ) NOT NULL ,
`name` VARCHAR( 100 ) NOT NULL ,
`charname` VARCHAR( 100 ) NOT NULL ,
`key` VARCHAR( 100 ) NOT NULL ,
`updated` INT( 255 ) NOT NULL ,
`primary` INT( 1 ) NOT NULL ,
`profname` VARCHAR( 100 ) NOT NULL ,
`max` INT( 10 ) NOT NULL ,
`value` INT( 10 ) NOT NULL ,
PRIMARY KEY ( `locale`, `realm`, `name`, `charname`, `key` )
);

MySQL Error : Specified key was too long; max key length is 1000 bytes
Error Number : 1071
Request Date : Monday, June 1st 2009 @ 04:16:39 AM
Error Date : Monday, June 1st 2009 @ 04:16:39 AM
Classname : vB_Database
MySQL Version : 5.1.30

Have tried the fix suggested but am now getting this error:

Database error in vBulletin 3.8.1:

Invalid SQL:

CREATE TABLE IF NOT EXISTS gwowroster_charinfo (
`locale` VARCHAR( 2 ) NOT NULL ,
`realm` VARCHAR( 100 ) NOT NULL ,
`name` VARCHAR( 100 ) NOT NULL ,
`updated` INT( 255 ) NOT NULL ,
`charname` VARCHAR( 100 ) NOT NULL ,
`talentspec` VARCHAR( 10 ) NOT NULL ,
`talenttree` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `realm`, `charname`, `key` )
);

MySQL Error : Key column 'key' doesn't exist in table
Error Number : 1072
Classname : vB_Database
MySQL Version : 5.1.30

Is there any fix for the first error?