You've got each of these statements in there twice:
Quote:
, attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid
|
Quote:
LEFT JOIN attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png'))
|
It looks like you modified the search.php page and added that statement, in which case if you upload the original php page, it should be fine. OR you installed a hack which is adding in that extra line in which case you need to disable that hack. I'm guessing it is the second problem and the plugin was added twice by mistake.