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)

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by bangbang93
, 1 year ago
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)
via GitHub by cartman-2000
, 1 year ago
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)
via GitHub by rockmacaca
, 1 year ago
Error preparing query: Table 'projectworlds.settings' doesn't exist
via GitHub by CalumMcCall
, 2 months ago
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 Query is : insert into `AutoInstall` (`namespace`,`pkg_name`,`device`) values ('default','ss','dec7388e-4466-428f-8f8a-4999f5ddbe45') on duplicate key update
via JIRA by Régis Augui, 1 year ago
Error preparing query: Unknown column 'TMP.alerte_code' in 'field list'
via GitHub by skstronghold
, 1 year ago
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND a_key in ("sr","sa") AND endpoint_service_name is not null GROUP BY trace_' at line 1 Query is: SELECT
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(ExceptionMapper.java:125)
at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)
at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:242)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:270)
at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:283)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
at io.github.hsyyid.essentialcmds.utils.Utils.execute(Utils.java:586)
at io.github.hsyyid.essentialcmds.utils.Utils.readMutes(Utils.java:613)
at io.github.hsyyid.essentialcmds.EssentialCmds.onServerInit(EssentialCmds.java:199)
at org.spongepowered.common.event.listener.GameInitializationEventListener_EssentialCmds_onServerInit3.handle(Unknown Source)
at org.spongepowered.common.event.RegisteredListener.handle(RegisteredListener.java:95)
at org.spongepowered.mod.event.SpongeModEventManager.post(SpongeModEventManager.java:354)
at org.spongepowered.mod.event.SpongeModEventManager.post(SpongeModEventManager.java:395)
at org.spongepowered.mod.SpongeMod.onStateEvent(SpongeMod.java:205)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.google.common.eventbus.EventSubscriber.handleEvent(EventSubscriber.java:74)
at com.google.common.eventbus.SynchronizedEventSubscriber.handleEvent(SynchronizedEventSubscriber.java:47)
at com.google.common.eventbus.EventBus.dispatch(EventBus.java:322)
at com.google.common.eventbus.EventBus.dispatchQueuedEvents(EventBus.java:304)
at net.minecraftforge.fml.common.LoadController.sendEventToModContainer(LoadController.java:235)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.google.common.eventbus.EventSubscriber.handleEvent(EventSubscriber.java:74)
at com.google.common.eventbus.SynchronizedEventSubscriber.handleEvent(SynchronizedEventSubscriber.java:47)
at com.google.common.eventbus.EventBus.dispatch(EventBus.java:322)
at com.google.common.eventbus.EventBus.dispatchQueuedEvents(EventBus.java:304)
at net.minecraftforge.fml.common.LoadController.redirect$onPost$0(LoadController.java:53)
at net.minecraftforge.fml.common.LoadController.distributeStateMessage(LoadController.java:142)
at net.minecraftforge.fml.common.Loader.initializeMods(Loader.java:774)
at net.minecraftforge.fml.server.FMLServerHandler.finishServerLoading(FMLServerHandler.java:107)
at net.minecraft.server.dedicated.DedicatedServer.func_71197_b(DedicatedServer.java:214)
at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:431)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

You are the first who have seen this exception. Write a tip to help other users and build your expert profile.

Know the solutions? Share your knowledge to help other developers to debug faster.