Canis Posted October 21 Posted October 21 Discovered this by coincidence, details in Access Information.
Marc Posted October 21 Posted October 21 This appears to be a good search. Please could you clarify what you mean there?
Canis Posted October 21 Author Posted October 21 Please see my added comment in the Access Information.
Marc Posted October 21 Posted October 21 Thats a stop word in mysql, so cannot be searched https://dev.mysql.com/doc/refman/8.4/en/fulltext-stopwords.html
Canis Posted October 21 Author Posted October 21 Thanks, but the word is a part of a stop word, not a stop word in it self.
Jim M Posted October 21 Posted October 21 3 minutes ago, Canis said: Thanks, but the word is a part of a stop word, not a stop word in it self. I'm afraid, it is a stop word when searched as what you're stating. This is a MySQL thing, not our software so you would need to handle it there if you wish to alter it.
Canis Posted October 21 Author Posted October 21 "in" is a stop word, but you can still search for "into".
Jim M Posted October 21 Posted October 21 Again, this is a MySQL thing, not an Invision thing. Into isn't a stopword but with is.
Canis Posted October 21 Author Posted October 21 (edited) Sorry, many thanks, I see it now. Have you considered displaying message if it's a stop word, "The word is to common" etc.? I know Xenforo does that. Edited October 21 by Canis
Canis Posted November 2 Author Posted November 2 Our forum is not in English so the stop-word list is irrelevant and leads to problems. Can we just delete it?
Jim M Posted November 2 Posted November 2 8 minutes ago, Canis said: Our forum is not in English so the stop-word list is irrelevant and leads to problems. Can we just delete it? This is a MySQL configuration item. As you are self-hosted you can do as you wish. However, we would not support this or any issues it may cause.
Canis Posted November 2 Author Posted November 2 Thanks, but as it directly influences on how our forum operates I think you could give an advice. How do you handle this for non-english cloud customers?
Jim M Posted November 2 Posted November 2 6 minutes ago, Canis said: How do you handle this for non-english cloud customers? We do not adapt our MySQL instances, nor do we recommend doing so. Therefore, we cannot advise on it.
Canis Posted November 2 Author Posted November 2 23 minutes ago, Jim M said: We do not adapt our MySQL instances So if we move to cloud we will have to use the standard english stop-word list?
Jim M Posted November 2 Posted November 2 14 minutes ago, Canis said: So if we move to cloud we will have to use the standard english stop-word list? Yes
Recommended Posts