Plugin List not returning some results (stopword)
- Status
- Closed
- Subject
- Plugin List not returning some results (stopword)
- Version
- 21.x
- Category
- Bug
- Regression
- Feature
- Trackers
Wiki Plugin (extends basic syntax) - Resolution status
- Won't Fix
- Submitted by
- Bernard Sfez / Tiki Specialist
- Lastmod by
- Bernard Sfez / Tiki Specialist
- Rating
- Description
On Tiki 21.x not all items are displayed using list or customsearch with filter.
In the instance I created items that are filtered "May" are not found when filtering for it.
(the field that contain "May" is a mathematical field that extract the month from the date of the item)
It was working fine but after updating the Tiki 21.x it showed up.My best guess is that it is because of the word length. (I experiment changing different fields and see what work and what doesn’t).
I know there is a php search limit for 3 char (ft_min_word_len=3) that too I experimented to see if it move something. But changing my.cnf settings and restarting innoDB didn’t help.
I tested on my local mamp, my clearOs server and in show instance. They show the same issue (so I believe it comes from Tiki and not some server settings)
I change the value of the min word length as explained at : https://dev.mysql.com/doc/refman/5.6/en/fulltext-fine-tuning.html#fulltext-word-length
(I did for both innoDB and MySIAM)Changes were applied after a restart as Tiki check confirmed:
I checked I have in my index existing values for May
I tested with May and June and the plugin list debug tool:
Same item filter (and field) was changed to "May2020" and it worked fine.
Still this is not a solution to hardcode the year with the month (all templates should be edited each year and they may be other implications).- Workaround
- It was due to the MySQL search stopword list: https://dev.mysql.com/doc/refman/5.7/en/fulltext-stopwords.html
- Importance
- 5
- Easy to solve?
- 5
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 7373
- Created
- Sunday 17 May, 2020 18:37:03 UTC
by Bernard Sfez / Tiki Specialist - LastModif
- Saturday 23 May, 2020 06:07:08 UTC