We've converted all tables of forum's DB into InnoDB format as suggested by AdminCenter.
Just then the system log began collecting the errors in search query "IPS\Db\Exception: syntax error, unexpected $end, expecting FTS_TERM or FTS_NUMB or '*' (1064)"
The query itself is in the following format:
SELECT *, (( MATCH(index_title) AGAINST ('*some_word* *' IN BOOLEAN MODE)<... and so on...>
We believe the forum core generates it while this is coming from data input when the user is asking something like to "see everything", but for InnoDB AGAINST('*' ...) is not valid. Fulltext expects to see some_word(s), not a lone wildcard '*' (nor separately).
Would it be fixed (or tell us, please, how can we do it) or we are better to fall back to MyISAM table?
Invision Community v4.7.5, PHP 8.0.26, Percona Server for MySQL 5.7.40-43