[slabuda]

Resolved from previous post in these forums ...



I recieved the following error, when trying to install today --

Database error in vBulletin 3.7.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 : Wednesday, June 4th 2008 @ 12:36:41 PM
Error Date : Wednesday, June 4th 2008 @ 12:36:41 PM
Script : http://www.consilioetarmis.net/home/...=productimport
Referrer : http://www.consilioetarmis.net/home/...?do=productadd
IP Address : 65.240.129.62
Username : Kiko
Classname : vB_Database
MySQL Version : 5.0.45-community