Blue Square
27th January 2006, 09:09 PM
Can anybody help me figure out why the search feature doesnt work in Help Support Pro?
blue square
27th January 2006, 10:30 PM
Playing around with the sql in function searchByMysqlFulltextstatement
in the file HelpSearch.class.php
I was able to fix the issue by adding the syntax "IN BOOLEAN MODE"
SELECT *, MATCH(question, answer) AGAINST ('keyword1' IN BOOLEAN MODE)
as Relevancy FROM hm_items WHERE deleted=0 and disabled=0 and MATCH(question, answer)
AGAINST('keyword1' IN BOOLEAN MODE) ORDER BY Relevancy DESC
vBulletin® v3.7.2, Copyright ©2000-2009, Jelsoft Enterprises Ltd.