HelpSpot Help Desk Software | HelpSpot Blog | HelpSpot Support

Trying to search on the word "PDA" and not receiving any results


Tried it for other abbreviations as well with no search results. Is there a bug in the system with regard to searching for abbreviations? I chose “All Areas” to search on.


Hi Alethea,

It sounds like you’re probably using MySQL. The fulltext search engine in MySQL defaults to only indexing words greater than 3 characters. You’ll need to modify the ft_min_word_len variable in MySQL down to 3 (or even 2). Also, I believe you’ll need to rebuild the full text indexes. There’s one in each of these 3 tables:

HS_Request_History, HS_KB_Pages, HS_Forums_Posts


Okay, we’ll look into that. Thanks for the quick response!