Media Temple install fail… MySQL fail

  • Resolved redsphere

    (@redsphere)


    11 years ago

    Here is part of the Install Log:

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

    https://wordpress.org/plugins/duplicator/

Viewing 7 replies - 1 through 7 (of 7 total)
  • Cory Lamle

    (@corylamleorg)

    11 years ago

    Hey Redsphere,

    What version of mysql are you using? From what I found on google ‘utf8mb4’ is only supported in 5.5.3 and above…

    Thanks~

    jibranb

    (@jibran-bisharat)

    11 years ago

    Hi Cory, I’m running into a similar issue. Assuming I can’t upgrade the MySQL version on the destination server do you have a recommended fix?

    Some ideas I’m wondering about:
    – Would a simple text search and replace fix this? (And then manually re-ZIP?)
    – Is there a way to force the character set in Duplicator?

    Any help would be greatly appreciated!

    -Jibran

    Cory Lamle

    (@corylamleorg)

    11 years ago

    Hey Jibran,

    Step 1 advanced options settings has some values you can try, but its based on the actual connection type. You can try this solution which I hope to integrate some day…

    Cheers~

    Thread Starter redsphere

    (@redsphere)

    11 years ago

    Thanks for the info Cory, although I moved the client off Media Temple that solution might come in handy in the future!
    and good luck Jibran!

    Cory Lamle

    (@corylamleorg)

    11 years ago

    No problem… Cheers~

    jibranb

    (@jibran-bisharat)

    10 years, 10 months ago

    Yes, Cory, that solution worked for me. Thank you both.

    -J

    Cory Lamle

    (@corylamleorg)

    10 years, 10 months ago

    Excellent! Thxs for the update

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

The topic ‘Media Temple install fail… MySQL fail’ is closed to new replies.