Hi,
I just installd this mode but i got a little problem:
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT *, s.name, u.username, !(BIT_OR(ug.radiotvpermissions) & 64) as candomagic
FROM vb_radiostation_rating AS r
LEFT JOIN vb_user AS u ON (u.userid = r.userid)
LEFT JOIN vb_usergroup AS ug ON (find_in_set(ug.usergroupid, u.membergroupids) OR (ug.usergroupid = u.usergroupid))
LEFT JOIN vb_radiostation AS s ON (s.stationid = r.stationid)
WHERE r.userid IN ()
GROUP BY r.ratingid
HAVING candomagic > 0;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY r.ratingid
HAVING candomagic > 0' at line 6
Error Number : 1064
Request Date : Saturday, June 6th 2009 @ 11:26:59 PM
Error Date : Saturday, June 6th 2009 @ 11:26:59 PM
Script :
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.67-community
I get this database error when i hit Clean Up --> "Clean Ratings" Clean Now.
I hope you can fix this.
Kind regards,
Dutch_Boy.
|