ok im got this db problem it shows this...how do i fix it?
Code:
Database error in vBulletin 3.8.1:
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_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Saturday, April 11th 2009 @ 04:32:58 AM
Error Date : Saturday, April 11th 2009 @ 04:32:58 AM
Script : XXXXXX/vb/showthread.php?p=1255
Referrer : XXXXX/vb/index.php
IP Address : XXXXXXXXXXXX
Username : XXXXX
Classname : vB_Database
MySQL Version : 5.0.67-community