desconexion
12-05-2008, 12:03 AM
I get this error when I enable the arcade in the Products manager
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_spanish_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, December 4th 2008 @ 06:58:48 PM
Error Date : Thursday, December 4th 2008 @ 06:58:48 PM
Script : http://www.desconexioncubana.com/foro/showthread.php?t=11519
Referrer : http://www.desconexioncubana.com/foro/forumdisplay.php?f=2
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community-log
If I disable it, the arcade still works, this is wierd, can you help me with this.
running VB 3.7.4 PL1
cheers
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_spanish_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, December 4th 2008 @ 06:58:48 PM
Error Date : Thursday, December 4th 2008 @ 06:58:48 PM
Script : http://www.desconexioncubana.com/foro/showthread.php?t=11519
Referrer : http://www.desconexioncubana.com/foro/forumdisplay.php?f=2
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community-log
If I disable it, the arcade still works, this is wierd, can you help me with this.
running VB 3.7.4 PL1
cheers