By default, activeCollab uses the MySQL FULLTEXT index for search, which works well, but in some cases MySQL can be configured not to index words shorter than 4 characters. To correct this and configure MySQL to index three-letter words (it's not recommended to go shorter than three characters), you will need to set the value of ft_min_word_len directive in your my.cnf file:
[mysqld] ft_min_word_len=3
After you're finished, restart your MySQL server and rebuild the FULLTEXT index by dropping and creating the index on the content field in the search_index table:
ALTER TABLE `acx_search_index` DROP INDEX `content`); ALTER TABLE `acx_search_index` ADD FULLTEXT ( `content`);
If you wish to find our more information about the fine-tuning MySQL FULLTEXT search, you can found it at this section of the MySQL documentation.
activeCollab is a fine product of A51 d.o.o
activeCollab name and logo are trademarks or registered trademarks of A51 d.o.o.