Related Discussions

luceos

We talked about this on discord a bit and here's the conclusion;

Flarum can support Chinese search of less characters than three if you configure the database server to allow for that. This is not a limitation of Flarum, but a hard restriction of MySQL that cannot be modified per request. The value you need to update is ft_min_word_len, for reference you can look at https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html#fulltext-word-length.

meihuak

luceos I'm sorry I don't understand the code.
Should I continue to wait for your update, or should I apply for a refund?

luceos

meihuak if you have access to your own server and your MySQL configuration file you can apply the required changes yourself. Someone can potentially carry out these changes for you. If you're on a shared hosting environment or your don't have access to server level software, you sadly have no other options and can request a refund.

Refunds can also be carried out by the developer through their Stripe interface. Extiverse will automatically pick that up 👍️

meihuak

luceos I can try to contact my server technical service, how should I tell him what I want to do?

luceos

luceos Refunds can also be carried out by the developer through their Stripe interface. Extiverse will automatically pick that up 👍️

Justoverclock

meihuak you need to update is ft_min_word_len, for reference you can look at https://dev.mysql.com/doc/refman/8.0/en/fulltext-fine-tuning.html#fulltext-word-length.

meihuak

Justoverclock

ft_min_word_len deafults to a value of '4' and is not by default listed in "my.cnf". To change it's default value, add: "ft_min_word_len = 3" to my.cnf under the [mysqld] section.

Should I also do this?

add: "ft_min_word_len = 3" to my.cnf under the [mysqld] section.

Justoverclock

meihuak I think yes

meihuak

Justoverclock

i have added this code, and restart mysql, but it seems the extension still does not work

Justoverclock

meihuak

After changing any of these options, rebuild your FULLTEXT indexes for the change to take effect. For example, to make two-character words searchable, you could put the following lines in an option file:

[mysqld]
innodb_ft_min_token_size=2
ft_min_word_len=2

Then restart the server and rebuild your FULLTEXT indexes. For MyISAM tables, note the remarks regarding myisamchk in the instructions that follow for rebuilding MyISAM full-text indexes.

meihuak

Justoverclock

😭😭😭😭

luceos

meihuak have you restarted MySQL after making these changes?

meihuak

luceos yes, i login in my sever by ssh, then run this command service mysql restart

meihuak

if it does not work for me, May i apply to refund the money?

Zedd

Justoverclock its good, thanks for this feature sir 😃 😃

Zedd

Justoverclock btw, why it takes up a lot of server resources

Justoverclock

Zedd I’ll investigate, on Flarum.it I have 1vcpu and it works well

Zedd

4vcpu and 8gb ram

yes it works but sometimes it makes some errors and makes the load very slow/heavy

Justoverclock

Zedd post here the error that u get please

Zedd

Justoverclock hello, sorry for late reply
problem solved while clearing cache and optimizing my server

but new issue is problem with this extension (https://github.com/littlecxm/flarum-reply-to-see)
the extension requires "reply" to open it and the "Related Discussion" extension opens it when it's loaded or scrolls down and returns to the first post

meihuak

if it does not work for me, May i apply to refund the money?

Justoverclock

meihuak you can reach out Luceos for those questions 👍🏻

Justoverclock

meihuak tell me your Stripe Name so i can start the refund procedure

« Previous Page Next Page »