ERROR: Database error : COLLATION

  • Resolved peremr

    (@peremr)


    5 years, 6 months ago

    I’ve installed this pluguin but seems there is some issue with the DDBB .
    could you give me some way to fix this problem?

    I’ve enabled log file and getting this kind of errors:
    “DEFAULT CHARACTER SET latin1 COLLATE utf8mb4_general_ci
    [2020-09-22 13:36:59 +00:00] ERROR: Database error : COLLATION ‘utf8mb4_general_ci’ is not valid for CHARACTER SET ‘latin1’
    [2020-09-22 13:36:59 +00:00] ERROR: [ ]
    “

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    5 years, 6 months ago

    Hello @peremr ,

    I’m sorry about this issue.

    We had something like that reported previously for version 1.11.10, but it should be fixed already.
    Could you please test version 1.11.9 (you can get it here https://wordpress.org/plugins/broken-link-checker/advanced/ ) and quickly check if there will be the same error with it?

    kind regards,
    Kasia

    Thread Starter peremr

    (@peremr)

    5 years, 6 months ago

    Same result with 1.11.9 :
    hers the installation log:

    
Plugin activated at 2020-09-23 11:15:33.
Installation/update begins.
Upgrading the database...
... SHOW TABLES (0.001 seconds)
[ ] CREATE TABLE IF NOT EXISTS wp_blc_filters ( id int(10) unsigned NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL, params text NOT NULL, PRIMARY KEY (id) ) DEFAULT CHARACTER SET latin1 COLLATE utf8mb4_general_ci
Database error : COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1'
[ ] CREATE TABLE IF NOT EXISTS wp_blc_instances ( instance_id int(10) unsigned NOT NULL AUTO_INCREMENT, link_id int(10) unsigned NOT NULL, container_id int(10) unsigned NOT NULL, container_type varchar(40) NOT NULL DEFAULT 'post', link_text text NOT NULL DEFAULT '', parser_type varchar(40) NOT NULL DEFAULT 'link', container_field varchar(250) NOT NULL DEFAULT '', link_context varchar(250) NOT NULL DEFAULT '', raw_url text NOT NULL, PRIMARY KEY (instance_id), KEY link_id (link_id), KEY source_id (container_type, container_id), KEY parser_type (parser_type) ) DEFAULT CHARACTER SET latin1 COLLATE utf8mb4_general_ci
Database error : COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1'
[ ] CREATE TABLE IF NOT EXISTS wp_blc_links ( link_id int(20) unsigned NOT NULL AUTO_INCREMENT, url text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, first_failure datetime NOT NULL DEFAULT '0000-00-00 00:00:00', last_check datetime NOT NULL DEFAULT '0000-00-00 00:00:00', last_success datetime NOT NULL DEFAULT '0000-00-00 00:00:00', last_check_attempt datetime NOT NULL DEFAULT '0000-00-00 00:00:00', check_count int(4) unsigned NOT NULL DEFAULT '0', final_url text CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL, redirect_count smallint(5) unsigned NOT NULL DEFAULT '0', log text NOT NULL, http_code smallint(6) NOT NULL DEFAULT '0', status_code varchar(100) DEFAULT '', status_text varchar(250) DEFAULT '', request_duration float NOT NULL DEFAULT '0', timeout tinyint(1) unsigned NOT NULL DEFAULT '0', broken tinyint(1) unsigned NOT NULL DEFAULT '0', warning tinyint(1) unsigned NOT NULL DEFAULT '0', may_recheck tinyint(1) NOT NULL DEFAULT '1', being_checked tinyint(1) NOT NULL DEFAULT '0', result_hash varchar(200) NOT NULL DEFAULT '', false_positive tinyint(1) NOT NULL DEFAULT '0', dismissed tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (link_id), KEY url (url(150)), KEY final_url (final_url(150)), KEY http_code (http_code), KEY broken (broken) ) DEFAULT CHARACTER SET latin1 COLLATE utf8mb4_general_ci
Database error : COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1'
[ ] CREATE TABLE IF NOT EXISTS wp_blc_synch ( container_id int(20) unsigned NOT NULL, container_type varchar(40) NOT NULL, synched tinyint(2) unsigned NOT NULL, last_synch datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (container_type,container_id), KEY synched (synched) ) DEFAULT CHARACTER SET latin1 COLLATE utf8mb4_general_ci
Database error : COLLATION 'utf8mb4_general_ci' is not valid for CHARACTER SET 'latin1'
Schema update took 0.002 seconds
Database schema updated.
    • This reply was modified 5 years, 6 months ago by Yui. Reason: please use CODE button for proper formatting
    Plugin Support Laura – WPMU DEV Support

    (@wpmudev-support8)

    5 years, 6 months ago

    Hi @peremr

    Thank you for testing it and updating us!

    Although it’s a bit much to ask, may I ask you to test also up to two version back?

    Please try with 1.11.8 and if that still doesn’t help with 1.11.7 (but don’t go back any further).

    Let us know then, please:

    – if any of these versions worked for you
    – what’s the PHP version powering your site?
    – is it mySQL or MariaDB database and what’s the version number
    – and who are you hosting with (some of these issues were related to specific hosts in the past).

    Best regards,
    Adam

    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    5 years, 6 months ago

    Hello @peremr ,

    We haven’t heard from you for a while now, so we will assume that this issue is resolved.
    Please feel free to re-open this ticket if needed.

    kind regards,
    Kasia

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

The topic ‘ERROR: Database error : COLLATION’ is closed to new replies.