WordPress.org

Ready to get started?Download WordPress

Forums

Yet Another Related Posts Plugin (YARPP)
FULTEXT query error (6 posts)

  1. Topher
    Member
    Posted 1 year ago #

    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/

  2. mitcho (Michael Yoshitaka Erlewine)
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  3. Topher
    Member
    Posted 1 year ago #

    All of my WordPress tables are MyISAM, and I don't have an error on the YARPP settings page.

  4. Topher
    Member
    Posted 1 year ago #

    Any hope for this one?

  5. mitcho (Michael Yoshitaka Erlewine)
    Member
    Plugin Author

    Posted 1 year ago #

    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.

  6. mitcho (Michael Yoshitaka Erlewine)
    Member
    Plugin Author

    Posted 1 year ago #

    Do your servers have the same MySQL version?

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic