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

[Hell Bomb]

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 1277865111 at 1277865111 ---------------

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