Search with searchword with less than 4 charcater

[JochenS]

On my system the search for items with 3 characters are not working. in the SQL help http://dev.mysql.com/doc/refman/5.1/en/ ... olean.html I found the hint to the SQL setting "ft_min_word_len". This is acutally 4.

My question now to the phpMyFAQ users: If I change the ft_min_word_len to 3, do I need to rebuild some indexes?

[jason102178]

Hi JochenS

I was checking out your FAQ i wasnt sure if the honeywell one was yours or not but , i was wondering how you were testing it with No FAQs in your database they all say 0, unless you have another FAQ database

[Thorsten]

Hi,

after changing the ft_min_word_len in MySQL, you have to restart the MySQL server and rebuild the FULLTEXT index.

bye
Thorsten

[JochenS]

@ Jason, this database is in German and Dutch language. The english language packet couldn't be disabled. A common search term is there "VMM"

@Thorsten, ok I'll try it with a

Code: Select all

REPAIR TABLE faqdata QUICK

I'll keep you updated.

[JochenS]

The default of a MySQL installation is ft_min_word_len = 4. This means searchterms with a lenght of less than 4 words are ignored.
E.g: It is impossible to search for a term 'the' because it is too short. The workaround is to use the searchterm 'the*', which was implemented in phpMyFAQ versions until 2.7, but this disabled the functionality to search for terms like '+searchterm1 +searchterm2'.

This is what I have done:

• Stopped MySQL server
  added the line ft_min_word_len = 4 to the file mysql.ini
  Started the MySQL server
  and executed with phpMyAdmin 'REPAIR TABLE faqdata QUICK'

[JochenS]

The default of a MySQL installation is ft_min_word_len = 4. This means searchterms with a lenght of less than 4 words are ignored.
E.g: It is impossible to search for a term 'the' because it is too short. The workaround is to use the searchterm 'the*', which was implemented in phpMyFAQ versions until 2.7, but this disabled the functionality to search for terms like '+searchterm1 +searchterm2'.

This is what I have done:

• Stopped MySQL server
  added the line ft_min_word_len = 4 to the file mysql.ini
  Started the MySQL server
  and executed with phpMyAdmin 'REPAIR TABLE faqdata QUICK'