WordPress database error: [Can't find FULLTEXT index matching the column list]
SELECT posts.*, CASE WHEN posts.post_title REGEXP 'fitness|program' THEN 1 ELSE 0 END AS keyword_in_title, MATCH ( posts.post_title, posts.post_content ) AGAINST ( 'fitness program' ) AS mysql_score FROM wp_posts as posts WHERE posts.post_date_gmt <= '2010-09-09 13:50:00' AND ( posts.post_password = '' ) AND ( ( post_status = 'publish' ) ) AND ( posts.post_title REGEXP 'fitness|program' OR posts.post_content REGEXP 'fitness|program' ) GROUP BY posts.ID ORDER BY keyword_in_title DESC, mysql_score DESC, posts.post_date DESC LIMIT 0, 3

• Login