[slick368]

I had the same problem with when I tried to install. Go to your forum's database in phpMyAdmin or whatever you use to manage your database and make sure the database collation is set to latin1_generalci. All of my databases default to utf8_unicode_ci and that is what caused the problem.

If you are using phpMyAdmin, you can find the setting by selecting your forum's database, then clicking the Operations tabe. The collation setting is near the bottom.

Once the change was made, the add-on installed for me without a hitch. Hope this helps!

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.