PDA

View Full Version : Language issue when arcade is active


PNEInvincibles
11-21-2008, 10:35 AM
I have installed the arcade and everything is working fine.

However if I have the plugin active then every time a user tries to navigate the rest of the forum they get an error and I get the database error:

Database error in vBulletin 3.7.4:

Invalid SQL:

SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Illegal mix of collations (latin1_german2_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, November 21st 2008 @ 12:26:27 AM
Error Date : Friday, November 21st 2008 @ 12:26:28 AM
Script : http://www.pne-invincibles.co.uk/forum/showthread.php?t=6995
Referrer : http://www.pne-invincibles.co.uk/forum/forumdisplay.php?f=43
IP Address : 83.231.209.130
Username : STRPNE
Classname : vb_database
MySQL Version : 5.0.67-log


I have seen it written on the add on thread that it requires a simple change in the tournaments table, but I can not find such a table :confused:

Any support would be greatfully recieved so I can turn the arcade back on :)