I tried installing this mod on my site and received the following database error:
Code:
Database error in vBulletin 3.7.3:
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
Classname : vB_Database_MySQLi
MySQL Version : 5.0.51a-community
I have tried installing this on my live site and a test site that has no other plug-ins installed. I have successfully installed the other gWoW add-ons and have experienced no problems.
I would like to find a way to resolve this problem since this add-on is something I really want to have for my guild's site. Any help would be appreciated!