[burn420]

Originally Posted by neo88

I am also having the same error as Burn.. Any suggestions?

I have solved the problem on my end.

The problem for me was MySQL server default character set is UTF-8.
You can change the tables character set by adding the following line.

ENGINE=MyISAM DEFAULT CHARSET=latin1;

To do this open the product-gWoWRoster.xml find the CREATE TABLE statements, add ENGINE=MyISAM DEFAULT CHARSET=latin1; to the end of the statement or you can just copy and paste what i have.

Example:

$vbulletin->db->query("
	CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "gwowroster_charinfo (
		`locale` VARCHAR( 2 ) NOT NULL ,
		`realm` VARCHAR( 100 ) NOT NULL ,
		`name` VARCHAR( 100 ) NOT NULL ,
		`updated` INT( 255 ) NOT NULL ,
		`charname` VARCHAR( 100 ) NOT NULL ,
		`talentspec` VARCHAR( 10 ) NOT NULL ,
		`talenttree` VARCHAR( 255 ) NOT NULL ,
		PRIMARY KEY ( `locale`, `realm`, `name`, `charname` )
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
");

// Character Professions
$vbulletin->db->query("
	CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "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` )
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
");

Save the xml file and try again should fix the problem.