You may have noticed that if your search your knowledgebase certain articles do not show up, such as if you search for “FTP” or “VPN”, you get nothing.
This is because MySQL by default does not index words with less than 4 characters, which is for performance issues.
To get around this you need to edit your my.ini file or whatever file contains your MYSQLD settings.
Find the following setting: ft_min_word_len
and change it’s value to 3.
If your using MySQL Workbench, then see this screenshot. 
You then need to rebuild your KB index, login to your FUSION admin, go to Knowledgebase –> Maintenance and click rebuild.
You should now be able to search and find articles using 3 letter words.
If it still doesn’t work, then you may need to REPAIR the tables “swkbarticles” and “swkbarticledata” which will re-index then using the new value.
In PHPMyAdmin, go tot he table view, check the 2 mentioned tables, scroll down to the bottom and choose “repair” from the dropdown list.
Recent Comments