WordPress database error: [Can’t find FULLTEXT index matching the column list]

  • When I write a new post and save I get the following errors multiple times (only a subset shown below):

    WordPress database error: [Can’t find FULLTEXT index matching the column list]
    SELECT MATCH(post_content, post_title) against (‘worldwide’) as score FROM wp_posts where id=216;
    WordPress database error: [Can’t find FULLTEXT index matching the column list]
    SELECT MATCH(post_content, post_title) against (‘success’) as score FROM wp_posts where id=216;
    WordPress database error: [Can’t find FULLTEXT index matching the column list]
    SELECT MATCH(post_content, post_title) against (‘discuss’) as score FROM wp_posts where id=216;
    WordPress database error: [Can’t find FULLTEXT index matching the column list]
    SELECT MATCH(post_content, post_title) against (‘variety’) as score FROM wp_posts where id=216;
    WordPress database error: [Can’t find FULLTEXT index matching the column list]
    SELECT MATCH(post_content, post_title) against (‘topics’) as score FROM wp_posts where id=216;

    The post actually saves OK.

    Recently the Manage Posts screen started showing only one post – the other posts disappeared and I can no longer edit them. The posts exist, the just don’t show in the Manage Posts screen.

    If soomeone can help me with this problems I’d appreciate it.

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

  • Try temporarily disabling all plugins and seeing if the problem goes away.

    Thread Starter David

    (@wwsuccess)

    iridiax,

    The problem with the Manage Posts screen was solved after I disabled some plugins. Thank you!

    I still get the following error though after saving a post:

    WordPress database error: [Can’t find FULLTEXT index matching the column list]
    SELECT MATCH(post_content, post_title) against (‘this’) as score FROM wp_posts where id=217;

    Should I try to recreate the FULLTEXT index using phpMyadmin? Is there any danger in doing that?

    Thanks,

    I’m not a database person, but the FULLTEXT etc. looks like plugin stuff to me, so I would not try to recreate it. Make sure that whatever plugin uses this is truly disabled and that you have removed any code for it in your posts or theme files.

    Are you using a related posts plugin or something similar?

    Thread Starter David

    (@wwsuccess)

    Yes, I am using the related posts plugin.

    Yes, I am using the related posts plugin.

    Then disable it and remove any added code for it.

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘WordPress database error: [Can’t find FULLTEXT index matching the column list]’ is closed to new replies.