Rainer Feike techblog

When I tried to install WASABI’s nice related entries plugin on my new Wordpress site geekland it failed with the following error:

#1214 - The used table type doesn’t support FULLTEXT indexes

I am not sure if this is WP2.2 related - in the schema creation source I found no difference to 2.1 in the posts table - but I never had that problem with 2.1.

The solution is to convert the wp_posts table to ISAM (MyISAM) by issuing

ALTER TABLE `wp_posts` ENGINE = MYISAM

and after that re-issue the installation script of WASABI what does not more than:

alter table wp_posts add fulltext post_related (post_name, post_content)

Well, on my development system, the WP2.2 database was created in InnoDB format. and InnoDB does not support fulltext-search columns.
That’s all.

This entry was posted on Wednesday, July 18th, 2007 at 1:31 pm and is filed under programming. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.