idoL1
01-17-2010, 03:16 AM
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....
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....