Results 1 to 6 of 6

Thread: Today Post, New Post & Search Database Errors

  1. #1
    Senior Member ericpsf's Avatar
    Join Date
    Feb 2008
    Posts
    134

    Lightbulb Today Post, New Post & Search Database Errors

    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:
    Code:
    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:

    Code:
    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

  2. #2
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,463

    Default Re: Today Post, New Post & Search Database Errors

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

  3. #3
    Junior Member
    Join Date
    May 2008
    Posts
    2

    Default Re: Today Post, New Post & Search Database Errors

    Bump. I'm having the same exact problem.

  4. #4
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,463

    Default Re: Today Post, New Post & Search Database Errors

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

  5. #5
    Senior Member ericpsf's Avatar
    Join Date
    Feb 2008
    Posts
    134

    Default Re: Today Post, New Post & Search Database Errors

    Quote Originally Posted by suodraxah View Post
    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.

  6. #6
    Junior Member
    Join Date
    May 2008
    Posts
    2

    Default Re: Today Post, New Post & Search Database Errors

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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Strange post-search highlighting problem
    By JamesCybert in forum Bugs From 2.0.1
    Replies: 3
    Last Post: 10-18-2007, 08:24 AM
  2. Post Icons and Last Post button
    By ryr8828 in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 04-04-2007, 10:29 PM
  3. new post search doesnt work...
    By nexus851 in forum Troubleshooting & Problems
    Replies: 1
    Last Post: 11-15-2005, 11:51 AM
  4. extracting links from vbulletin post database
    By crankshaft in forum Feedback & Suggestions
    Replies: 0
    Last Post: 08-16-2005, 03:57 PM
  5. My post icons went away, as did the line under post titles
    By Noah in forum Troubleshooting / "How do I..." Questions
    Replies: 3
    Last Post: 12-23-2004, 06:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •