Scopes table not being created

  • Resolved ryvix

    (@rrhode)


    6 years, 4 months ago

    Hi there,

    I noticed when trying to use the plugin that it didn’t create the scopes table for some reason. I tried to manually run the query to create it and it says:

    SQL query:
    CREATE TABLE IF NOT EXISTS wpmb_moos_oauth_scopes (scope varchar(255), is_default BOOLEAN, UNIQUE (scope))

    MySQL said:
    #1071 – Specified key was too long; max key length is 1000 bytes

    Server version: 5.6.41-log – MySQL Community Server (GPL)

    So I think you might have to adjust the way your scopes table is designed or something.

Viewing 1 replies (of 1 total)
  • Plugin Author miniOrange

    (@cyberlord92)

    Hi,

    Looks like only 1000 bytes are allowed as per your current MYSQL configuration. Can you please try with SQL query below?

    CREATE TABLE IF NOT EXISTS wpmb_moos_oauth_scopes (scope varchar(100), is_default BOOLEAN, UNIQUE (scope))

    We will be updating the same change in our plugin and will publish a new version.

    Thanks.

    • This reply was modified 6 years, 4 months ago by miniOrange.
Viewing 1 replies (of 1 total)
  • The topic ‘Scopes table not being created’ is closed to new replies.