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 | bangbang93 | 4 months ago
  1. 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)
  2. 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.
  3. 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)
  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 | 4 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
      EssentialCmds.onServerInit
      1. io.github.hsyyid.essentialcmds.utils.Utils.execute(Utils.java:586)
      2. io.github.hsyyid.essentialcmds.utils.Utils.readMutes(Utils.java:613)
      3. io.github.hsyyid.essentialcmds.EssentialCmds.onServerInit(EssentialCmds.java:199)
      3 frames
    6. org.spongepowered.common
      RegisteredListener.handle
      1. org.spongepowered.common.event.listener.GameInitializationEventListener_EssentialCmds_onServerInit3.handle(Unknown Source)
      2. org.spongepowered.common.event.RegisteredListener.handle(RegisteredListener.java:95)
      2 frames
    7. org.spongepowered.mod
      SpongeMod.onStateEvent
      1. org.spongepowered.mod.event.SpongeModEventManager.post(SpongeModEventManager.java:354)
      2. org.spongepowered.mod.event.SpongeModEventManager.post(SpongeModEventManager.java:395)
      3. org.spongepowered.mod.SpongeMod.onStateEvent(SpongeMod.java:205)
      3 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    9. Guava
      EventBus.post
      1. com.google.common.eventbus.EventSubscriber.handleEvent(EventSubscriber.java:74)
      2. com.google.common.eventbus.SynchronizedEventSubscriber.handleEvent(SynchronizedEventSubscriber.java:47)
      3. com.google.common.eventbus.EventBus.dispatch(EventBus.java:322)
      4. com.google.common.eventbus.EventBus.dispatchQueuedEvents(EventBus.java:304)
      5. com.google.common.eventbus.EventBus.post(EventBus.java:275)
      5 frames
    10. MC Forge
      LoadController.propogateStateMessage
      1. net.minecraftforge.fml.common.LoadController.sendEventToModContainer(LoadController.java:235)
      2. net.minecraftforge.fml.common.LoadController.propogateStateMessage(LoadController.java:213)
      2 frames
    11. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:497)
      4 frames
    12. Guava
      EventBus.post
      1. com.google.common.eventbus.EventSubscriber.handleEvent(EventSubscriber.java:74)
      2. com.google.common.eventbus.SynchronizedEventSubscriber.handleEvent(SynchronizedEventSubscriber.java:47)
      3. com.google.common.eventbus.EventBus.dispatch(EventBus.java:322)
      4. com.google.common.eventbus.EventBus.dispatchQueuedEvents(EventBus.java:304)
      5. com.google.common.eventbus.EventBus.post(EventBus.java:275)
      5 frames
    13. MC Forge
      FMLCommonHandler.onServerStarted
      1. net.minecraftforge.fml.common.LoadController.redirect$onPost$0(LoadController.java:53)
      2. net.minecraftforge.fml.common.LoadController.distributeStateMessage(LoadController.java:142)
      3. net.minecraftforge.fml.common.Loader.initializeMods(Loader.java:774)
      4. net.minecraftforge.fml.server.FMLServerHandler.finishServerLoading(FMLServerHandler.java:107)
      5. net.minecraftforge.fml.common.FMLCommonHandler.onServerStarted(FMLCommonHandler.java:333)
      5 frames
    14. MC Server
      MinecraftServer.run
      1. net.minecraft.server.dedicated.DedicatedServer.func_71197_b(DedicatedServer.java:214)
      2. net.minecraft.server.MinecraftServer.run(MinecraftServer.java:431)
      2 frames
    15. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame