search doesn't work for 3 letter words

Quote

Total posts: 178
11 Sep 2014 15:44

If I try to search for 3 letter words in the title of Cobalt articles, it's not found. Words with 4 or more letters are found properly. This problem exists using the standard search plugin. I'm not using smart search.

Last Modified: 12 Sep 2014

Quote

techutopia
Total posts: 202
11 Sep 2014 16:17

Hi,

Please see my related thread here ...

http://www.mintjoomla.com/support/community-forum/user-item/2069-techutopia/48-cobalt-8/4473-searching-for-records-with-text-and-using-standard-titles-unexpected-results.html

Cheers!

Dale.

Quote

nblgeoweb

Total posts: 178
11 Sep 2014 16:50

That indeed was the problem. I didn't realize Joomla searches differently than Cobalt.

I added the following to my.cnf after [mysqld] and restarted mysql:

ft_min_word_len = 3

Then did a rebuild of the full text indexes on my js_res_record_values and js_res_record tables:

REPAIR TABLE `nn0vg_js_res_record` QUICK 
REPAIR TABLE `nn0vg_js_res_record_values` QUICK

(Replace nn0vg with whatever the prefix is for your tables. Doing just the record table may have been enough)

and success. Thanks Dale. I appreciate your help.

Login (copy)