YARPP SQL fix

Mar 1, 2009

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.)

database prefix:

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;