• Type: Improvement
• Resolution: Fixed
• Fix Version/s: translate5 - 5.5.1
• Affects Version/s: None
• Component/s: TermPortal

[TRANSLATE-2645] TermPortal: set mysql fulltext search minimum word length to 1 and disable stop words

Marc Mittag [Administrator] made changes - 23/Apr/2024 05:09

Start Date [Gantt]

New: 23/Apr/24 5:00 AM

Aleksandar Mitrev made changes - 12/May/2023 01:04

Status

Original: Final pull request made [ 10005 ]

New: Done [ 10000 ]

Marc Mittag [Administrator] made changes - 24/Apr/2023 05:17

Workflow

Original: MittagQI Workflow [ 31631 ]

New: MittagQI Workflow with Peer [ 36601 ]

Thomas Lauria made changes - 05/Oct/2021 07:24

Resolution		New: Fixed [ 1 ]
Status	Original: In Progress [ 3 ]	New: Test Ready [ 10005 ]

Thomas Lauria made changes - 05/Oct/2021 07:24

Status

Original: Selected for Development [ 10100 ]

New: In Progress [ 3 ]

Thomas Lauria made changes - 05/Oct/2021 07:23

ChangeLog Description	Original: Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please contact us, how to do this. Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.	New: Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please call "./translate5.sh termportal:reindex" or contact us, how to do this. Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.
Important release notes	Original: Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please contact us, how to do this. Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.	New: Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please call "./translate5.sh termportal:reindex" or contact us, how to do this. Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.

Thomas Lauria made changes - 05/Oct/2021 07:20

Summary

Original: TermPortal: set mysql fullext search minimum word length to 1

New: TermPortal: set mysql fulltext search minimum word length to 1 and disable stop words

Thomas Lauria made changes - 05/Oct/2021 06:25

ChangeLog Description		New: Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please contact us, how to do this. Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.
Fix Version/s		New: translate5 - 5.5.1 [ 11900 ]
Important release notes	Original: Please set ft_min_word_len in your mysql installation to 1. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change ft_min_word_len in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please contact us, how to do this.	New: Please set innodb_ft_min_token_size in your mysql installation to 1 and innodb_ft_enable_stopword to 0. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change that settings in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please contact us, how to do this. Please run "./translate5.sh system:check" to check afterwards if everything is properly configured.

Thomas Lauria made changes - 04/Oct/2021 08:26

Description

Original: The default for the minimum word length for mysql fulltext search is 3. Parameter ft_min_word_len. For TermPortal we need every word to be found, regardless of its length. Therefore this needs to be set to 1. Since this can only be done in mysql configuration, we need to change that on our server, add it to the installation instructions for translate5 and send it to the admins of self-hosted installations for information.

New: Regarding the fulltext index for the term attributes there are two todos: h1.Disable the minimum word length The default for the minimum word length for mysql fulltext search is 3. Parameter ft_min_word_len. For TermPortal we need every word to be found, regardless of its length. Therefore this needs to be set to 1. Since this can only be done in mysql configuration, we need to change that on our server, add it to the installation instructions for translate5 and send it to the admins of self-hosted installations for information. h1.disable stopword list Make research what is possible / what must be done (DB root rights / ordinary user etc) depending on that make an alter script or place instructions into the important release notes h1.make a DB system requirements check which checks both above settings if applied

Marc Mittag [Administrator] made changes - 04/Oct/2021 07:53

Important release notes

Original: Please set ft_min_word_len in your mysql installation to 1. This is necessary for TermPortal to find words shorter than 3 characters.

New: Please set ft_min_word_len in your mysql installation to 1. This is necessary for TermPortal to find words shorter than 3 characters. If you did already install translate5 5.5.0 on your server OR if you did install translate 5.5.1 BEFORE you did change ft_min_word_len in your mysql installation, then you would need to update the fulltext indexes of your DB term-tables manually. If this is the case, please contact us, how to do this.

Load more older history items