The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
![]()
Hi, after upgrade from 3.7.2 to 3.7.3 got this error, this error from the search, New Post etc. accept Advanced Search
Database error in vBulletin 3.7.3: Invalid SQL: SELECT 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 , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed , attachment.thumbnail_filesize AS thumbsize , MIN(attachment.attachmentid) AS attachmentid FROM vbb_thread AS thread LEFT JOIN vbb_user AS user ON(user.userid = thread.postuserid) LEFT JOIN vbb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread') LEFT JOIN vbb_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 2 AND canview = 1) LEFT JOIN vbb_attachment as attachment ON(attachment.postid = thread.firstpostid AND (attachment.extension = 'jpg' OR attachment.extension = 'gif' OR attachment.extension = 'png')) WHERE thread.threadid IN (877, 874, 882, 887, 536, 885, 886, 883, 696, 131, 863, 884, 875, 881, 880, 879, 878, 860, 876, 873, 872, 871, 821, 826, 866); 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 |
#2
|
|||
|
|||
![]()
Most likely caused by a modification.
To troubleshoot this, please remove any hacks and disable your plugins, then see if you still have this problem. Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php define('DISABLE_HOOKS', true); If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server. |
#3
|
|||
|
|||
![]() Quote:
Edit: i find out thanks |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|