utf8mb4_unicode_ci (Specified key was too long; max key length is 10)

  • Lester Chan

    (@gamerz)


    9 years ago

    Just a FYI thingy:

    This plugin adds a new key to your commentmeta table

    KEY     disqus_dupecheck (meta_key,meta_value(11))

    and so when the you upgrade to WordPress 4.2, it runs
    ALTER TABLE wp_commentmeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci

    It will fail because the key is too long
    Specified key was too long; max key length is 1000 bytes

    https://wordpress.org/plugins/disqus-comment-system/

Viewing 2 replies - 1 through 2 (of 2 total)
  • leanderlindahl

    (@leanderlindahl)

    8 years, 8 months ago

    Yes, I’ve got something rather similar. Is there any way to solve the problem? (Disqus Commenting System 2.84). Previous to upgrade it worked.

    WordPress database error: [Specified key was too long; max key length is 1000 bytes]
CREATE INDEX disqus_dupecheck ON <code>wp_commentmeta</code> (meta_key, meta_value(11));
    archon810

    (@archon810)

    8 years, 4 months ago

    Change the meta_key column of the wp_commentmeta table to 191 characters long from 255 to fix this.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘utf8mb4_unicode_ci (Specified key was too long; max key length is 10)’ is closed to new replies.