I use the amazing AskApache google-404 plugin on this blog. (It makes my 404 page really helpful – take a look) Recently, I noticed a bunch of mysql errors in my error.log, like this:

[sourcecode language=sql]
WordPress database error Can’t find FULLTEXT index matching the column list for query SELECT ID, post_title, post_content,MATCH (post_name, post_content) AGAINST (‘feed funkypenguin’) AS score FROM wp_posts WHERE MATCH (post_name, post_content) AGAINST (‘feed funkypenguin’) AND post_date <= '2008-08-05 14:36:14' AND (post_status IN ( 'publish', 'static' )) AND post_password ='' ORDER BY score DESC LIMIT 6 made by aa_related_posts_404
[/sourcecode]

This was happening because there WAS no fulltext index on those two columns. I may have mucked them up with another plugin, or possibly they were never there. Regardless, running the following SQL query created the index, and now the errors are gone

[sourcecode language=sql]
ALTER TABLE `wp_posts` ADD FULLTEXT (
`post_name` ,
`post_content`
)
[/sourcecode]

No related posts.