[starwest]

Originally Posted by wjbrewer

Hello.

This sounds like a problem with the 4 letter MySQL word limit, which would cause the incorrect results for 'tea', and 'Pau'. You can edit this by changing (or adding) this to the etc/my.cnf file:

ft_min_word_len=2

or

ft_min_word_len=3

You may have to have your web host, or web manager do this for you. After this restart MySQL and rebuild the search database and your results will be accurate down to 2 or 3 letter words.

http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#option_mysqld_ft_min_word_len

--

Thanks Bill - I appreciate the assistance... I just wish I could test it out.

Just an FYI for others on shared hosting:

Unfortunately, on shared ecommerce hosting through one of the better hosts around, I've been told that the above change will potentially impact the performance of the server too much, as well as require the other uses to re-index their databases, so it isn't a change that can be made. For anyone else on shared hosting that's thinking about purchasing this mod, you may want to consider how important short 2-3 letter words are within your products and ask your host in advance if they're willing to make this change to the server configuration.