|
إنضمامك إلي منتديات استراحات زايد يحقق لك معرفة كل ماهو جديد في عالم الانترنت ...
انضم الينا
#1
| ||
| ||
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__ |
مواقع النشر (المفضلة) |
| |