05-12-2008, 01:26 PM
|
|
|
|
Join Date: Aug 2006
Location: Switzerland
Posts: 51
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
New posts causes SQL error
Hey
I get this sql error after clicking the link "New posts" in the navbar. This happends only after the upgrade to vb 3.7.0. Worked fine with 3.6.8. Any ideas what that error message could cause?
Quote:
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
, threadread.readtime AS threadread
, thread.firstpostid, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid
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 threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
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
(879);
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 : Monday, May 12th 2008 @ 03:20:01 PM
Error Date : Monday, May 12th 2008 @ 03:20:01 PM
Script : http://www.xxx.xy/forum/search.php?searchid=55
Referrer : http://www.xxx.xy/forum/search.php?do=getnew
IP Address : -
Username : -
Classname : vB_Database
MySQL Version : 5.0.18-Max
|
--------------- Added [DATE]1210609223[/DATE] at [TIME]1210609223[/TIME] ---------------
This is caused by the thread thumbnail hack and can be fixed with disabling the thread thumbnail search plugin in your acp.
-- Thread can be closed
|