SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index

ash3T

Well, yes, it is me again. 😅

I get the following error

GET http://forum.website.org/api/discussions

PDOException: SQLSTATE[HY000]: General error: 1191 Can't find FULLTEXT index matching the column list in /home/vol19_1/website.org/databasename/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:79
Stack trace:
#0 /home/vol19_1/website.org/databasename/htdocs/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php(79): PDO->prepare('select `discuss...', Array)
#1 /home/vol19_1/website.org/databasename/htdocs/vendor/illuminate/database/Connection.php(352): Doctrine\DBAL\Driver\PDOConnection->prepare('select `discuss...')

For the full error message please see https://docs.google.com/document/d/1p4ThFNFps3cA-lHTS0NxyD_07i-WXaSwkiOuCzRwrgg/edit?usp=sharing

I have searched both in flarum and on google, cannot find a solution.

clarkwinkelmann

ash3T what's your database server (MySQL, MariaDB) and version?

Did it work previously or did the error start right after you installed Flarum?

ash3T

clarkwinkelmann Thanks for your help.

On my server it says, mysqlnd 7.4.8. It this make sense?

Yes, it worked previously. I just did the composer update yesterday. This error message comes up, when I tried to do a search in the forum.