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

Yes, he is generally a pronoun in English, and sadly (according to lib/core/Search/ContentSource/FileSource.php:59) all files are indexed as language=unknown... can't think of an easy way round that - maybe have different galleries for the various langs?

Meanwhile, what is your ft_min_word_len there? I think it defaults to 4, so maybe you need to set that to 2 only? https://dba.stackexchange.com/a/40823

jonny




> On 21 Jul 2021, at 09:18, Bsfez Tiki via TikiWiki-devel <[email protected]> wrote:
> 
> 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
> 
> 
> 
> 
> <Screen Shot 2021-07-21 at 11.06.44 .png>
> 
> <Screen Shot 2021-07-21 at 10.52.28 .png><Screen Shot 2021-07-21 at 10.52.53 .png><Screen Shot 2021-07-21 at 10.53.02 .png><Screen Shot 2021-07-21 at 11.08.02 .png>
> 
> _______________________________________________
> TikiWiki-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel



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