cryrichter
New Member
Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.sticky, thread.prefixid, thread.taglist, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible,
thread.hiddencount, thread.deletedcount, thread.attach, thread.postusername, thread.forumid,
replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.lastpost, thread.lastposter, thread.lastpostid
,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid , firstpostid, post.pagetext AS previewbbcode
FROM thread AS thread
LEFT JOIN user AS user ON(user.userid = thread.postuserid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
WHERE thread.threadid IN
(569, 568, 567, 566, 565, 564, 563, 562, 561, 560, 559, 558, 557, 556, 555, 554, 500, 207, 297, 535, 208, 529, 494, 495, 496);
MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Sunday, August 3rd 2008 @ 05:12:44 PM
Error Date : Sunday, August 3rd 2008 @ 05:12:44 PM
Script : Nitepr United - Forum Rules
Referrer : Nitepr United - Forum Rules
IP Address : 24.29.27.34
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.51a-community
please tell me what to do! Thanks alot
Invalid SQL:
SELECT post.pagetext AS preview,
thread.threadid, thread.threadid AS postid, thread.title AS threadtitle, thread.iconid AS threadiconid, thread.dateline, thread.forumid,
thread.sticky, thread.prefixid, thread.taglist, thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible,
thread.hiddencount, thread.deletedcount, thread.attach, thread.postusername, thread.forumid,
replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.lastpost, thread.lastposter, thread.lastpostid
,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
user.userid AS postuserid
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid , firstpostid, post.pagetext AS previewbbcode
FROM thread AS thread
LEFT JOIN user AS user ON(user.userid = thread.postuserid)
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
WHERE thread.threadid IN
(569, 568, 567, 566, 565, 564, 563, 562, 561, 560, 559, 558, 557, 556, 555, 554, 500, 207, 297, 535, 208, 529, 494, 495, 496);
MySQL Error : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number : 1140
Request Date : Sunday, August 3rd 2008 @ 05:12:44 PM
Error Date : Sunday, August 3rd 2008 @ 05:12:44 PM
Script : Nitepr United - Forum Rules
Referrer : Nitepr United - Forum Rules
IP Address : 24.29.27.34
Username : Admin
Classname : vB_Database
MySQL Version : 5.0.51a-community
please tell me what to do! Thanks alot