Table ‘XXX__blc_instances’ does not exist

Hello @rashamatt,

I trust you’re doing well!

Thank you for letting us know about this issue and sharing a fix with us. I’ve forwarded this to our developers.

Have a good day and take care!

Cheers,
Nastia

Good day!

1) yes, I also have this message:

[28-Dec-2019 17:02:29 UTC] WordPress database error Table ‘domdb.wp__blc_instances’ doesn’t exist for query SELECT instance_id FROM wp__blc_instances WHERE container_id = 12715 AND container_type = ‘post’ made by wp_trash_post, wp_update_post, wp_insert_post, wp_transition_post_status, do_action(‘trash_post’), WP_Hook->do_action, WP_Hook->apply_filters, blcPostTypeOverlord->post_deleted

2) and also I have many such messages:

[29-Dec-2019 18:29:15 UTC] PHP Deprecated: Function create_function() is deprecated in /var/www/sites/dom/html/wp-content/plugins/broken-link-checker/modules/checkers/http.php on line 147
[29-Dec-2019 20:27:05 UTC] PHP Deprecated: Function create_function() is deprecated in /var/www/sites/dom/html/wp-content/plugins/broken-link-checker/modules/checkers/http.php on line 147
[29-Dec-2019 20:27:07 UTC] PHP Deprecated: Function create_function() is deprecated in /var/www/sites/dom/html/wp-content/plugins/broken-link-checker/modules/checkers/http.php on line 147

I have last versions of WordPress and the plugin
ubuntu/nginx

• This reply was modified 4 years, 11 months ago by palansher.

I forgot to thank you for very useful plugin.

And want to suggest that maybe those errors also came from your code:

