[steveninstl]

OK...I'm back...

I upgraded (I'm starting to hate upgrades) to VB 3.7.3 and I get this new SQL..


Database error in vBulletin 3.7.3:

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


, 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 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
GROUP BY thread.threadid;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'GROUP BY thread.threadid' at line 24
Error Number : 1064
Request Date : Thursday, August 28th 2008 @ 07:41:56 AM
Error Date : Thursday, August 28th 2008 @ 07:41:56 AM
Script : http://www.pimpmyberry.com/search.php?searchid=2966
Referrer :
IP Address : 1234567890
Username : StevenInSTL
Classname : vB_Database
MySQL Version : 5.0.51a-community




I did all the fixes to the search.php, and I still get the error...

Any idea?