I Do It
all character and text tables Are 'latin1_swedish_ci' (url_discut,Champion,creat Tables) And So tournaments .
int Tables Are Not 'latin1_swedish_ci' An I Couldnt Change Them .
When ibProArcade is enabled I receive database error when I try open any thread:
Code:
Database error in vBulletin 3.7.4:
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 : Monday, January 12th 2009 @ 07:22:22 PM
Error Date : Monday, January 12th 2009 @ 07:22:22 PM
Script : http://irantrack.com/Forum/showthread.php?t=8328
Referrer : http://www.irantrack.com/Forum/
IP Address : 91.98.87.165
Username : Hamid.Park
Classname : vB_Database
MySQL Version : 5.0.45-log
What Can I Do For IT ?