Search doesn't work properly with a specific word

Bug
1

Today (and few days ago) I tried to search here on Meta the word “canned” (for canned replies plugin) but the results is always No results found.
Same results searching “Canned” or even “canned replies”.

This is driving me crazy because on my forum (v1.7.0.beta5 +45) it works:

Meta doesn’t :heart: this word, why?

2 Likes
2

Maybe because the topic started off in “uncategorized”?

EDIT

Looks like something is wrong, Google finds plenty

https://www.google.com/search?q=site%3Ameta.discourse.org%20canned

1 Like
3

Looks like the search term was canned.

Thank you all, I will walk myself out.

will have a look, this is odd

6 Likes
4

OK, this is what is happening… “canned” is being stemmed to “can” and indexed as “can”, later on we perform a TO_TSQUERY on the stemmed word “can” instead of “canned” and … can happens to be a stopword so it gets zero results.

The fix is to stop stemming the search term, will sort it out.

7 Likes
5

This is not even correct

6

Welcome to snowball

http://snowballstem.org/demo.html

1 Like
7

I fixed this here:

https://github.com/discourse/discourse/commit/647ee46edff789634a34dc0a406d19d8a50f21cd

Longer term it may make sense to shift all the stemming into ruby and use a simple fulltext index.

4 Likes