
01-19-2005, 01:48 PM
|
|
|
Join Date: Jan 2005
Posts: 14
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Invalid SQL: SELECT
hi, could anyone let me know what this means? a member was playing games in the arcade and all of a sudden this happen(via emails sent to admin etc)
Any help or guidence on this is much appreicated, thanks.
Quote:
Invalid SQL: SELECT
IF(votenum >= 2, votenum, 0) AS votenum, IF(votenum >= 2 AND votenum != 0,
votetotal / votenum, 0) AS voteavg,
thread.threadid, thread.title, replycount, postusername, postuserid,
thread.dateline AS postdateline, IF(views<=replycount, replycount+1, views) AS
views, forumid, post.postid, pagetext, allowsmilie, showsignature
,thread.iconid AS threadiconid
, attachment.filename, attachment.filesize, attachment.visible, attachmentid,
counter, thumbnail, LENGTH(thumbnail) AS thumbnailsize
, avatarpath, NOT ISNULL(avatardata) AS hascustom, customavatar.dateline AS
avatardateline
, NOT ISNULL(subscribethread.subscribethreadid) AS subscribed
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (user.userid = post.userid)
LEFT JOIN attachment AS attachment ON (post.postid = attachment.postid)
LEFT JOIN avatar as avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar as customavatar ON (customavatar.userid = user.userid)
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid =
thread.threadid AND subscribethread.userid = 16)
WHERE forumid IN(4,15,16,51,70,)
GROUP BY post.postid
ORDER BY postdateline DESC, attachmentid LIMIT 8
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 post.postid
ORDER BY postdateline DESC, atta
mysql error number: 1064
Date: Wednesday 19th of January 2005 12:46:13 PM
Script: MY.SITE.COM
Referer:
Username: XXXXXX
IP Address: XXXXX
|
|