Illegal Mix Of Collations

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 [DATE]1263569703[/DATE] at [TIME]1263569703[/TIME] ---------------

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 [DATE]1263586239[/DATE] at [TIME]1263586239[/TIME] ---------------

anyone?

--------------- Added [DATE]1263626369[/DATE] at [TIME]1263626369[/TIME] ---------------

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.

[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!