The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
![]()
hello
i have more errors after upgrde to vb3.7.0 when any member press on http://www.cgway.net/search.php?do=getnew will get this error Code:
Database error in vBulletin 3.7.0: 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.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 , post.pagetext AS previewbbcode 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 (11115, 11100, 9266, 11104, 11114, 11087, 11093, 10970, 11113, 6216, 11103, 11105, 10961, 7970, 10851); 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 Request Date : Wednesday, May 7th 2008 @ 02:25:45 AM Error Date : Wednesday, May 7th 2008 @ 02:25:45 AM Script : http://www.cgway.net/search.php?searchid=97720 Referrer : http://www.cgway.net/private.php?do=showpm&pmid=135873 IP Address : 212.43.19.1 Username : gfhhj Classname : vB_Database MySQL Version : 5.0.45-community-log i wait the support |
![]() |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|