ERROR database error write Unknown collation: utf8mb4_unicode_520_ci

  • Resolved lucasair

    (@lucasair)


    7 years, 11 months ago

    I’m having a problem migrating a site with the Duplicator plugin!

    I tried everything and could not solve the problem.

    Can someone help me?

    **ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
    CREATE TABLE wp_commentmeta (
    meta_id bigint(20) unsigned NOT NULL A…]
    **ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
    CREATE TABLE wp_comments (
    comment_ID bigint(20) unsigned NOT NULL A…]
    **ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
    CREATE TABLE wp_links (
    link_id bigint(20) unsigned NOT NULL AUTO_IN…]
    **ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
    CREATE TABLE wp_options (
    option_id bigint(20) unsigned NOT NULL AUT…]
    **ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
    CREATE TABLE wp_postmeta (
    meta_id bigint(20) unsigned NOT NULL AUTO…]
    **ERROR** database error write ‘Unknown collation: ‘utf8mb4_unicode_520_ci” – [sql=
    CREATE TABLE wp_posts (

    /* INSERT TABLE DATA: wp_commentmeta */
    INSERT INTO wp_commentmeta VALU…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_commentmeta’ doesn’t exist’ – [sql=INSERT INTO wp_commentmeta VALUES(“2”, “1”, “_wp_trash_meta_time”, “14804…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_comments’ doesn’t exist’ – [sql=
    /* INSERT TABLE DATA: wp_comments */
    INSERT INTO wp_comments VALUES(“2”,…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=
    /* INSERT TABLE DATA: wp_options */
    INSERT INTO wp_options VALUES(“1”, “…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“4”, “blogdescription”, “Creci: 131931”, “y…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“5”, “users_can_register”, “0”, “yes”)…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“7”, “start_of_week”, “0”, “yes”)…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“8”, “use_balanceTags”, “0”, “yes”)…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“9”, “use_smilies”, “1”, “yes”)…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“10”, “require_name_email”, “”, “yes”)…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“11”, “comments_notify”, “1”, “yes”)…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“12”, “posts_per_rss”, “10”, “yes”)…]
    **ERROR** database error write ‘Table ‘imoveisalphavi.wp_options’ doesn’t exist’ – [sql=INSERT INTO wp_options VALUES(“13”, “rss_use_excerpt”, “0”, “yes”)…]

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

  • Having almost the same issue.

    Installing from live site to localhost.

    White screen after installing with “Deploy Error: 91”

    Common Fixes:
    Query size limits: Update your MySQL server with the max_allowed_packet setting to handle larger payloads.
    Unknown collation: The MySQL Version is too old see: What is Compatibility mode & ‘Unknown collation’ errors?

    max_allowed_packet = 500M

    MySQL

    Host: Success
    Database: Success
    Version: This Server: [5.5.49] — Package Server: [5.6.32]

    NOTICE: The wp-config.php has one or more of the following values set [WPCACHEHOME]. Please validate these values are correct by opening the file and checking the values. To validate the meaning and proper usage of each parameter used the codex link above.

    [WPCACHEHOME] values are perfectly fine.

    W3TC was deactivated at the time of packaging, that went without any issue.
    AIOWPS was active.

    All plug-ins were left out:

    installer log file here: https://www.sendspace.com/file/835c90

    There are a few items on the FAQ that may provide a solution with this issue, this one may get you going.

    ? ? – What is Compatibility mode & ‘Unknown collation’ errors?
    ? ? – https://snapcreek.com/duplicator/docs/faqs-tech/#faq-installer-110-q

    Let me know if any of them help~

    Hey Lamle

    First, the version difference between my localhost and my live server doesn’t seem threateningly apart: Version: This Server: [5.5.49] — Package Server: [5.6.32]. So can we conveniently ignore compatibility issue here?

    Secondly, prior to installing AIOWP and W3T plug-ins, Duplicator was installing the live website on my localhost without any issue. So does it mean that the above-mentioned plug-ins are the culprit?

    Thirdly, I had deactivated W3T plug-in at the time of packaging and while restoring the site at the localhost, I omitted every single plug-in to find out the culprit, but I still ended up with the errors mentioned about, also logged in the “installer log file”.

    What’s your thoughts now?

    Thanx for your help Lamle.

    Hey @maxal,

    It looks like your getting the following:

    **ERROR** database error write 'Unknown collation: 'utf8mb4_unicode_520_ci''

    Which means the database your porting to doesn’t support that table type collation. Activating or deactivating the plugins will not help in this scenario, because the tables are already added to the database. If you know its just these two plugins and you don’t want to mess with Options 2 or 3 in the FAQ you might try to remove/delete vs just deactivating them and then try to re-install the plugins when you have the new site setup. In some cases you can talk with the host/server admin and they might be able to get the version or option enabled for utf8mb4_unicode_520_ci to work…

    Let me know if that helps~

    Thread Starter lucasair

    (@lucasair)

    Thanks

    I did a bit more research on this and it looks like from what I found that the format utf8mb4_unicode_520_ci was introduced in MySQL 5.6, so this looks like it can cause issues with version pre 5.6 trying to use that format.

    Hope that helps~

    Hey, this has been a lifesaver. Same situation for me. But if I change the charset to utf8mb4_general_ci in my PHP My Admin will that allow this installation to work?

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘ERROR database error write Unknown collation: utf8mb4_unicode_520_ci’ is closed to new replies.