Title: database error – table doesn’t exist for query Last modified: June 24, 2020 --- # database error – table doesn’t exist for query * Resolved [Leopard-Lady](https://wordpress.org/support/users/leopard-lady/) * (@leopard-lady) * [5 years, 11 months ago](https://wordpress.org/support/topic/database-error-table-doesnt-exist-for-query/) * Hi – While troubleshooting problems with other plugins, I noticed a recurring error in the logs for Broken Link Checker: * WordPress database error Table ‘xxxxxxxx_mike.wp__blc_instances’ doesn’t exist for query SELECT instance_id FROM `wp__blc_instances` WHERE container_id = 18818 AND container_type = ‘post’ 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 * The errors started on April 9 and recur twice a month since then. * Broken Link Checker does seem to be working properly. * Thank you, LL Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Support [Laura – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support8/) * (@wpmudev-support8) * [5 years, 11 months ago](https://wordpress.org/support/topic/database-error-table-doesnt-exist-for-query/#post-13036218) * Hi [@leopard-lady](https://wordpress.org/support/users/leopard-lady/) * I hope you’re well today! * It seems there are still some issues of that kind happening on some hosts. Our developers are looking into it. * Meanwhile, could you please try this: * 1) disable and delete the plugin 2) download 1.11.10 or 1.11.11 version from this page * [https://wordpress.org/plugins/broken-link-checker/advanced/](https://wordpress.org/plugins/broken-link-checker/advanced/) * 3) and then after installation and activation update the plugin again * Let us know if that solved the issue for you. * Best regards, Adam * Thread Starter [Leopard-Lady](https://wordpress.org/support/users/leopard-lady/) * (@leopard-lady) * [5 years, 11 months ago](https://wordpress.org/support/topic/database-error-table-doesnt-exist-for-query/#post-13040661) * Hi Adam – [@wpmudev-support8](https://wordpress.org/support/users/wpmudev-support8/) * Doin’ wonderful, thank you 🙂 Hope you are too! * I followed your instructions, using v1.11.10. * I’ll keep an eye on the logs and let you know if the error returns. * Thank you for your fast and friendly support – YOU ROCK 🙂 * Have a groovy good weekend, LL * Thread Starter [Leopard-Lady](https://wordpress.org/support/users/leopard-lady/) * (@leopard-lady) * [5 years, 11 months ago](https://wordpress.org/support/topic/database-error-table-doesnt-exist-for-query/#post-13043084) * UPDATE: After installing and updating v1.11.10 we have a slew of new errors. I’ve disabled the plugin for now. Here are the errors: * ``` [26-Jun-2020 01:48:57 UTC] PHP Warning: Error while sending QUERY packet. PID=31113 in /home/xxxxxxxxxxx/public_html/wp-includes/wp-db.php on line 2024 [26-Jun-2020 19:19:33 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query DELETE synch.* FROM wp_blc_synch AS synch LEFT JOIN wp_posts AS posts ON (synch.container_id = posts.ID and synch.container_type = posts.post_type) WHERE posts.post_status NOT IN ('publish') made by activate_plugin, do_action('activate_broken-link-checker/broken-link-checker.php'), WP_Hook->do_action, WP_Hook->apply_filters, blc_activation_hook, require('/plugins/broken-link-checker/includes/activation.php'), blcModuleManager->plugin_activated, blcModule->plugin_activated, blcContainerManager->activated, blcAnyPostContainerManager->resynch, blcPostTypeOverlord->resynch [26-Jun-2020 19:19:33 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query UPDATE wp_blc_synch AS synch JOIN wp_posts AS posts ON (synch.container_id = posts.ID and synch.container_type=posts.post_type) SET synched = 0 WHERE synch.last_synch < posts.post_modified made by activate_plugin, do_action('activate_broken-link-checker/broken-link-checker.php'), WP_Hook->do_action, WP_Hook->apply_filters, blc_activation_hook, require('/plugins/broken-link-checker/includes/activation.php'), blcModuleManager->plugin_activated, blcModule->plugin_activated, blcContainerManager->activated, blcAnyPostContainerManager->resynch, blcPostTypeOverlord->resynch [26-Jun-2020 19:19:33 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query INSERT INTO wp_blc_synch(container_id, container_type, synched) SELECT posts.id, posts.post_type, 0 FROM wp_posts AS posts LEFT JOIN wp_blc_synch AS synch ON (synch.container_id = posts.ID and synch.container_type=posts.post_type) WHERE posts.post_status IN ('publish') AND posts.post_type IN ('post', 'page') AND synch.container_id IS NULL made by activate_plugin, do_action('activate_broken-link-checker/broken-link-checker.php'), WP_Hook->do_action, WP_Hook->apply_filters, blc_activation_hook, require('/plugins/broken-link-checker/includes/activation.php'), blcModuleManager->plugin_activated, blcModule->plugin_activated, blcContainerManager->activated, blcAnyPostContainerManager->resynch, blcPostTypeOverlord->resynch [26-Jun-2020 19:20:35 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query UPDATE wp_blc_synch AS synch JOIN wp_posts AS posts ON (synch.container_id = posts.ID and synch.container_type=posts.post_type) SET synched = 0 WHERE synch.last_synch < posts.post_modified made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/broken-link-checker/broken-link-checker.php'), require('/plugins/broken-link-checker/core/init.php'), require('/plugins/broken-link-checker/includes/activation.php'), blcModuleManager->plugin_activated, blcModule->plugin_activated, blcContainerManager->activated, blcAnyPostContainerManager->resynch, blcPostTypeOverlord->resynch [26-Jun-2020 19:20:35 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=' for query INSERT INTO wp_blc_synch(container_id, container_type, synched) SELECT posts.id, posts.post_type, 0 FROM wp_posts AS posts LEFT JOIN wp_blc_synch AS synch ON (synch.container_id = posts.ID and synch.container_type=posts.post_type) WHERE posts.post_status IN ('publish') AND posts.post_type IN ('post', 'page') AND synch.container_id IS NULL made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), include_once('/plugins/broken-link-checker/broken-link-checker.php'), require('/plugins/broken-link-checker/core/init.php'), require('/plugins/broken-link-checker/includes/activation.php'), blcModuleManager->plugin_activated, blcModule->plugin_activated, blcContainerManager->activated, blcAnyPostContainerManager->resynch, blcPostTypeOverlord->resynch [27-Jun-2020 01:44:21 UTC] PHP Warning: Error while sending QUERY packet. PID=28757 in /home/xxxxxxxxxxx/public_html/wp-includes/wp-db.php on line 2024 ``` - This reply was modified 5 years, 11 months ago by [Leopard-Lady](https://wordpress.org/support/users/leopard-lady/). * Plugin Support [Imran – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support9/) * (@wpmudev-support9) * [5 years, 11 months ago](https://wordpress.org/support/topic/database-error-table-doesnt-exist-for-query/#post-13046460) * Hello [@leopard-lady](https://wordpress.org/support/users/leopard-lady/) * I trust you’re doing well * Please try the Database Collation Fix plugin, to fix these errors: [https://wordpress.org/plugins/database-collation-fix/](https://wordpress.org/plugins/database-collation-fix/) * Even though it is an old plugin it is still working on WordPress 5.4. * **Please make sure to have a full backup of your site before running this plugin.** * Let us know how it went! * Kind regards, Nastia * Plugin Support [Dimitris – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support6/) * (@wpmudev-support6) * [5 years, 8 months ago](https://wordpress.org/support/topic/database-error-table-doesnt-exist-for-query/#post-13394655) * Hello [@leopard-lady](https://wordpress.org/support/users/leopard-lady/) * I’m closing this topic due to recent inactivity. Feel free to post back any updates and we can reopen it and carry on. 🙂 * Take care, Dimitris Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘database error – table doesn’t exist for query’ is closed to new replies. * ![](https://ps.w.org/broken-link-checker/assets/icon-256x256.png?rev=2900468) * [Broken Link Checker](https://wordpress.org/plugins/broken-link-checker/) * [Frequently Asked Questions](https://wordpress.org/plugins/broken-link-checker/#faq) * [Support Threads](https://wordpress.org/support/plugin/broken-link-checker/) * [Active Topics](https://wordpress.org/support/plugin/broken-link-checker/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/broken-link-checker/unresolved/) * [Reviews](https://wordpress.org/support/plugin/broken-link-checker/reviews/) * 5 replies * 4 participants * Last reply from: [Dimitris – WPMU DEV Support](https://wordpress.org/support/users/wpmudev-support6/) * Last activity: [5 years, 8 months ago](https://wordpress.org/support/topic/database-error-table-doesnt-exist-for-query/#post-13394655) * Status: resolved