Some1 Who Knows Mysql Plz Answer
 

ANYBODY understand this error...i figured it was just the 2 tables were in diff collations but i tried switching both to the same as the other and still get it..this errorr ONLY HAPPENDS when i have ibproarcade enabled....and it happends ANYTIME I GO TO ANY THREAD OR POST ON MY SITE

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

i will pay some1 20 bucks paypal if they have a fix for this....