Bug FlashGameDistribution import database error

[joshtrav]

Database error in vBulletin 4.2.1:

Invalid SQL:
SELECT gameid FROM vb_dbtech_vbarcade_game WHERE gameid = 'JuliaâsadventurePirates';

MySQL Error   : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Error Number  : 1267
Request Date  : Thursday, January 2nd 2014 @ 02:55:31 PM
Error Date    : Thursday, January 2nd 2014 @ 02:55:32 PM
Script        : http://cegamer.com/admincp/arcade_admin.php?do=review
Referrer      : http://cegamer.com/admincp/arcade_admin.php?do=review
IP Address    : 0.0.0.0
Username      : joshtrav
Classname     : vB_Database
MySQL Version : 5.5.34

Above error occurs when we attempt to import - 100 per page, at page 3.

 

[Fillip H.]

What is the default charset for your database?

 

[joshtrav]

Variable_name Value
character_set_database latin1

That was what I did for show variables like "character" in the database.

When I do an info on all the dbtech tables they all show a collation of "latin1_swedish_ci", however, most of my other vB tables show "utf8_general_ci"

 

[Fillip H.]

In that case, please also convert all vBArcade tables & columns to the same character set.

For the future, I would suggest changing the default character set on your database to match that of your vB tables, to avoid this issue in the future with another mod.