PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

database errrors on upgrade - filters' doesn't exist / instances' doesn't exist

  1. Hello, This problem is happening on every site, every upgrade I do for the past few months. It's past being ridiculous and annoying and I'm concerned I could wind up with crashed databases or having to recreate some lengthy forms.

    When it happens the site then within about 24 hours "bloats" and I get over the limit hosting notifications and find the site is very near or over limit for it's size and there have been instances the site is then down because it's exceeded it's hosting limitations and I have to go in and reset their hosting plan to cure the problem.

    This is one example of the error on upgrading the plugin. I've replaced the actual site name and the table name for security reasons:
    ________________

    WordPress database error: [Table 'sitenamehere.wp_tablenamehere_blc_filters' doesn't exist]
    SHOW FULL COLUMNS FROM wp_tablenamehere_blc_filters;

    WordPress database error: [Table 'sitenamehere.wp_tablenamehere_blc_filters' doesn't exist]
    SHOW INDEX FROM wp_tablenamehere_blc_filters;

    WordPress database error: [Table 'sitenamehere.wp_tablenamehere_blc_instances' doesn't exist]
    SHOW FULL COLUMNS FROM wp_tablenamehere_blc_instances;

    WordPress database error: [Table 'sitenamehere.wp_tablenamehere_blc_instances' doesn't exist]
    _________________
    Help would be greatly appreciated. Thank you.
    Deb

    Posted 11 years ago on Sunday September 16, 2012 | Permalink
  2. I believe those _blc tables are from the Broken Link Checker plugin. Take a look in the code for the plugin on this page: http://plugins.svn.wordpress.org/broken-link-checker/trunk/core/core.php

    Search for "blc_instances" and you will see the tables are related to that plugin.

    Search this page for why this host bans "Broken Link Checker":
    http://support.wpengine.com/disallowed-plugins/

    My recommendation is to disable the Broken Link Checker. In any event, the errors are coming from that plugin, not Gravity Forms.

    Posted 11 years ago on Sunday September 16, 2012 | Permalink
  3. Thanks for this, very informative article! I'll disable/remove it and see if that cures the problem.

    Posted 11 years ago on Monday September 17, 2012 | Permalink
  4. Let us know if it does not.

    Posted 11 years ago on Monday September 17, 2012 | Permalink