Mysql Error

[CodyMuir]

Well, everything was fine, then i try to view a topic and i get this.

Database error in vBulletin 3.7.2:

Invalid SQL:

SELECT t.champion, u.userid FROM vtournaments AS t
LEFT JOIN vuser AS u ON (t.champion = u.username)
WHERE champion<>'';

MySQL Error : Illegal mix of collations (latin1_german2_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, July 3rd 2008 @ 11:48:23 PM
Error Date : Thursday, July 3rd 2008 @ 11:48:23 PM
Script : http://clandwd.com/showthread.php?t=114
Referrer :
IP Address : xx.xx.xx.134
Username : Atreyu]DwD[
Classname : vb_database
MySQL Version : 5.0.51a-log


When i disable the mod, everything works properely, just no arcade.
I have installed this mod before and i know it works, and i really like it.
But i don't know why its doing this.
Help?
Thanks, Cody.

[CodyMuir]

help, please?

[ChrisChristian]

Same error here.

VB 3.7.2 and Arcade latest version.

FIXED:

Altered the table tournaments to the same collation as my database including the fields.