possible 3.8.6 bug, database error when doing social group searches

		منتدى استراحات زايد > استراحات اخرى > منتدى أخبار المواقع والمنتديات العربية والأجنبية
possible 3.8.6 bug, database error when doing social group searches

07-27-2010, 07:30 AM

محروم.كوم

عضو ماسي

بيانات محروم.كوم

رقم العضوية : 503

تاريخ التسجيل : Dec 2007

الجنس : female

علم الدوله : الدوله : United Arab Emirates

المشاركات : 2,100,669

عدد الـنقاط :3341

تقييم المستوى : 2141

possible 3.8.6 bug, database error when doing social group searches

Code:

Invalid SQL:

SELECT d.discussionid, gm.state

FROM discussion AS d
INNER JOIN groupmessage AS gm ON (gm.gmid = d.firstpostid)

WHERE
d.groupid = 19

AND (MATCH(gm.title, gm.pagetext) AGAINST ('gtes' IN BOOLEAN MODE) )

ORDER BY relevance DESC;

MySQL Error : Unknown column 'relevance' in 'order clause'
Error Number : 1054
Request Date : Monday, July 26th 2010 @ 10:35:30 PM
Error Date : Monday, July 26th 2010 @ 10:35:31 PM
Script : http://laserpointerforums.com/group.php

Referrer : http://laserpointerforums.com/group.php?groupid=19
IP Address : removed
Username : adsasdfadfs
Classname : vB_Database
MySQL Version : asfasdfasdf

is anyone else affected?

here is how i generated the error....

go to social groups

click on any social group that has posts in it

Social Group Discussions | Search Discussions

enter search term and hit submit, this will cause a database error

it appears "AS relevance" might be missing from the SQL query. vbulletin said there is no relevance table, but AS relevance might fix the query i think

can anyone else confirm this bug?

i have:

1) disabled all vbulletin hooks/plugins and the error still occurs
2) registered on another vbulletin forum and the error occurs on it too
3) the plugins i did have installed did nothing whatsoever with this code
4) seen that 2 other users reproted this as a bug, but vbulletin support said its not a bug
here is the report of the bug, http://tracker.vbulletin.com/browse/...s:all-tabpanel

however, ironically tracker.vbulletin is down now so i can't get to it=(

please let me know if you are affected by this as well if u are running 3.8.6

thx
-ave __DEFINE_LIKE_SHARE__

إعلانات عشوائية

تعارف بلاك بيري	صور بلاك بيري	قروبات بلاك بيري	اخبار رياضية	العاب فلاش	اهداءات اغاني للهواتف	نغمات جوال
أغاني	مسلسلات رمضان	مسجات	سوق محروم	سيارات للبيع	ارقام سيارات للبيع	برودكاست