java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes Query is : CREATE TABLE IF NOT EXISTS MUTES (UUID VARCHAR(256) PRIMARY KEY NOT NULL)

GitHub | cartman-2000 | 9 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    GitHub comment 41#230175290

    GitHub | 9 months ago | cartman-2000
    java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes Query is : CREATE TABLE IF NOT EXISTS MUTES (UUID VARCHAR(256) PRIMARY KEY NOT NULL)
  2. 0

    can't create table while using utf8 encoding in mysql

    GitHub | 8 months ago | bangbang93
    java.sql.SQLSyntaxErrorException: Specified key was too long; max key length is 767 bytes Query is : CREATE TABLE IF NOT EXISTS MUTES (UUID VARCHAR(256) PRIMARY KEY NOT NULL)
  3. 0

    Error on MySQL Enable

    GitHub | 1 year ago | ThornsOfire
    java.sql.SQLSyntaxErrorException: La colonne 'UUID' de type BLOB est utilisée dans une définition d'index sans longueur d'index [22:41:42] [Server thread/INFO] [STDERR]: [io.github.hsyyid.essentialcmds.utils.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLSyntaxErrorException

      Specified key was too long; max key length is 767 bytes Query is : CREATE TABLE IF NOT EXISTS MUTES (UUID VARCHAR(256) PRIMARY KEY NOT NULL)

      at org.mariadb.jdbc.internal.util.ExceptionMapper.get()
    2. org.mariadb.jdbc
      ExceptionMapper.throwException
      1. org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:125)
      2. org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)
      2 frames
    3. mariadb-java-client
      MariaDbStatement.execute
      1. org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:242)
      2. org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:270)
      3. org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:283)
      3 frames
    4. HikariCP-java6
      HikariProxyStatement.execute
      1. com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
      2. com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
      2 frames
    5. io.github.hsyyid
      AsyncCommandExecutorBase.lambda$execute$0
      1. io.github.hsyyid.essentialcmds.utils.Utils.execute(Utils.java:598)
      2. io.github.hsyyid.essentialcmds.utils.Utils.addMute(Utils.java:136)
      3. io.github.hsyyid.essentialcmds.cmdexecutors.MuteExecutor.executeAsync(MuteExecutor.java:66)
      4. io.github.hsyyid.essentialcmds.internal.AsyncCommandExecutorBase.lambda$execute$0(AsyncCommandExecutorBase.java:54)
      4 frames
    6. org.spongepowered.api
      Task$Builder.lambda$execute$0
      1. org.spongepowered.api.scheduler.Task$Builder.lambda$execute$0(Task.java:138)
      1 frame
    7. org.spongepowered.common
      SchedulerBase.lambda$startTask$0
      1. org.spongepowered.common.scheduler.SchedulerBase.lambda$startTask$0(SchedulerBase.java:177)
      1 frame
    8. Java RT
      Thread.run
      1. java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
      2. java.util.concurrent.FutureTask.run(Unknown Source)
      3. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      4. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      5. java.lang.Thread.run(Unknown Source)
      5 frames