| jluerken |
02-15-2013 07:58 AM |
The exlude of a forumid does not work for me and as soon as I use multiple forumid's in the settings like 1,2,3 I get a db error.
We're using vb 4.2 and it would be nice to get an update and fix of this great addon.
Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid
,forum.childlist
FROM vb_thread AS thread
LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid)
LEFT JOIN vb_forum AS forum ON (forum.forumid = 59,15)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND FIND_IN_SET(thread.forumid, forum.childlist)
ORDER BY lastpost DESC
LIMIT 0, 15;
MySQL Error : Operand should contain 1 column(s)
Error Number : 1241
|
More Information