Illegal Mix Of Collations

[idoL1]

whenever i enable the xml file in the plugins n products i get this error

Invalid SQL:

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

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267


when i disable it it goes away...any help? website is www.360icons.com if that helps?

--------------- Added 1263569703 at 1263569703 ---------------

ive tried making tournaments general instead of swedish
and ive tried making users swedish instead of general
its somethinggg to do witht he t.champion i believe wtf does that mean.....the = operation aka t.champion = u.username cannot run so how can i get rid of that operation i dont care if the tournament champion doesnt run because im sure that can be fixed alot easier.....this however MAKES IT SO EVERY SINGLE THREAD U GO 2 gets this error....

--------------- Added 1263586239 at 1263586239 ---------------

anyone? :(

--------------- Added 1263626369 at 1263626369 ---------------

will pay for a fix???

[Digital Jedi]

What do you mean by "enable the xml file"?

[JonnyThunder]

He means whenever he installs the product (using the XML file)

I get the same thing and have no other modifications installed.

Database error in vBulletin 4.0.1:

Invalid SQL:

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

MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, February 4th 2010 @ 09:23:20 AM
Error Date : Thursday, February 4th 2010 @ 09:23:20 AM
Classname : vB_Database
MySQL Version : 5.0.85-community


I started a new thread with this issue, here (https://vborg.vbsupport.ru/showthread.php?p=1974489#post1974489).

[Digital Jedi]

Since your both having the same issue, see if the link I posted in JonnyThunder's thread is helpful at all.

[JonnyThunder]

I fixed my issue with the instructions I posted in the thread. It's actually a really quick fix!