WordPress.org

1. ESTetik
   Member
   Posted 11 months ago #

   Hallo,

   I have a problem withe the YARPP und "WP Super Cache" Plugin since I updated YARPP from v3.2 to v3.3.1.

   If these two plugins activated, my homepage on my blog does not loading if i logged in. I get an empty white page. The other sides (articles, pages, archives) work. If i am not logged in, there is no problem.

   If i deactivate YARPP, there is no problem. If i deactivate "WP Super Cache" an run YARPP there is no problem, too. The problem just appears, if i run YARPP and "WP Super Cache" together an i am logged in.

   Have anyone an idea, how to solve this problem?

   Thanks!

2. ESTetik
   Member
   Posted 11 months ago #

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

   Please help!

3. ESTetik
   Member
   Posted 11 months ago #

   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!

4. ESTetik
   Member
   Posted 11 months ago #

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

5. mitcho (Michael Yoshitaka Erlewine)
   Member
   Posted 11 months ago #

   @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?

6. ESTetik
   Member
   Posted 11 months ago #

   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!

7. onese7en
   Member
   Posted 11 months ago #

   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.

8. mitcho (Michael Yoshitaka Erlewine)
   Member
   Posted 10 months ago #

   @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?

9. dannoll
   Member
   Posted 9 months ago #

   @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

10. mitcho (Michael Yoshitaka Erlewine)
    Member
    Posted 7 months ago #

    @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?

11. dannoll
    Member
    Posted 7 months ago #

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

12. mitcho (Michael Yoshitaka Erlewine)
    Member
    Posted 7 months ago #

    Thanks @dannoll.

13. Iries
    Member
    Posted 4 months ago #

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

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

    @Iries I see you created another thread for this topic so I'll reply there.

Reply

You must log in to post.