DB tables not created on plugin activation

  • Table creation is silently failing upon activation of the plugin… the plugin looks like it activates properly but it is only adding the {prefix}_oauth_scopes table.

    All other tables in the plugin fail to be created with the following error:

    WordPress database error Specified key was too long; max key length is 767 bytes for query

    {prefix}_oauth_clients, _oauth_access_tokens, _oauth_refresh_tokens, _oauth_authorization_codes, _oauth_jwt, _oauth_public_keys are all failing with that same error.

    I have tried this on several WP installs… all of them up to date, some of them fresh installs with no plugins. I get this same error on all of them.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Justin Greer

    (@justingreerbbi)

    Thank you for reporting this issue. We have not been able to replicate this issue but maybe you can help ??

    – Where all your sites on the same server?
    – What MySQL DB version are you using?
    – What Charset is your DB?

    This most likely is a compatibility issue with new MySQL limits and utf8mb4. I will add this to our bug tracker internally and see if we can get a fix pushed here in the next release (in the next week or so).

    Thread Starter d0ug

    (@d0ug)

    – 2 different Ubuntu 14.04 servers but configured almost identically.
    – MySQL is 5.6.33
    – Charset is indeed utf8mb4

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘DB tables not created on plugin activation’ is closed to new replies.