[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 gusfune

I got this error:

Database error in vBulletin 3.7.2:

Invalid SQL:

    CREATE TABLE IF NOT EXISTS vb_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, October 6th 2008 @ 02:14:18 PM
Error Date    : Monday, October 6th 2008 @ 02:14:18 PM
Script        : http://x.com/admincp/plugin.php?do=productimport
Referrer      : http://x.com/admincp/plugin.php?do=productadd
IP Address    : x9.x6.x4.x0
Username      : admin
Classname     : vB_Database
MySQL Version : 5.0.67-log

Can't add product