Searching

[jeffw]

2.7 RC
I see some changes have been made to the searching of the database, can you please explain how searching now works?

If i search the database for the phrase "where can i" I get no results. I though maybe it was now using the stopwords (which would be prefered) so i added a few stopwords but these always give me results, so guess it's not the case.

Why do i get 0 hits on the above phrase?

[Thorsten]

Hi,

without any knowledge about your data I cannot answer your question, sorry.

bye
Thorsten

[jeffw]

What would you like to know to answer the question?

[Thorsten]

Hi,

can I view your FAQ installation?

bye
Thorsten

[jeffw]

http://faq-alpha.lib.warwick.ac.uk

[Thorsten]

Hi,

which version of MySQL do you use?

bye
Thorsten

[jeffw]

MySQL 5.0.51a

[jeffw]

Tried with both mysql and mysqli, results the same.

[Thorsten]

Hi,

it's really strange, is it possible to get access to your phpMyAdmin?

bye
Thorsten

[jeffw]

I've pm'd you the password to one of my test sites.

I've also checked this on Jason's website (https://jaysonberger.com/faqs/) searching for "how can i" and this also gives no hits.

[Thorsten]

Hi,

yes, if you search for words with less than 4 characters MySQL strips the result.

bye
Thorsten

[jeffw]

Ok, thanks for that bit of info.

What happens to the word 'where' as this gives no results.

[Thorsten]

Hi,

I think it's in MySQL's threshold... but normally phpMyFAQ should try to search for those short words as well...

bye
Thorsten

[JochenS]

Therefore I set the "ft_min_word_len". See: viewtopic.php?f=2&t=12433&p=35358&hilit ... len#p35358
This applies, if multiple search terms are used, or an apostophe is in the search words, or...

Which is your exact searchterm? I expect 'how can I' will return an emtpy list, because suppose the words how, can, i are on the MYSQL complied stopword list .(see here http://dev.mysql.com/doc/refman/5.1/en/ ... uning.html

You should search literally e.g for '"How can I"' or '"how" "can" "I"'

[jeffw]

Ok, many thanks. I'll give it a go tomorrow. Also i'll have a play with ft_stopword_file at the same time.