Title: Database error after activation
Last modified: November 11, 2020

---

# Database error after activation

 *  Resolved [rperryscout](https://wordpress.org/support/users/rperryscout/)
 * (@rperryscout)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/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

Viewing 3 replies - 1 through 3 (of 3 total)

 *  [Epsiloncool](https://wordpress.org/support/users/epsiloncool/)
 * (@epsiloncool)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/database-error-after-activation/#post-13651067)
 * Hi [@rperryscout](https://wordpress.org/support/users/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.
    -  This reply was modified 5 years, 6 months ago by [Epsiloncool](https://wordpress.org/support/users/epsiloncool/).
    -  This reply was modified 5 years, 6 months ago by [Epsiloncool](https://wordpress.org/support/users/epsiloncool/).
 *  Plugin Author [Ajay](https://wordpress.org/support/users/ajay/)
 * (@ajay)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/database-error-after-activation/#post-13651201)
 * [@epsiloncool](https://wordpress.org/support/users/epsiloncool/)
    thank you for
   the response. That is indeed the solution!
 *  Thread Starter [rperryscout](https://wordpress.org/support/users/rperryscout/)
 * (@rperryscout)
 * [5 years, 6 months ago](https://wordpress.org/support/topic/database-error-after-activation/#post-13654782)
 * Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database error after activation’ is closed to new replies.

 * ![](https://ps.w.org/better-search/assets/icon-256x256.png?rev=2988729)
 * [Better Search - Relevant search results for WordPress](https://wordpress.org/plugins/better-search/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/better-search/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/better-search/)
 * [Active Topics](https://wordpress.org/support/plugin/better-search/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/better-search/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/better-search/reviews/)

## Tags

 * [Database Error](https://wordpress.org/support/topic-tag/database-error/)

 * 3 replies
 * 3 participants
 * Last reply from: [rperryscout](https://wordpress.org/support/users/rperryscout/)
 * Last activity: [5 years, 6 months ago](https://wordpress.org/support/topic/database-error-after-activation/#post-13654782)
 * Status: resolved