[robster1225]

Originally Posted by theorigin

This is the error I've been getting since I tried to install it:

Database error in vBulletin 3.7.2:

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

I posted in the Programming Discussion section and was told that there were too many Primary Keys in it and I should take out all except the 'locale' one. I tried that and it went through, but now every time I try and update the profile ID field, it reverts back to the "0" that it started with. I'm guessing this is because I updated the xml file itself? Help would be greatly appreciated.

I'm having this same problem, is there any fix?