MySQL server has gone away

  • vwondra

    (@vwondra)


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

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

Viewing 1 replies (of 1 total)
  • mitcho (Michael Yoshitaka Erlewine)

    (@mitchoyoshitaka)

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

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL server has gone away’ is closed to new replies.