Yet Another Related Posts Plugin

Donate to mitcho (Michael Yoshitaka Erlewine) for this plugin via PayPal

by mitcho (Michael 芳貴 Erlewine) for WordPress.

< return to main documentation

Manual SQL setup

If you receive an error like "The YARPP database has an error which could not be fixed." after installing YARPP, it is likely that your database user doesn't have the proper permissions to make the necessary changes to your database. Edit the database prefix below and execute the following four SQL queries. (It is possible that the first two will return errors as they have already been executed correctly.)

ALTER TABLE posts ADD FULLTEXT `yarpp_title` ( `post_title`)
ALTER TABLE posts ADD FULLTEXT `yarpp_content` ( `post_content`)
CREATE TABLE IF NOT EXISTS `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 `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;
© 2006–2014 Michael Yoshitaka Erlewine