Database error in vBulletin 4.1.6:
Invalid SQL:
SELECT u.*, s.*, a.avatarpath, NOT ISNULL(c.userid) AS hascustomavatar, c.dateline AS avatardateline, c.width AS avwidth, c.height AS avheight, c.height_thumb AS avheight_thumb, c.width_thumb AS avwidth_thumb, c.filedata_thumb FROM vb_dbtech_vbarcade_session AS s LEFT JOIN vb_user AS u ON (s.userid = u.userid) LEFT JOIN vb_avatar AS a ON (a.avatarid = u.avatarid) LEFT JOIN vb_customavatar AS c ON (c.userid = u.userid) WHERE s.record = 4 AND s.gameid = 'helicopterv32MICRO' ORDER BY s.score DESC, s.timefinish ASC LIMIT -10, 10;
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 '-10, 10' at line 1
Error Number : 1064
Request Date : Monday, September 19th 2011 @ 01:13:00 PM
Error Date : Monday, September 19th 2011 @ 01:13:01 PM
Script :
http://www.ak47ps3.com/forums/arcade.php?game=helicopterv32MICRO&do=scores&latest
Referrer :
Helicopter2 - AK47 PS3 Clan Forums
IP Address : xxx.xxx.xxx.xxx
Username : Demonic_Kn1ght
Classname : vB_Database
MySQL Version : 5.1.58-community-log
