The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

Yet Another Related Posts Plugin (YARPP)
MySQL server has gone away (2 posts)

  1. vwondra
    Posted 3 years ago #

    I'm having problems with YARPP on RabidBi (dot) com

    Several times a day my site is timing out. The error logs points back to the YARPP:

    [15-Apr-2013 18:35:45 UTC] WordPress database error MySQL server has gone away for query 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)
    ) DEFAULT CHARACTER SET utf8; made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), call_user_func_array, yarpp_init, YARPP->__construct, YARPP->enforce, YARPP->activate, YARPP_Cache_Tables->setup, W3_Db->query, W3_DbCache->query, W3_DbCallUnderlying->query, W3_Db->query, W3_DbProcessor->query, W3_Db->default_query

    I already have YARPP Experiments installed. You can view a screenshot of it's settings here: http://www.bootstrapbusinesssolutions.com/wp-content/uploads/2013/04/YARPP-Experiments-settings.png.

    Any suggestions outside of disabling the plugin?


  2. mitcho (Michael Yoshitaka Erlewine)
    Plugin Author

    Posted 3 years ago #

    Sorry to hear about this. It looks from that error like YARPP has not been able to complete its installation. Is it always that "CREATE TABLE IF NOT EXISTS" line that you see in the error logs? If so, it might be a weird issue where your php (apache) doesn't have the right permissions to create a table in the database.

    If you have access to your mysql directly, you can just run that one CREATE TABLE command yourself directly, or verify that the table wp_yarpp_related_cache has actually been created.

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Yet Another Related Posts Plugin (YARPP)
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic