Search doesn't work properly with a specific word

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?


Maybe because the topic started off in “uncategorized”?


Looks like something is wrong, Google finds plenty

1 Like

Looks like the search term was canned.

Thank you all, I will walk myself out.

will have a look, this is odd


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.


This is not even correct

Welcome to snowball

1 Like

I fixed this here:

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