Support » Plugin: Broken Link Checker » database error – table doesn’t exist for query

  • Resolved Leopard-Lady

    (@leopard-lady)


    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 Adam – WPMU DEV Support

    (@wpmudev-support8)

    Hi @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/

    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

    (@leopard-lady)

    Hi Adam – @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

    (@leopard-lady)

    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 1 year, 5 months ago by Leopard-Lady.
    Plugin Support Pawel – WPMU DEV Support

    (@wpmudev-support9)

    Hello @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/

    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

    (@wpmudev-support6)

    Hello @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.