I got few days ago problem in MySQL :
The used table type doesn’t support FULLTEXT indexes
I had problem with Yet Another Related plugin for WordPress and I was getting “No related posts” for every post.
I tried to manually install MySQL code :
database prefix:
ALTER TABLE wp_posts ADD FULLTEXT `yarpp_title` ( `post_title`)
ALTER TABLE wp_posts ADD FULLTEXT `yarpp_content` ( `post_content`)
CREATE TABLE IF NOT EXISTS `wp_yarpp_keyword_cache` (
`ID` bigint(20) unsigned NOT NULL default ’0′,
`body` text collate utf8_unicode_ci NOT NULL,
`title` text collate utf8_unicode_ci NOT NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
COMMENT=’YARPP”s keyword cache table’;
CREATE TABLE IF NOT EXISTS `wp_yarpp_related_cache` (
`reference_ID` bigint(20) unsigned NOT NULL default ’0′,
`ID` bigint(20) unsigned NOT NULL default ’0′,
`score` float unsigned NOT NULL default ’0′,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`reference_ID`,`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
And I didn’t success.
Where was the trick ?
You need to use :
ALTER TABLE wp_posts ENGINE = MYISAM;
Enjoy and use YARP !!!
At our website we had several jobs which include OMNeT and Network simulation. Many freelancers didn’t know nothing about that so we created one article for freelancers – to learn more about this.