Support » Plugin: Broken Link Checker – Find and Fix Dead Links » Extra underscore in SELECT statement

  • Version: 1.11.8

    In includes/any-post.php line 138, there is an extra underscore character that causes this error to be logged:
    [21-Mar-2019 12:33:23 UTC] WordPress database error Table 'i830414wp1.wp__blc_instances' doesn't exist for query SELECT instance_id FROM wp__blc_instances WHERE container_id = 27690 AND container_type = 'page' made by do_action_ref_array('wp_scheduled_auto_draft_delete'), WP_Hook->do_action, WP_Hook->apply_filters, wp_delete_auto_drafts, wp_delete_post, do_action('delete_post'), WP_Hook->do_action, WP_Hook->apply_filters, blcPostTypeOverlord->post_deleted

    Now Reads:

    			$q_current_instance_ids = $wpdb->prepare( 
    				'SELECT instance_id FROM <code>'.$wpdb->prefix.'_blc_instances</code> WHERE container_id = %d AND container_type = %s', 
    				$post_id,
    				$post_type );

    Should Read:

    			$q_current_instance_ids = $wpdb->prepare( 
    				'SELECT instance_id FROM <code>'.$wpdb->prefix.'blc_instances</code> WHERE container_id = %d AND container_type = %s', 
    				$post_id,
    				$post_type );
    • This topic was modified 8 months, 3 weeks ago by Mike Meinz.
Viewing 10 replies - 1 through 10 (of 10 total)
Viewing 10 replies - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.