| 1320Nation |
11-02-2009 02:07 PM |
After updating the mod to the current version, I get the following database error when selecting the "First Attachment" option in the Thumbnail Source part of the mod. The "User Entered URL" and "First Image In Post" options both appear to be working with no problems.
I hope a fix can be found for this error.
PHP Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadredirect.expires
, hasannuser.displaygroupid AS hasanndisplaygid, hasannuser.usergroupid AS hasannusergid, huseyinuser.displaygroupid AS huseyindisplaygid, huseyinuser.usergroupid AS huseyinusergid, MIN(attachment.attachmentid) AS attachmentid
FROM board_thread AS thread
LEFT JOIN board_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN board_post AS post ON(post.postid = thread.firstpostid)
LEFT JOIN board_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN board_user AS hasannuser ON (thread.lastposter = hasannuser.username)
LEFT JOIN board_user AS huseyinuser ON (thread.postuserid = huseyinuser.userid)LEFT JOIN board_attachment AS attachment ON (attachment.postid = thread.firstpostid AND attachment.extension IN('jpg', 'gif', 'png', 'jpeg', 'bmp'))
WHERE thread.threadid IN (0,33703,33677,33670,33669,33646,33625,33624,33612,33611,33609,33597,33594,33590,33578,33570,33569,33565,33552,33540,33530,33529,33516,33499,33498,33487,33484,33471,25660,25688,25725,25655,25945)
ORDER BY sticky DESC, lastpost DESC;
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, November 2nd 2009 @ 10:56:21 AM
Error Date : Monday, November 2nd 2009 @ 10:56:22 AM
Script : http://www.******.com/forums/forumdisplay.php?f=80
Referrer : http://www.******.com/forums/index.php
IP Address : 98.***.***.***
Username : *** ***
Classname : vB_Database
MySQL Version : 5.0.45
|
More Information