database error – table doesn’t exist for query

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, 9 months ago by Leopard-Lady.