wordpress 插件Yet Another Related Posts Plugin 出错事件,及解决方法

Yet Another Related Posts Plugin启用后提示:
WordPress database error: [The used table type doesn’t support FULLTEXT indexes]
ALTER TABLE NZ_posts ADD FULLTEXT `yarpp_title` ( `post_title`)
WordPress database error: [The used table type doesn’t support FULLTEXT indexes]
ALTER TABLE NZ_posts ADD FULLTEXT `yarpp_content` ( `post_content`)
根据提示,查看了manual SQL setup,
YARPP’s “consider titles” and “consider bodies” relatedness criteria require your NZ_posts table to use the MyISAM storage engine, but the table seems to be using the InnoDB
engine. These two options have been disabled.
说是YARPP’s相关标准要求 nz_posts表 使用 myisam存储引擎,但现有的表使用的是 InnoDB存储引擎,因此选项被禁用了。
又给出解决方法,如果要恢复这些功能,请在您的 NZ_posts 表执行下列SQL指令:
ALTER TABLE `NZ_posts` ENGINE = MyISAM; 。
该操作将修改数据库,但不会损坏您的其它设置。
同意后 NZ_posts 将使用 MyISAM 引擎:
进phpMyAdmin操作了一下,还真是这样,按要求再运行下面的命令,创建两个相应的表。
数据库前缀,这是我的,在点击manual SQL setup后会自动跳转,可以看到
database prefix: Nz_
ALTER TABLE NZ_posts ADD FULLTEXT `yarpp_title` ( `post_title`)
ALTER TABLE NZ_posts ADD FULLTEXT `yarpp_content` ( `post_content`)
CREATE TABLE IF NOT EXISTS `NZ_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 `NZ_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;
Yet Another Related Posts Plugin是一个关联文章很不错的插件,但是使用起来有时并不那么通畅,推荐使用国产的一个插件:
无觅相关文章插件,操作简单,注册非常方便。
http://www.wumii.com/
11:51 2012-08-22

Tags: , , , ,

  • Digg
  • Del.icio.us
  • StumbleUpon
  • Reddit
  • Twitter
  • RSS

Leave a Reply

You must be logged in to post a comment.

文字链