help mysql Error Number : 1267

[sasairaq]

im getting an error message when i open a thread

Database error in vBulletin 3.8.0 Beta 3:
Invalid SQL:
   SELECT t.champion, u.userid FROM tournaments AS t
   LEFT JOIN user AS u ON (t.champion = u.username)
   WHERE champion<>'';
MySQL Error   : Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Saturday, November 22nd 2008 @ 12:50:42 PM
Error Date    : Saturday, November 22nd 2008 @ 12:50:42 PM
Script        : http://irqtube.com/vb/showthread.php?t=16695
Referrer      : http://irqtube.com/vb/
IP Address    : 98.243.94.226
Username      : sasa
Classname     : vB_Database
MySQL Version : 5.0.51a-community 

[sasairaq]

nvm

nvm guys i fixed it it was an sql argument from the ibp arcade the collasion made the problem thanks anyways.