Bug FlashGameDistribution import database error

Status
Not open for further replies.

joshtrav

Customer
Code:
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.
 
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"
 
Last edited:
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.
 
Status
Not open for further replies.

Legacy vBArcade

vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
899
Customer rating
0.00 star(s) 0 ratings
Top