WordPress.org

1. Iries
   Member
   Posted 4 months ago #

   Even though the YARPP has been removed from my wordpress site, I'm still receiving YARPP errors in the error logs.

   YARPP had been removed from site for a long time (Almost 1 year ago), but now I'm still receiving YARPP errors.

   WordPress 3.2.1 with W3 Total Cache 0.9.2.3

   Show some error logs:

   [20-Jan-2012 00:43:20] WordPress database error Unknown table engine 'InnoDB' for query select count(*) as count from wp_yarpp_related_cache where reference_ID = 4452 made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->is_cached, W3_Db->query
   [20-Jan-2012 00:43:20] WordPress database error Unknown table engine 'InnoDB' for query select distinct ID from wp_yarpp_related_cache where reference_ID = 4452 and ID != 0 made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->update, YARPP_Cache_Tables->related, W3_Db->query
   [20-Jan-2012 00:43:20] WordPress database error Unknown table engine 'InnoDB' for query delete from wp_yarpp_related_cache where reference_ID = 4452 made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->update, YARPP_Cache_Tables->clear, W3_Db->query
   [20-Jan-2012 00:43:20] WordPress database error Unknown table engine 'InnoDB' for query insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 4452 as reference_ID, ID, ROUND(0+ (MATCH (post_content) AGAINST ('detroit building abandoned once its grand city years book monument lost photos check story artists news austin buildings theres school ')) * 1+ (MATCH (post_title) AGAINST ('tour photo buildings abandoned detroits ')) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1,1) as score
   from wp_posts

   [20-Jan-2012 00:55:33] WordPress database error Unknown table engine 'InnoDB' for query select count(*) as count from wp_yarpp_related_cache where reference_ID = 17492 made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->is_cached, W3_Db->query
   [20-Jan-2012 00:55:33] WordPress database error Unknown table engine 'InnoDB' for query select distinct ID from wp_yarpp_related_cache where reference_ID = 17492 and ID != 0 made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->update, YARPP_Cache_Tables->related, W3_Db->query
   [20-Jan-2012 00:55:33] WordPress database error Unknown table engine 'InnoDB' for query delete from wp_yarpp_related_cache where reference_ID = 17492 made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->update, YARPP_Cache_Tables->clear, W3_Db->query
   [20-Jan-2012 00:55:33] WordPress database error Unknown table engine 'InnoDB' for query insert into wp_yarpp_related_cache (reference_ID,ID,score) (SELECT 17492 as reference_ID, ID, ROUND(0+ (MATCH (post_content) AGAINST ('his movie underdog team its rocky him sports against ever group win oh roy hockey bowling dave hand rudy kong ')) * 1+ (MATCH (post_title) AGAINST ('movies ever br sports greatest underdog 11 ')) * 1+ COUNT( DISTINCT cattax.term_taxonomy_id ) * 1,1) as score

   What is causing the errors to appear and how I can fix it?

   Thaks.

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

2. mitcho (Michael Yoshitaka Erlewine)
   Member
   Posted 3 months ago #

   @Iries the errors here aren't because of the queries YARPP is producing, but instead is an issue with your MySQL installation. I suggest you search online for "Unknown table engine 'InnoDB'" for possible solutions... otherwise, I suggest you go through your tables and make sure they're all using the MyISAM table engine instead of InnoDB, as your MySQL apparently doesn't recognize (or stopped recognizing) InnoDB.

Reply

You must log in to post.