Support » Fixing WordPress » Error – Can’t find FULLTEXT index matching the column list

  • Resolved muchablogaboutnothing

    (@muchablogaboutnothing)


    Anyone have any idea what i’ve done or havent done??

    the blog is at jeremysomers.com any help would be hugely appreciated!!!

    WordPress database error: [Can’t find FULLTEXT index matching the column list]
    SELECT ID, post_title, post_content,MATCH (post_name, post_content) AGAINST (‘featured post’) AS score FROM wp_posts WHERE MATCH (post_name, post_content) AGAINST (‘featured post’) AND post_date <= ‘2008-03-14 15:48:50’ AND (post_status IN ( ‘publish’, ‘static’ ) && ID != ‘8’) ORDER BY score DESC LIMIT 0,3

Viewing 1 replies (of 1 total)
  • WP doesn’t use Fulltext indexes on searches. It’s either a plugin causing it, or a change to the core search functionality. If it’s a plugin, I would check the installation routine and make sure the indexes were defined, or it could be something you have to do manually. Check the readme file.

Viewing 1 replies (of 1 total)
  • The topic ‘Error – Can’t find FULLTEXT index matching the column list’ is closed to new replies.