[17-Dec-2019 01:21:16 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_plugins, 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
[17-Dec-2019 01:21:16 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_plugins, 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
[17-Dec-2019 01:21:16 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 (‘avada_portfolio’, ‘user_request’, ‘customize_changeset’, ‘oembed_cache’, ‘slide’, ‘avada_faq’, ‘custom_css’, ‘wp_block’, ‘page’, ‘post’)
AND synch.container_id IS NULL made by activate_plugins, 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

Hi @rashamatt and @palansher,

We released new version couple of versions back and when I test it on my installation I couldn’t replicate any errors or notices in my debug log.
Can you update to latest version and see if it fixes it for you as well?

If not, could you give us some more information about your installations, like version the WP and PHP you are using, is it Apache or NGINX server, DB version, does it happen if other plugins are disabled, etc.

Cheers,
Predrag

Thank you!

In Plugin Version 1.11.10 now I see no new error messages in wp-content/debug.log

For any case the sysinfo is below. (sorry, no possibility to attach file)

Good luck!
Please keep going your valuable work!

Vladimir

### wp-core ###

version: 5.3.2
site_language: ru_RU
user_language: en_US
timezone: +03:00
permalink: /%postname%/
https_status: true
user_registration: 0
default_comment_status: closed
multisite: false
user_count: 9
dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /var/www/sites/dom/html
wordpress_size: 317.67 MB (333096161 bytes)
uploads_path: /var/www/sites/dom/html/wp-content/uploads
uploads_size: 783.34 MB (821392931 bytes)
themes_path: /var/www/sites/dom/html/wp-content/themes
themes_size: 50.67 MB (53129179 bytes)
plugins_path: /var/www/sites/dom/html/wp-content/plugins
plugins_size: 90.33 MB (94722569 bytes)
database_size: 56.19 MB (58916864 bytes)
total_size: 1.27 GB (1361257704 bytes)

### wp-active-theme ###

name: Avada Child (Avada-Child-Theme)
version: 1.0.0
author: ThemeFusion
author_website: https://theme-fusion.com
parent_theme: Avada (Avada)
theme_features: fusion-builder-options, title-tag, automatic-feed-links, custom-header, custom-background, woocommerce, wc-product-gallery-slider, wc-product-gallery-lightbox, post-formats, post-thumbnails, fusion-builder-demos, menus, align-wide, wp-block-styles, editor-styles, editor-font-sizes, widgets
theme_path: /var/www/sites/dom/html/wp-content/themes/Avada-Child-Theme

### wp-parent-theme ###

name: Avada (Avada)
version: 6.1.2
author: ThemeFusion
author_website: https://themeforest.net/user/ThemeFusion
theme_path: /var/www/sites/dom/html/wp-content/themes/Avada

### wp-themes-inactive (5) ###

Avada: version: 6.1.2, author: ThemeFusion
Twenty Nineteen: version: 1.4, author: the WordPress team
Twenty Seventeen: version: 2.2, author: the WordPress team
Twenty Sixteen: version: 2.0, author: the WordPress team
Twenty Twenty: version: 1.1, author: the WordPress team

### wp-plugins-active (22) ###

404page - your smart custom 404 error page: version: 11.2.0, author: Peter Raschendorfer
Autoptimize: version: 2.6.1, author: Frank Goossens (futtta)
Broken Link Checker: version: 1.11.10, author: ManageWP
Classic Editor: version: 1.5, author: WordPress Contributors
Contact Form 7: version: 5.1.6, author: Takayuki Miyoshi
Contact Form CFDB7: version: 1.2.4.8, author: Arshid
Crop Thumbnails: version: 1.2.6, author: Volkmar Kantor
Cyr-To-Lat: version: 4.3.2, author: Sergey Biryukov, Mikhail Kobzarev, Igor Gergel
Duplicate Post: version: 3.2.4, author: Enrico Battocchi
Fusion Builder: version: 2.1.2, author: ThemeFusion
Fusion Core: version: 4.1.2, author: ThemeFusion
Google Tag Manager for WordPress: version: 1.11.2, author: Thomas Geiger
Media Library Assistant: version: 2.81, author: David Lingren
Nginx Cache: version: 1.0.4, author: Till Krüss
Phoenix Media Rename: version: 1.3.4, author: crossi72
Post SMTP: version: 2.0.6, author: Yehuda Hassine
Redirection: version: 4.6.1, author: John Godley
Regenerate Thumbnails: version: 3.1.2, author: Alex Mills (Viper007Bond)
WebP Express: version: 0.17.2, author: Bj?rn Rosell
WP-Optimize - Clean, Compress, Cache: version: 3.0.15, author: David Anderson, Ruhani Rabin, Team Updraft
Yandex.Metrica Counter: version: 1.4.1, author: Alexander Semikashev
Yoast SEO: version: 12.7.1, author: Team Yoast

### wp-plugins-inactive (11) ###

Display Posts: version: 3.0.2, author: Bill Erickson
Font Awesome: version: 4.0.0-rc13, author: Font Awesome
GUI for List Category Posts: version: 1.0.1, author: Klemens Starybrat
List category posts: version: 0.81, author: Fernando Briano
Page-list: version: 5.2, author: webvitaly
Really Simple SSL: version: 3.2.7, author: Rogier Lankhorst, Mark Wolters
Redis Object Cache: version: 1.5.5, author: Till Krüss
Search & Replace: version: 3.2.1, author: Inpsyde GmbH
TinyMCE Advanced: version: 5.3.0, author: Andrew Ozz
What The File: version: 1.5.4, author: Never5
WP Migrate DB: version: 1.0.11, author: Delicious Brains

### wp-media ###

image_editor: WP_Image_Editor_GD
imagick_module_version: Not available
imagemagick_version: Not available
gd_version: 2.2.5
ghostscript_version: not available

### wp-server ###

server_architecture: Linux 4.15.0-72-generic x86_64
httpd_software: nginx/1.16.1
php_version: 7.3.12-1+ubuntu18.04.1+deb.sury.org+1 64bit
php_sapi: fpm-fcgi
max_input_variables: 5000
time_limit: 300
memory_limit: 512M
max_input_time: 300
upload_max_size: 256M
php_post_max_size: 256M
curl_version: 7.58.0 OpenSSL/1.1.1d
suhosin: false
imagick_availability: false

### wp-database ###

extension: mysqli
server_version: 8.0.18
client_version: mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $

### wp-constants ###

WP_HOME: undefined
WP_SITEURL: undefined
WP_CONTENT_DIR: /var/www/sites/dom/html/wp-content
WP_PLUGIN_DIR: /var/www/sites/dom/html/wp-content/plugins
WP_MAX_MEMORY_LIMIT: 512M
WP_DEBUG: false
WP_DEBUG_DISPLAY: false
WP_DEBUG_LOG: false
SCRIPT_DEBUG: true
WP_CACHE: false
CONCATENATE_SCRIPTS: undefined
COMPRESS_SCRIPTS: undefined
COMPRESS_CSS: undefined
WP_LOCAL_DEV: undefined
DB_CHARSET: utf8mb4
DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable
wp-content: writable
uploads: writable
plugins: writable
themes: writable
mu-plugins: writable