error on table wp__blc_instances

  • ulula

    (@ulula)


    6 years, 9 months ago

    I noticed this error on my debug log:

    WordPress database error Table 'dbname.wp__blc_instances' doesn't exist for query SELECT instance_id FROMwp__blc_instancesWHERE container_id = xxx AND container_type = 'post' made by do_action_ref_array('wp_scheduled_auto_draft_delete'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, wp_delete_auto_drafts, wp_delete_post, do_action('delete_post'), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, blcPostTypeOverlord->post_deleted

    I don’t know if my case is as isolate as unlucky, but I fixed it: the error is just a typo, in fact you will notice that wp__blc_instances has 2 underscores. I just removed the extra underscore and I’m no longer receiving errors.

    You can find the typo in file: broken-link-checker/includes/any-post-php line 138:
    original string:
    'SELECT instance_id FROM‘.$wpdb->prefix.’_blc_instancesWHERE container_id = %d AND container_type = %s',

    corrected string:
    'SELECT instance_id FROM‘.$wpdb->prefix.’blc_instancesWHERE container_id = %d AND container_type = %s',

    Hope it helps for future releases.

    • This topic was modified 6 years, 9 months ago by ulula.
Viewing 2 replies - 1 through 2 (of 2 total)
  • cdgweb

    (@cdgweb)

    6 years, 9 months ago

    Related problem. It’s interfering with deleting posts.

    developernikolai

    (@developernikolai)

    6 years, 9 months ago

    I second that. Also have this problem when deleting a post. In fact, this typo happens not only on line 138, as @ulula noted:
    ‘SELECT instance_id FROM '.$wpdb->prefix.'_blc_instances WHERE container_id = %d AND container_type = %s

    It also happens on line 152:
    $q_current_link_ids = ‘SELECT DISTINCT link_id FROM '.$wpdb->prefix.'_blc_instances WHERE instance_id IN (\”.implode(“‘, ‘”, $current_instance_ids).’\’)’;

    And also on line 159:
    $wpdb->query( ‘DELETE FROM '.$wpdb->prefix.'_blc_instances WHERE instance_id IN (\”.implode(“‘, ‘”, $current_instance_ids).’\’)’ );

    In all those cases the first underscore in ‘_blc_instances’ should be removed.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘error on table wp__blc_instances’ is closed to new replies.