GaiLoan
08-30-2008, 07:21 AM
Hi, after upgrade from 3.7.2 to 3.7.3 got this error, this error from the search, New Post etc. accept Advanced Search
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT
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
FROM vbb_thread AS thread
LEFT JOIN vbb_user AS user ON(user.userid = thread.postuserid)
LEFT JOIN vbb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vbb_subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 2 AND canview = 1)
LEFT JOIN vbb_attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
WHERE thread.threadid IN
(877, 874, 882, 887, 536, 885, 886, 883, 696, 131, 863, 884, 875, 881, 880, 879, 878, 860, 876, 873, 872, 871, 821, 826, 866);
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
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT
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
FROM vbb_thread AS thread
LEFT JOIN vbb_user AS user ON(user.userid = thread.postuserid)
LEFT JOIN vbb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vbb_subscribethread AS subscribethread
ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 2 AND canview = 1)
LEFT JOIN vbb_attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
WHERE thread.threadid IN
(877, 874, 882, 887, 536, 885, 886, 883, 696, 131, 863, 884, 875, 881, 880, 879, 878, 860, 876, 873, 872, 871, 821, 826, 866);
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