WordPress database error Illegal mix of collations

Actually, I’m seeing quite a few database errors. The one above, plus:

[STDERR] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 1 for query SELECT COUNT(1) FROM wp_blc_linkdata,; made by do_action(‘wp_ajax_delete-plugin’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_delete_plugin, delete_plugins, uninstall_plugin, include_once(‘/plugins/broken-link-checker/uninstall.php’), apply_filters(‘query’), WP_Hook->apply_filters, WSAL_Sensors_Database->EventDropQuery, WSAL_Sensors_Database->check_if_table_exists

[STDERR] WordPress database error Table ‘ks_demo.wp_blc_filters’ doesn’t exist for query SELECT COUNT(1) FROM wp_blc_filters; made by activate_plugin, 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’), blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta, apply_filters(‘query’), WP_Hook->apply_filters, WSAL_Sensors_Database->EventDropQuery, WSAL_Sensors_Database->check_if_table_exists

[STDERR] WordPress database error Table ‘ks_demo.wp_blc_instances’ doesn’t exist for query SELECT COUNT(1) FROM wp_blc_instances; made by activate_plugin, 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’), blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta, apply_filters(‘query’), WP_Hook->apply_filters, WSAL_Sensors_Database->EventDropQuery, WSAL_Sensors_Database->check_if_table_exists

[STDERR] WordPress database error Table ‘ks_demo.wp_blc_links’ doesn’t exist for query SELECT COUNT(1) FROM wp_blc_links; made by activate_plugin, 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’), blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta, apply_filters(‘query’), WP_Hook->apply_filters, WSAL_Sensors_Database->EventDropQuery, WSAL_Sensors_Database->check_if_table_exists

This happens after deactivating, uninstalling, and reinstalling twice.

Thanks for coming back to me.

I tried a version of this earlier this morning – using the WP Rollback plugin (mentioned here a year ago https://wordpress.org/support/topic/wpblc_links-doesnt-exist/).

Looking at the database, this helped to create the right databases. I then updated to current version.

I didn’t try that collation fix, but the error logs had stopped showing that issue.

The plugin still wasn’t running, and here’s the only error in the logs… (some obfuscation here):

[STDERR] PHP Warning: fopen(/home/xxxx/domains/xx-demo.xxxx.net/public_html/wp-content/plugins//home/xxxx/domains/xx-demo.xxxx.net/public_html/wp-content/plugins/broken-link-checker/broken-link-checker.php): failed to open stream: No such file or directory in /home/xxxx/domains/xx-demo.xxxx.net/public_html/wp-includes/functions.php on line 6111

Hmmm…

Thanks for looking into this. I thought that might be the issue.

I think that would be the third or fourth time I’ve tried a reinstall on this plugin. I can try in a day or two… I’ll let you know how it goes!