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 | 7 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    can't create table while using utf8 encoding in mysql

    GitHub | 7 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 | 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.
  3. 0

    GitHub comment 41#230175290

    GitHub | 8 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

    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