• Resolved trap123

    (@trap123)


    
    WordPress database error COLLATION 'latin1_swedish_ci' is not valid for CHARACTER SET 'utf8mb4' for query \n\n\tCREATE TABLE IF NOT EXISTS <code>wp_blc_instances</code> (\n\t\t<code>instance_id</code> int(10) unsigned NOT NULL AUTO_INCREMENT,\n\t\t<code>link_id</code> int(10) unsigned NOT NULL,\n\t\t<code>container_id</code> int(10) unsigned NOT NULL,\n\t\t<code>container_type</code> varchar(40) NOT NULL DEFAULT 'post',\n\t\t<code>link_text</code> text NOT NULL DEFAULT '',\n\t\t<code>parser_type</code> varchar(40) NOT NULL DEFAULT 'link',\n\t\t<code>container_field</code> varchar(250) NOT NULL DEFAULT '',\n\t\t<code>link_context</code> varchar(250) NOT NULL DEFAULT '',\n\t\t<code>raw_url</code> text NOT NULL,\n\n\t\tPRIMARY KEY (<code>instance_id</code>),\n\t\tKEY <code>link_id</code> (<code>link_id</code>),\n\t\tKEY <code>source_id</code> (<code>container_type</code>, <code>container_id</code>),\n\t\tKEY <code>parser_type</code> (<code>parser_type</code>)\n\t) DEFAULT CHARACTER SET utf8mb4 COLLATE latin1_swedish_ci made by require_once('wp-load.php'), require_once('wp-config.php'), require_once('wp-settings.php'), do_action('init'), WP_Hook->do_action, WP_Hook->apply_filters, blc_init, blcDatabaseUpgrader::upgrade_database, blcDatabaseUpgrader::make_schema_current, blcTableDelta::delta,
    
    • This topic was modified 6 years, 3 months ago by trap123.
    • This topic was modified 6 years, 3 months ago by Yui. Reason: please use CODE button for code formatting
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Laura – WPMU DEV Support

    (@wpmudev-support8)

    Hi @trap123

    I hope you’re well today and thank you for reporting this!

    Our developers are already looking into some issue related to database tables creation but since this seems to be something slightly different to what we already know of, I’ve also reported it to them.

    We’ll look closer into it to implement a fix with one of upcoming releases.

    Meanwhile, could you try installing previous version of the plugin first and than upgrading it to the current one?

    You’ll find previous release on this page:

    https://ww.wp.xz.cn/plugins/broken-link-checker/advanced/

    Please try with 1.11.10 or 1.11.9 and then upgrade it afterwards. Let me know, please, if that removed the error and let you activate and use plugin.

    Would you, please, let me also know what database are you using (e.g. mySQL or MariaDB) and in what version?

    Best regards,
    Adam

    Thread Starter trap123

    (@trap123)

    I am using these configuration :

    Server info: Apache
    PHP version: 7.4.2
    MySQL version: 5.6.40-84.0-log

    Plugin Support Laura – WPMU DEV Support

    (@wpmudev-support8)

    Hi @trap123

    Thank you for information!

    Meanwhile, have you tried to install the previous version and then upgrade to the recent one, as suggested in my previous response?

    If not, could you give it a shot, please, and let me know about results?

    Kind regards,
    Adam

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘WordPress database error COLLATION ‘latin1_swedish_ci’ is closed to new replies.