[Plugin: Yet Another Related Posts Plugin] Random failures under 4.3.2

This is quite odd… YARPP should have tried to add that table if it does not exist. Perhaps the server user didn’t have the permissions to run CREATE TABLE in MySQL? This is usually not the case in most server setups.

You have two options: one is to manually create those tables (I can get you the definitions if necessary); the other is to not use tables for YARPP’s cache. You can do this by adding define('YARPP_CACHE_TYPE', 'postmeta'); to your wp-config file.

@mjg Here’s the code:

CREATE TABLE IF NOT EXISTS wp_yarpp_keyword_cache (
ID bigint(20) unsigned NOT NULL default ‘0’,
body text NOT NULL,
title text NOT NULL,
date timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (ID)
);
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 ),
INDEX (score), INDEX (ID)
);