YARPP & WP Super Cache

Note:
WP Super Cache Version 0.9.9.9
YARPP Version 3.3.1
WP Version 3.1.3

Please help!

Now i have deactivate and uninstall the “wp-super cache” plugin und install “W3 Total Cache” and i have same problem, too. But now all sites and pageas blank!!! Thanks for the perfekt support here!

No one here, who can help me to solve this YARPP problem?

@estetik, sorry to hear about this. Could you check the PHP error logs on your server to see if there are any errors being printed there when you get the white pages?

Hi Michael,

i dont know, how to check php errors on the server. i have tried everything an my summary is: wp-super-cache works excelently without yarpp and yarpp works excelently withot wp-super-cache.

if i activate wp-super-cache an let “caching off”, i become a white blank page on homepage, too. the problem appears just on the homepage.

before i updatet to the latest yarpp version both plugins works correctly. an if i now downgrade yarpp to the older version, i have the problem, too.

i dont knwo, what to do. please help!

I had the same issue with YARPP and W3 Total Cache; I would suggest that YARPP is the issue and recommend that until a more robust mechanism is in place that this be considered “only if absolutely necessary”. Happy to be proven wrong.

@estetik you can ask your hosting provider about where your server’s PHP logs are.

@onese7en could you check your PHP error logs as well to see if there’s anything printed there when you encounter this issue?

@mitcho: I’m not sure this is related, but I’m getting YARPP-related errors in my PHP error log when running YARPP and W3 Total Cache (W3TC). I have experienced this with W3 Total Cache database caching “enabled” but I seem to get a greater volume of errors when W3TC database caching is “disabled”.

Here are a couple of typical example entries (this happens with other post IDs).

[15-Aug-2011 07:27:22] WordPress database error MySQL server has gone away for query select count(*) as count from wp_yarpp_related_cache where reference_ID = 8511 made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->is_cached, W3_Db->query
[15-Aug-2011 07:27:22] WordPress database error MySQL server has gone away for query SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND wp_posts.ID = 8511 AND wp_posts.post_type = ‘post’ AND (wp_posts.post_status = ‘publish’) ORDER BY wp_posts.post_date DESC made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->cache_keywords, post_body_keywords, get_posts, WP_Query->query, WP_Query->get_posts, W3_Db->query
[15-Aug-2011 07:27:22] WordPress database error MySQL server has gone away for query select body from wp_yarpp_keyword_cache where ID = 8511 made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->update, yarpp_sql, YARPP_Cache_Tables->get_keywords, W3_Db->query
[15-Aug-2011 07:27:22] WordPress database error MySQL server has gone away for query select title from wp_yarpp_keyword_cache where ID = 8511 made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->update, yarpp_sql, YARPP_Cache_Tables->get_keywords, W3_Db->query

Would emptying the YARPP cache table help?

Is there a W3TC setup or cache and table emptying best practice that users of YARPP and caching plugins should employ?

My Setup:
Wordpress 3.0.4
YARPP: 3.3.2
W3 Total Cache: 0.9.2.3
Host: Hostgator

@dannoll something’s very odd about this. The query referred to there is a very simple and fast query, but the MySQL server is dying on it… you may want to contact your hosting and see if they have an idea.

Does the issue really disappear if you don’t use W3 Total Cache?

@mitcho: I’m rebuilding the site and will probably switch hosts. If the problem persists, I’ll let you know.

Thanks @dannoll.

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

The errors looks like: (W3 Total Cache running)

[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
from wp_posts
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 17492 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = ‘category’)
where (post_status IN ( ‘publish’, ‘static’ ) and ID != ‘17492’) and post_password =” and post_type = ‘post’
group by ID
having score >= 5.00 order by score desc limit 5) union (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
from wp_posts
left JOIN wp_term_relationships AS thiscat ON (thiscat.object_id = 17492 )
left JOIN wp_term_relationships AS catrel on (catrel.term_taxonomy_id = thiscat.term_taxonomy_id
AND catrel.object_id = wp_posts.ID)
left JOIN wp_term_taxonomy AS cattax ON ( catrel.term_taxonomy_id = cattax.term_taxonomy_id
AND cattax.taxonomy = ‘category’)
where (post_status IN ( ‘publish’, ‘static’ ) and ID != ‘17492’) and post_password =” and post_type = ‘page’
group by ID
having score >= 5.00 order by score desc limit 5) on duplicate key update date = now() made by require, require_once, include, related_posts, yarpp_related, yarpp_cache_enforce, YARPP_Cache_Tables->update, 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 SELECT SQL_CALC_FOUND_ROWS wp_posts.*, yarpp.score FROM wp_posts join wp_yarpp_related_cache as yarpp on wp_posts.ID = yarpp.ID WHERE 1=1 AND yarpp.score >= 5 and yarpp.reference_ID = 17492 AND wp_posts.post_type IN (‘post’) ORDER BY wp_posts.post_date DESC limit 5 made by require, require_once, include, related_posts, yarpp_related, WP_Query->query, WP_Query->get_posts, W3_Db->query

a lot of errors.

What can I do to avoid these errors?
Hope you reply, Thanks a lot.

@iries I see you created another thread for this topic so I’ll reply there.