[DataHero]

Hey there Dragonsys,

Thanks for the quick response. Much appreciated.

I've also, however, encountered another issue. Apparently, when I try to re-install this modification, it gives me the following error:

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 : Tuesday, January 11th 2011 @ 04:38:39 AM
Error Date : Tuesday, January 11th 2011 @ 04:38:40 AM
Script : http://mydomain.com/forum/acp/plugin...=productimport
Referrer : http://mydomain.com/forum/acp/plugin.php?do=productadd
IP Address : **.***.***.***
Username : ****
Classname : vB_Database
MySQL Version : 5.1.51-log

The reason I reinstalled this is because I changed the character set from utf8 to latin1. It installed fine then, but then character names - such as K?ri? - appeared oddly with copyright symbols and whatnot, as latin1 isn't multi-byte supportive.

From my understanding, the reason this occurs is because these values are occurring:

(2 + 100 + 100 + 100 + 100 + 100) * 3 = 1506 bytes

Any way to have a workaround to either the 1000bytes error, or the characters whilst using another character set than utf8 (should the former not be fixable ATM)?


Cheers,
DataHero