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 | 5 months ago
  1. 0

    GitHub comment 41#230175290

    GitHub | 5 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 | 4 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 | 10 months 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

  5. 0

    MySQL error: Specified key was too long; max key length is 767 bytes

    GitHub | 3 weeks ago | vrozkovec
    org.polyjdbc.core.exception.SchemaManagerException: [DDL_ERROR] Failed to run DDL: CREATE TABLE jv_commit_property ( property_name VARCHAR(200), property_value VARCHAR(200), commit_fk BIGINT, CONSTRAINT jv_commit_property_pk PRIMARY KEY(commit_fk, property_name), CONSTRAINT jv_commit_property_commit_fk FOREIGN KEY(commit_fk) REFERENCES jv_commit(commit_pk) ) ENGINE = InnoDB
  6. 0

    DataBase generation fails JPA

    Stack Overflow | 3 years ago | eento
    java.sql.SQLSyntaxErrorException: Erreur de syntaxe : Encountered "user" at line 1, column 134. Error Code: -1 Call: CREATE TABLE COURSE (COURSEID BIGINT NOT NULL, coursename VARCHAR(255), description VARCHAR(255), duration INTEGER, myuserId BIGINT, user BIGINT, PRIMARY KEY (COURSEID)) Query: DataModifyQuery(sql="CREATE TABLE COURSE (COURSEID BIGINT NOT NULL, coursename VARCHAR(255), description VARCHAR(255), duration INTEGER, myuserId BIGINT, user BIGINT, PRIMARY KEY (COURSEID))")

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    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