Today Post, New Post & Search Database Errors

[ericpsf]

Hi,

When I click on either "Today Post", "New Post", and key in a wording in the "Search", I received the following database errors

Error for "New Post" was:

Database error in vBulletin 3.6.8:

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.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
				thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount,
				thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid,


				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
				
				, 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 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
		(752);

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
Date         : Wednesday, March 5th 2008 @ 05:58:53 PM
Script       : http://www.mysite/forums/search.php?searchid=1003
Referrer     : http://www.mysite.com/forums/search.php?do=getnew
IP Address   :xxx
Username     : xxx
Classname    : vB_Database

Error for "Search" was:

Database error in vBulletin 3.6.8:

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.replycount, IF(thread.views=0, thread.replycount+1, thread.views) as views, thread.sticky,
				thread.pollid, thread.open, thread.lastpost AS postdateline, thread.visible, thread.hiddencount, thread.deletedcount,
				thread.lastpost, thread.lastposter, thread.lastpostid, thread.attach, thread.postusername, thread.forumid,


				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
				
				, 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 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
		(750, 741, 667, 587, 624, 387, 726, 351, 714, 712, 633, 710, 708, 706, 705, 537, 180, 670, 696, 695, 685, 692, 676, 446, 669);

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
Date         : Wednesday, March 5th 2008 @ 06:00:06 PM
Script       : http://www.mysitename/forums/search.php?searchid=1006
Referrer     : http://www.mysitename.com/forums/search.php?do=process
IP Address   : xxx
Username     : xxx

Please kindly help. Thank you.

Regards,
Eric

[Brian]

Your "Today's Posts" link seems to be working fine for me, so I'm assuming you were able to figure out the problem?

[suodraxah]

Bump. I'm having the same exact problem.

[Brian]

The New Posts link is a function of vBulletin, so you will need to ask for support at their forums.

[ericpsf]

Originally Posted by suodraxah

Bump. I'm having the same exact problem.

Hi suodraxah,

The above mentioned problems is due to a mod (can't remember it after I had uninstalled it). This mod basically adds a "thumbnail" of a recent attachment of a thread to the left-hand side of the forum. So there are some conflicts between this mod's and vB's search property.

Tips: just disable yr recent installation mods and c how.

Hope that it helps.

[suodraxah]

Yep! I just installed that mod. Thanks a lot!