[Tiki-devel] Issue with innoDB MySQL search results for "he" (but not for "fr" or "en")

Hello,

May be someone can help with an issue I have since a few versions for on Tiki22. (was working previously)

In a file gallery I have files with in their filenames "en", "fr" or "he".

If I perform a search and filter files with "en" and "fr" in the filename I got results.
If I perform a search and filter files with "he" no results found.

I tried to locate and check the stopwords list used as "he" could be seen as a "pronoun".

In the Tiki admin the stopwords (never touched) field doesn’t show a "he" (not sure why there is a "s" and a "t"

And it is the same in the innoD stopword list (no "he")

MariaDB [information_schema]> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_DEFAULT_STOPWORD;
+-------+
| value |
+-------+
| a     |
| about |
| an    |
| are   |
| as    |
| at    |
| be    |
| by    |
| com   |
| de    |
| en    |
| for   |
| from  |
| how   |
| i     |
| in    |
| is    |
| it    |
| la    |
| of    |
| on    |
| or    |
| that  |
| the   |
| this  |
| to    |
| was   |
| what  |
| when  |
| where |
| who   |
| will  |
| with  |
| und   |
| the   |
| www   |
+———+

Does anyone can help me finding why "he" is excluded from search ?


Thanks,
Bernard

_______________________________________________
TikiWiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel