DB errors when activating

  • Resolved karl53

    (@karl53)


    3 years, 11 months ago

    Hello,

    When I activated Broken Link Checker, I got the below error. Why? Is there anything I can do to fix this? Not sure if the plugin is working correctly as another (paid) service says I have broken links, but this plugin says there are none.

    Thanks for your help.

    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, 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
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, 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
Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Dmytro – WPMU DEV Support

    (@wpmudevsupport16)

    Hi there @karl53

    The plugin uses the same default character set and collation settings as native WP tables.

    I’d suggest checking your wp-config.php file to ensure the DB_CHARSET is explicitly set, and that DB_COLLATE is null. That’s best practice so collation gets automatically assigned based on the charset. Like so:

    define('DB_CHARSET', 'utf8mb4');
define('DB_COLLATE', '');

    As for the plugin not finding any broken links, that would depend largely on which options are enabled under the “Look for links in” and “Which links to check” tabs.

    For example, if you have broken links in some Plaintext URLs in Draft posts, but haven’t enabled those options, the plugin won’t scan for those.

    Cheers!
    Patrick

    Plugin Support Patrick – WPMU DEV Support

    (@wpmudevsupport12)

    Hi @karl53

    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 2 replies - 1 through 2 (of 2 total)
  • The topic ‘DB errors when activating’ is closed to new replies.