Fixing fulltext errors in autometa plugin for WordPress

So if you’ve got the autometa plugin installed in your WordPress installation, and you’re getting error messages like:

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

whenever one of your posts autosaves, you need to execute the following sql command on your database, either via mysql on the commandline or by using phpMyAdmin or CocoaMySQL

alter table wp_posts add fulltext autometa (post_content, post_title)

At least I assume it’s the autometa plugin, as that’s the file that shows up when I grep around a bit for fulltext.

Leave a Reply

Your email address will not be published. Required fields are marked *