My YARPP Related Cache got deleted

I recently had a bit of a hiccup concerning my local development setup, and I lost some of the database information.

Unfortunately, the YARPP Related Cache info was part of what I lost. My issue is that I had already installed YARPP and converted my posts table to MyISAM (sp?) format successfully and created the post title and body content cache for the plugin to use. After losing the DB info, my WP install did not remember that YARPP was activated so I reactivated it but now I can’t find a way (since my posts table is already MyISAM) to re-create the cache info in the database.

I’m hoping I’m just missing something and that this is a simple fix. I have the WP Debug bar installed and it lit up when I went to a single post. Here is what it spit out:

select max(ID) as max_id from sb_yarpp_related_cache where reference_ID = 5718
Table 'rmg2014_local.sb_yarpp_related_cache' doesn't exist
select distinct ID from sb_yarpp_related_cache where reference_ID = 5718 and ID != 0
Table 'rmg2014_local.sb_yarpp_related_cache' doesn't exist
insert into sb_yarpp_related_cache (reference_ID,ID,score) (SELECT 5718 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('facebook world advertisers cup targeting tv cluster event fans fifa social real platform audience reach measure segment performance updated soccer')) * 3 + (MATCH (post_title) AGAINST ('world cup fifa eye launch targeting facebook')) * 1 + count(distinct if( terms.term_taxonomy_id in (8), terms.term_taxonomy_id, null )) * 3 + (1 = 0) * 1,1) as score
from sb_posts
left join sb_term_relationships as terms on ( terms.object_id = sb_posts.ID )
where post_status in ( 'publish', 'static' ) and ID != '5718' and post_password ='' and post_type = 'post'
group by ID
having score >= 4.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (1)) = 0 order by score desc limit 3) union (SELECT 5718 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('facebook world advertisers cup targeting tv cluster event fans fifa social real platform audience reach measure segment performance updated soccer')) * 3 + (MATCH (post_title) AGAINST ('world cup fifa eye launch targeting facebook')) * 1 + count(distinct if( terms.term_taxonomy_id in (8), terms.term_taxonomy_id, null )) * 3 + (1 = 0) * 1,1) as score
from sb_posts
left join sb_term_relationships as terms on ( terms.object_id = sb_posts.ID )
where post_status in ( 'publish', 'static' ) and ID != '5718' and post_password ='' and post_type = 'page'
group by ID
having score >= 4.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (1)) = 0 order by score desc limit 3) union (SELECT 5718 as reference_ID, ID, ROUND(0 + (MATCH (post_content) AGAINST ('facebook world advertisers cup targeting tv cluster event fans fifa social real platform audience reach measure segment performance updated soccer')) * 3 + (MATCH (post_title) AGAINST ('world cup fifa eye launch targeting facebook')) * 1 + count(distinct if( terms.term_taxonomy_id in (8), terms.term_taxonomy_id, null )) * 3 + (1 = 0) * 1,1) as score
from sb_posts
left join sb_term_relationships as terms on ( terms.object_id = sb_posts.ID )
where post_status in ( 'publish', 'static' ) and ID != '5718' and post_password ='' and post_type = 'attachment'
group by ID
having score >= 4.00 and ID != 0 and bit_or(terms.term_taxonomy_id in (1)) = 0 order by score desc limit 3) on duplicate key update date = now()
Table 'rmg2014_local.sb_yarpp_related_cache' doesn't exist
insert into sb_yarpp_related_cache (reference_ID,ID,score) values (5718,0,0) on duplicate key update date = now()
Table 'rmg2014_local.sb_yarpp_related_cache' doesn't exist

Please let me know what I should do to recover from this. As I said above, it is a local development environment so I can;t post a link to show you. I am comfortable going into phpmyadmin and manually inserting some stuff as long as I have clear instructions of how to do so. If this is a repeat post here on the forum, I appologize, but please point me to where the fix is discussed (there are so many pages on this thread!).

Cheers

– Mike

https://wordpress.org/plugins/yet-another-related-posts-plugin/