PDA

View Full Version : Help Support Pro - Search Feature Not Working


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