
08-13-2007, 11:09 AM
|
|
|
Join Date: Jul 2005
Location: Greece
Posts: 1,856
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by EnIgMa1234
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
|
karmatest.php?? Did I include that in the package??
LOL!! 
Ignore that file, its just a test I was doing to debug sth, I forgot it inside the package.
|