Error message: The key was too long, MAX key length is 767 bytes.

  • Resolved samuelmartin

    (@samuelmartin)


    4 years, 1 month ago

    Hi,

    Trying to migrate my website from one ISP to another using your plugin “migrate guru”, I get the following error.

    Migration Failed

    Error while creating the table wp_shortpixel_folders. The key was too long, MAX key length is 767 bytes.

    Can anyone help me solve this, please?

    Regards

    Sam

    • This topic was modified 4 years, 1 month ago by samuelmartin.

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support amanbv

    (@amanbv)

    Hey Sam!

    Thank you for reaching out to us.

    This error normally occurs on old MySQL versions.

    You can refer to this document for more information -> https://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

    Let us know if you have any questions & we’ll assist you.

    Thanks!

    riverofwind

    (@riverofwind)

    I am getting the same error message. How does one remedy it? I am moving from Siteground to Hostgator. Thanks!

    riverofwind

    (@riverofwind)

    Also should I purge the wordpress setup on the destination host since it failed part way through? Or should I just do another migrate?

    riverofwind

    (@riverofwind)

    …the full error message…
    Error while creating the table wpb7_wpns_malware_hash_file. The key was too long, MAX key length is 767 bytes.
    Don’t be afraid to get technical I’ve got a background in comp sci

    riverofwind

    (@riverofwind)

    I started a ticket with Migrate Guru and they skipped the offending table. Also the table looks to be related to MiniOrange 2FA WordPress plugin and it works without the table so far.

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Error message: The key was too long, MAX key length is 767 bytes.’ is closed to new replies.

Tags