data base err when active plugin

[IRANCITY]

hi dears
when i active ibpro... i receive database error
but when i click on topic i see data base err
Database error in vBulletin 3.8.5:

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 (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Friday, March 12th 2010 @ 09:15:10 PM
Error Date : Friday, March 12th 2010 @ 09:15:10 PM
Script : http://forum.iecloob.com/showthread.php?t=23722
Referrer :
IP Address : 78.39.40.253
Username : Mr . Saeed
Classname : vB_Database
MySQL Version : 5.0.51a-community-log

[Digital Jedi]

The error in this thread was as result of an upgrade, and not a modification, but maybe it will get you on the right track: http://www.vbulletin.com/forum/showthread.php?338716-Illegal-mix-of-collations-error-while-upgrading-from-3-8-2-to-4-01

[IRANCITY]

i cant fix it ...
why when i install this plugin and active it i recive err ?

[IRANCITY]

:(what am doing now ?

[IRANCITY]

no one cannt help me ?

[Digital Jedi]

This is a really old post, but see if this helps: http://www.vbulletin.com/forum/showthread.php?195137-The-right-way-to-fix-the-(Illegal-mix-of-collations)-problem

Keep in mind, this might be something other than your Arcade causing the problem.