WordPress.org

Ready to get started?Download WordPress

Forums

Database error: Can't find FULLTEXT index matching... (8 posts)

  1. kcolvin1
    Member
    Posted 7 years ago #

    What does this mean:
    WordPress database error: [Can't find FULLTEXT index matching the column list]

    View this site: http://www.creative-assistant.com/blog

  2. MichaelH
    Member
    Posted 7 years ago #

    Sorry do not see the problem.

  3. kcolvin1
    Member
    Posted 7 years ago #

    If you go to my site:
    http://www.creative-assistant.com/blog
    click on one of the "read more" links to go to the full story.
    It's way at the bottom under "leave a reply" and next to "submit comment".
    Do you see it there?

  4. Brewskie
    Member
    Posted 7 years ago #

    I don't see a post for this either kcolvin1.

    My problem is at http://www.criticalreactor.com when you see a post at the bootom.

  5. Chad_Coleman
    Member
    Posted 7 years ago #

    Here is the full error that displays at the bottom of a single post.

    WordPress database error: [Can't find FULLTEXT index matching the column list]
    SELECT ID,post_title,post_content,post_excerpt,post_date, MATCH(post_title,post_content) AGAINST ('I’m Puzzled… Shhh, don’t tell her') AS score FROM wp_posts WHERE MATCH (post_title,post_content) AGAINST ('I’m Puzzled… Shhh, don’t tell her') and post_status = 'publish' and id <> 41 LIMIT 0,5

    You are using the related-post plugin. i'll post a fix it link in a second. lemme find it.

  6. Chad_Coleman
    Member
    Posted 7 years ago #

    K. Login to your admin and go to

    PLUGINS > RELATED POST OPTIONS

    Click the link "this script" under SQL Index Table Setup

  7. Brewskie
    Member
    Posted 7 years ago #

    Thanks for your reply Chad.

    I got this in a new window:

    "Sorry, you must be at least a level 8 user."

  8. Chad_Coleman
    Member
    Posted 7 years ago #

    better login as admin, or let the admin know.

Topic Closed

This topic has been closed to new replies.

About this Topic