novastar
01-28-2007, 06:31 AM
I installed this plugin just fine, did the few template modifications, etc.
But i keep getting this error when trying to view posts and such.
Database error in vBulletin 3.6.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_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Sunday, January 28th 2007 @ 07:59:10 AM
Script : http://www.talkhost.info/forum/showthread.php?t=9238
Referrer :
IP Address : xx.xxx.xx.xxx
Username : novastar
Classname : vB_Database
I dont know why I am getting this, i tried changing the collations of all the mysql tables to make them all the same, and its still giving me this error.
When i disable this product in the Manage Products page, the errors go away, and I can still play the games in the arcade, though they wont save the scores, but as soon as i turn it back on, the errors come back.
Any help would be greatly appriciated.
But i keep getting this error when trying to view posts and such.
Database error in vBulletin 3.6.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_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Sunday, January 28th 2007 @ 07:59:10 AM
Script : http://www.talkhost.info/forum/showthread.php?t=9238
Referrer :
IP Address : xx.xxx.xx.xxx
Username : novastar
Classname : vB_Database
I dont know why I am getting this, i tried changing the collations of all the mysql tables to make them all the same, and its still giving me this error.
When i disable this product in the Manage Products page, the errors go away, and I can still play the games in the arcade, though they wont save the scores, but as soon as i turn it back on, the errors come back.
Any help would be greatly appriciated.