karmatest.php give a db error
Invalid SQL:
SELECT userrating.voteid as voteid, userrating.userid as userid, userrating.raterid as raterid, userrating.ratername as ratername, userrating.rating as rating, userrating.active as active, userrating.dateline as dateline, userrating.ipaddress as ipaddress
FROM vb_userrating AS userrating
INNER JOIN vb_user AS user ON ( userrating.raterid = user.userid
AND user.karma =1)
WHERE userrating.userid = AND user.karma = 1 AND user.usergroupid NOT
IN (1,3,4) AND ((1186962797-user.lastactivity)/86400<=30)
ORDER BY userrating.rating DESC;
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 'AND user.karma = 1 AND user.usergroupid NOT
IN (1,3,4) AND ((1186962797-user' at line 5
Error Number : 1064
|