Support » Plugin: Broken Link Checker » WordPress database error Illegal mix of collations

  • Resolved mikeywil

    (@mikeywil)


    Hi

    The plugin works like a dream on my laptop dev site. But when I installed on my hosted site I get 0 results, and various errors in the logs – the first one is:

    [STDERR] WordPress database error Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_unicode_520_ci,IMPLICIT) for operation '=' for query INSERT INTO wp_blc_synch(container_id, container_type, synched)

    Any thoughts?

Viewing 7 replies - 1 through 7 (of 7 total)
  • Thread Starter mikeywil

    (@mikeywil)

    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.

    Plugin Support Adam – WPMU DEV Support

    (@wpmudev-support8)

    Hi @mikeywil

    I hope you’re well today!

    It seems we’re dealing with two issues at once here – missing tables and collation issue.

    You mentioned that the plugin works fine on your local dev site so on the online site it was separately installed, it’s not entire site migrated from local development, right?

    It seems that plugin didn’t create required tables so could you please try these steps:

    1. First, disable and delete the plugin
    2. Then download one of the previous/older versions from here

    https://wordpress.org/plugins/broken-link-checker/advanced/

    and install and enable it on site;

    3. after that perform update

    If there are still collation errors, try this fix plugin:

    https://wordpress.org/plugins/database-collation-fix/

    If it still doesn’t work, let us know here, please.

    Kind regards,
    Adam

    Thread Starter mikeywil

    (@mikeywil)

    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

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @mikeywil

    The ” failed to open stream: No such file or directory in ” means the file doesn’t exist, maybe a corrupted installation.

    Can you please try to reinstall the plugin and check if makes any difference?

    Best Regards
    Patrick Freitas

    Thread Starter mikeywil

    (@mikeywil)

    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!

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @mikeywil

    Thank you for the update.

    Feel free to keep us posted with the results.

    Best Regards
    Patrick Freitas

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @mikeywil

    I hope you are doing well and safe!

    We haven’t heard from you in a while, I’ll mark this thread as resolved.

    Feel free to let us know if you have any additional question or problem.

    Best Regards
    Patrick Freitas

Viewing 7 replies - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.