Cant view threads when arcade plugin is on????

Well if i turn on the arcade and try to view a thread this is the error i get

Database error in vBulletin 3.8.5:

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_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number  : 1267
Request Date  : Tuesday, June 29th 2010 @ 06:19:40 PM
Error Date    : Tuesday, June 29th 2010 @ 06:19:40 PM
Script        : http://forum.trinityentertainment.net/showthread.php?t=317
Referrer      : http://forum.trinityentertainment.net/news-announcements/
IP Address    : 66.62.93.48
Username      : Hell Bomb
Classname     : vB_Database
MySQL Version : 5.0.91-community-log

--------------- Added [DATE]1277865111[/DATE] at [TIME]1277865111[/TIME] ---------------

anyone???

[gersforum@gmail]

Go to phpmyadmin, find the tournament table and change the collation to "latin1_swedish_ci".

My problem was with two other collations but just change it the second one you see in your error "Illegal mix of collations".

[Hell Bomb]

Yea i had to uninstall the product, change the colliation for the whole database, then reinstall