![]() |
after upgrade from 3.7.2 to 3.7.3 got this error
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 |
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. |
Quote:
Edit: i find out thanks |
All times are GMT. The time now is 05:11 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|