24 9 月

安裝 Mattermost 後使用Mysql 5.7 搜尋中文搜尋不到的解決方法

IT人生

0  comments

使用MySQL 5.7卻造成Mattermost無法搜尋中文的問題,用下列的重建索引解決方法:

mysql> use mattermost;
Database changed
mysql> DROP INDEX idx_posts_message_txt ON Posts;
Query OK, 0 rows affected (4.71 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> CREATE FULLTEXT INDEX idx_posts_message_txt ON Posts (Message) WITH PARSER ngram;
Query OK, 0 rows affected (16.40 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql>

About the author 

Jason Huang

從事留學遊學策略規劃工作多年的教育觀察者, 對學習永遠抱持熱忱,

You may also like

紀錄一下第一次學習Flask並Deploy到Heroku遇到的坑

MySQL won’t start – error: su: warning: cannot change directory to /nonexistent: No such file or directory

Docker中配置MySQL的錯誤訊息

Leave a Reply

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Subscribe to our newsletter now!