JonnyThunder
02-04-2010, 07:25 AM
Hello,
I'm running VB 4.01 with no mods. When I install the arcade as per instructions, I get the following SQL error when I try to view any thread....
Database error in vBulletin 4.0.1:
Invalid SQL:
SELECT t.champion, u.userid FROM vb_tournaments AS t
LEFT JOIN vb_user AS u ON (t.champion = u.username)
WHERE champion<>'';
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, February 4th 2010 @ 09:23:20 AM
Error Date : Thursday, February 4th 2010 @ 09:23:20 AM
Classname : vB_Database
MySQL Version : 5.0.85-community
Is anyone else getting this? The only way I can stop it happening is to uninstall the arcade software.
I'm running VB 4.01 with no mods. When I install the arcade as per instructions, I get the following SQL error when I try to view any thread....
Database error in vBulletin 4.0.1:
Invalid SQL:
SELECT t.champion, u.userid FROM vb_tournaments AS t
LEFT JOIN vb_user AS u ON (t.champion = u.username)
WHERE champion<>'';
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_german2_ci,IMPLICIT) for operation '='
Error Number : 1267
Request Date : Thursday, February 4th 2010 @ 09:23:20 AM
Error Date : Thursday, February 4th 2010 @ 09:23:20 AM
Classname : vB_Database
MySQL Version : 5.0.85-community
Is anyone else getting this? The only way I can stop it happening is to uninstall the arcade software.