I get this error:
Code:
Database error in vBulletin 3.7.0 Beta 4:
Invalid SQL:
SELECT c.*, g.gcat, g.gid, g.gname,u.username,u.usergroupid,cat.password,COUNT(champ_mid) AS total
FROM games_list AS g, games_cats AS cat, games_champs AS c
LEFT JOIN user AS u ON(c.champ_name = u.username)
WHERE c.champ_gid=g.gid AND g.gcat=cat.c_id AND cat.password=''
GROUP BY userid ORDER BY total DESC LIMIT 0,3;
MySQL Error : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='
Error Number : 1267
Date : Thursday, February 14th 2008 @ 10:16:33 AM
Script : http://www.domain.com/index.php
Referrer : http://www.domain.com/admincp/index.php?do=head
IP Address : ...
Username : ...
Classname : ...
MySQL Version : 4.1.22-standard-log
I got a similar error when I installed the arcade... but when i disable the product, everything's ok... Any suggestions?