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???

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

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

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


I started a new thread with this issue, here.

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

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