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_deletedNow 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 problem was identified in three SQL statements in Version 1.11.8. Version 1.11.9 was released some time ago and this problem is still not fixed.
Please remove underscore character in front of blc_instances
broken-link-checker\includes\any-post.php
275 ‘SELECT instance_id FROM'.$wpdb->;prefix.'_blc_instancesWHERE container_id = %d AND container_type = %s’,
303 $q_current_link_ids = ‘SELECT DISTINCT link_id FROM'.$wpdb->prefix.'_blc_instancesWHERE instance_id IN (\”.implode(“‘, ‘”, $current_instance_ids).’\’)’;
317 $wpdb->;query( ‘DELETE FROM'.$wpdb->prefix.'_blc_instancesWHERE instance_id IN (\”.implode(“‘, ‘”, $current_instance_ids).’\’)’ );
- The topic ‘Extra underscore in SELECT statement’ is closed to new replies.
