Title: FULTEXT query error
Last modified: August 20, 2016

---

# FULTEXT query error

 *  [Topher](https://wordpress.org/support/users/topher1kenobe/)
 * (@topher1kenobe)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/fultext-query-error/)
 * I’m getting lots of this in my error log:
 * WordPress database error
    Can’t find FULLTEXT index matching the column list 
   for query
 * and then it spits out the query created by the sql method in the YARPP_Cache 
   class.
 * It’s doing this on my live site, but not my dev site, which is running all the
   same stuff.
 * How would I deal with this?
 * [http://wordpress.org/extend/plugins/yet-another-related-posts-plugin/](http://wordpress.org/extend/plugins/yet-another-related-posts-plugin/)

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

 *  [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/)
 * (@mitchoyoshitaka)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/fultext-query-error/#post-3421882)
 * Most likely your `wp_posts` (or similar) table on your live site is not using
   the MyIsam storage engine, unlike your dev site.
 * If you go to the YARPP settings, it should give you an error about this.
 *  Thread Starter [Topher](https://wordpress.org/support/users/topher1kenobe/)
 * (@topher1kenobe)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/fultext-query-error/#post-3421890)
 * All of my WordPress tables are MyISAM, and I don’t have an error on the YARPP
   settings page.
 *  Thread Starter [Topher](https://wordpress.org/support/users/topher1kenobe/)
 * (@topher1kenobe)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/fultext-query-error/#post-3421903)
 * Any hope for this one?
 *  [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/)
 * (@mitchoyoshitaka)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/fultext-query-error/#post-3421911)
 * Can you check what indices are on your wp_posts table on your dev and live sites?
   There should be a YARPP-related fulltext index on both… seems like it’s missing
   on your live server for some reason.
 *  [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/)
 * (@mitchoyoshitaka)
 * [13 years, 3 months ago](https://wordpress.org/support/topic/fultext-query-error/#post-3421912)
 * Do your servers have the same MySQL version?

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

The topic ‘FULTEXT query error’ is closed to new replies.

 * ![](https://ps.w.org/yet-another-related-posts-plugin/assets/icon-256x256.png?
   rev=2549977)
 * [YARPP - Yet Another Related Posts Plugin](https://wordpress.org/plugins/yet-another-related-posts-plugin/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/yet-another-related-posts-plugin/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/yet-another-related-posts-plugin/)
 * [Active Topics](https://wordpress.org/support/plugin/yet-another-related-posts-plugin/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/yet-another-related-posts-plugin/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/yet-another-related-posts-plugin/reviews/)

## Tags

 * [fulltext](https://wordpress.org/support/topic-tag/fulltext/)
 * [query error](https://wordpress.org/support/topic-tag/query-error/)

 * 5 replies
 * 2 participants
 * Last reply from: [mitcho (Michael Yoshitaka Erlewine)](https://wordpress.org/support/users/mitchoyoshitaka/)
 * Last activity: [13 years, 3 months ago](https://wordpress.org/support/topic/fultext-query-error/#post-3421912)
 * Status: not resolved