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 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 StuAtGit
, 1 year 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 '5 on duplicate key update counter = counter +' at line 1 Query is : insert into test_jdbi_bug (id, data, counters) values (1,'test',1)5 on duplicate key update counter = counter +
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 jtwebman
, 1 year ago
Table 'rancher.setting' doesn't exist
via JIRA by Régis Augui, 1 year ago
Error preparing query: Unknown column 'TMP.alerte_code' in 'field list'
via GitHub by rockmacaca
, 1 year ago
Error preparing query: Table 'projectworlds.settings' doesn't exist
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:598)
at io.github.hsyyid.essentialcmds.utils.Utils.addMute(Utils.java:136)
at io.github.hsyyid.essentialcmds.cmdexecutors.MuteExecutor.executeAsync(MuteExecutor.java:66)
at io.github.hsyyid.essentialcmds.internal.AsyncCommandExecutorBase.lambda$execute$0(AsyncCommandExecutorBase.java:54)
at org.spongepowered.api.scheduler.Task$Builder.lambda$execute$0(Task.java:138)
at org.spongepowered.common.scheduler.SchedulerBase.lambda$startTask$0(SchedulerBase.java:177)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

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.