Database error after activation
-
I installed and activated Better Search without any problems. I even managed to do a basic search without issue. However, I fiddled with some settings and started getting an error, and now the search doesn’t work at all. I reset everything back to default but the error and disfunction are still present.
Here is the text from the error:
WordPress database error: [The used table type doesn’t support FULLTEXT indexes]
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_posts.ID as ID, (MATCH(wp_posts.post_title) AGAINST (‘chat’ ) * 10 ) + (MATCH(wp_posts.post_content) AGAINST (‘chat’ ) * 1 ) AS score FROM wp_posts WHERE 1=1 AND MATCH (wp_posts.post_title,wp_posts.post_content) AGAINST (‘chat’ ) AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘inherit’) AND wp_posts.post_type IN (‘post’, ‘page’) ORDER BY score DESC LIMIT 0, 10
-
Hi @rperryscout
I am not an author of the plugin (I am the author of another search-related plugin), however, I know the reason for this type of error.
The FULLTEXT indexes are only supported in MyISAM data tables (prior to MySQL 5.6), so it looks like you occasionally converted your wp_posts table to InnoDB type, that does not support FULLTEXT search by your MySQL server version.
I would recommend either change your wp_posts table type to MyISAM or (better) to upgrade your MySQL server to version 8.0 or at least 5.6.
This should fix the issue.
The topic ‘Database error after activation’ is closed to new replies.
