Open ThornsOfire opened 8 years ago
What version of Sponge is this on? What version of Minecraft and/or Forge? What version of EssentialCmds?
Java 1.8.0_71 64 bit mcp 9.18 FML 8.0.99.99 forge 1.8.9-11.15.0.1694 sponge 1.8.9-1694-3.1.0-BETA 1084 AdminShop 1.3c AntiSwear 1.1.3 ArmorHUD 1.0 Blood Money 0.2.8 EssentialCmds 7.1-ec3ebe2 FoxCore-v0.6.2-70 Kits 1.3c landiscovery 1.0.1 PermissionsEx 2.0-SNAPSHOT PvPLogger 1.1 TotalEconomy 1.3.1 Vanish 4.0.0 worldedit-forge-mc 1.8.9-6.1.1
Same error running Minecraft Forge: 11.15.1.1722
Please try updating to SpongeForge 1103,
Also please send logs in English if possible :smile:
Will do, we have also added a few plugins and updated a number as well, Would you like an updated versions log?
[20:29:22] [Server thread/INFO] [EssentialCmds]: EssentialCmds loading...
-0 - is starting.
Utils:execute:403]: java.sql.SQLSyntaxErrorException: La colonne 'UUID' de type BLOB est utilisée dans une définition d'index sans longueur d'index
Utils:execute:403]: at org.mariadb.jdbc.internal.util.ExceptionMapper.get(Ex ceptionMapper.java:125)
Utils:execute:403]: at org.mariadb.jdbc.internal.util.ExceptionMapper.throwE xception(ExceptionMapper.java:69)
Utils:execute:403]: at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog( MariaDbStatement.java:261)
Utils:execute:403]: at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStat ement.java:290)
Utils:execute:403]: at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStat ement.java:344)
Utils:execute:403]: at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxySt atement.java:95)
Utils:execute:403]: at com.zaxxer.hikari.pool.HikariProxyStatement.execute(H ikariProxyStatement.java)
Utils:execute:403]: at io.github.hsyyid.essentialcmds.utils.Utils.execute(Ut ils.java:396)
Utils:execute:403]: at io.github.hsyyid.essentialcmds.utils.Utils.readMutes( Utils.java:423)
Utils:execute:403]: at io.github.hsyyid.essentialcmds.EssentialCmds.onServer Init(EssentialCmds.java:119)
Utils:execute:403]: at org.spongepowered.common.event.listener.GameInitializ ationEventListener_EssentialCmds_onServerInit16.handle(Unknown Source)
Utils:execute:403]: at org.spongepowered.common.event.RegisteredListener.han dle(RegisteredListener.java:86)
Utils:execute:403]: at org.spongepowered.mod.event.SpongeModEventManager.pos t(SpongeModEventManager.java:236)
Utils:execute:403]: at org.spongepowered.mod.event.SpongeModEventManager.pos t(SpongeModEventManager.java:280)
Utils:execute:403]: at org.spongepowered.mod.SpongeMod.onStateEvent(SpongeMo d.java:185)
Utils:execute:403]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M ethod)
Utils:execute:403]: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S ource)
Utils:execute:403]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno wn Source)
Utils:execute:403]: at java.lang.reflect.Method.invoke(Unknown Source)
Utils:execute:403]: at com.google.common.eventbus.EventSubscriber.handleEven t(EventSubscriber.java:74)
Utils:execute:403]: at com.google.common.eventbus.SynchronizedEventSubscribe r.handleEvent(SynchronizedEventSubscriber.java:47)
Utils:execute:403]: at com.google.common.eventbus.EventBus.dispatch(EventBus .java:322)
Utils:execute:403]: at com.google.common.eventbus.EventBus.dispatchQueuedEve nts(EventBus.java:304)
Utils:execute:403]: at com.google.common.eventbus.EventBus.post(EventBus.jav a:275)
Utils:execute:403]: at net.minecraftforge.fml.common.LoadController.sendEven tToModContainer(LoadController.java:211)
Utils:execute:403]: at net.minecraftforge.fml.common.LoadController.propogat eStateMessage(LoadController.java:189)
Utils:execute:403]: at sun.reflect.NativeMethodAccessorImpl.invoke0(Native M ethod)
Utils:execute:403]: at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown S ource)
Utils:execute:403]: at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unkno wn Source)
Utils:execute:403]: at java.lang.reflect.Method.invoke(Unknown Source)
Utils:execute:403]: at com.google.common.eventbus.EventSubscriber.handleEven t(EventSubscriber.java:74)
Utils:execute:403]: at com.google.common.eventbus.SynchronizedEventSubscribe r.handleEvent(SynchronizedEventSubscriber.java:47)
Utils:execute:403]: at com.google.common.eventbus.EventBus.dispatch(EventBus .java:322)
Utils:execute:403]: at com.google.common.eventbus.EventBus.dispatchQueuedEve nts(EventBus.java:304)
Utils:execute:403]: at com.google.common.eventbus.EventBus.post(EventBus.jav a:275)
Utils:execute:403]: at net.minecraftforge.fml.common.LoadController.onPost(L oadController.java:53)
Utils:execute:403]: at net.minecraftforge.fml.common.LoadController.distribu teStateMessage(LoadController.java:118)
Utils:execute:403]: at net.minecraftforge.fml.common.Loader.initializeMods(L oader.java:737)
Utils:execute:403]: at net.minecraftforge.fml.server.FMLServerHandler.finish ServerLoading(FMLServerHandler.java:97)
Utils:execute:403]: at net.minecraftforge.fml.common.FMLCommonHandler.onServ erStarted(FMLCommonHandler.java:325)
Utils:execute:403]: at net.minecraft.server.dedicated.DedicatedServer.func_7 1197_b(DedicatedServer.java:205)
Utils:execute:403]: at net.minecraft.server.MinecraftServer.run(MinecraftSer ver.java:441)
Utils:execute:403]: at java.lang.Thread.run(Unknown Source)
1]: Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: La colonne 'UU ID' de type BLOB est utilisée dans une définition d'index sans longueur d'index
1]: at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(Ab stractQueryProtocol.java:475)
1]: at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.result(Abstr actQueryProtocol.java:396)
1]: at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery (AbstractQueryProtocol.java:378)
1]: at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery (AbstractQueryProtocol.java:334)
1]: at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:280)
1]: ... 39 more
[20:29:23] [Server thread/INFO] [EssentialCmds]: EssentialCmds was made by Hassa nS6000! [20:29:23] [Server thread/INFO] [EssentialCmds]: Please post all errors on the S ponge Thread or on GitHub! [20:29:23] [Server thread/INFO] [EssentialCmds]: Have fun, and enjoy! :D
[20:29:23] [Server thread/INFO] [EssentialCmds]: EssentialCmds loaded!
Posting them anyways <3
Versions
Java 1.8.0_71 64 bit mcp 9.18 FML 8.0.99.99 minecraft_server.1.8.9 Forge: 11.15.1.1722 spongeforge-1.8.9-1722-3.1.0-BETA-1103 AdminShop-1.3c AntiSwear 1.1.3 ArmorHUD v1.0 Blood Money 0.2.8 Ember-1.0-SNAPSHOT EssentialCmds-7.1 FoxCore-v0.6.2-70-SNAPSHOT Kits-1.3c landiscovery-1.0.1 LootCrate-1.1-Beta PermissionsEx-Sponge-2.0 Polis-1.8b PvPLogger-1.1 ServerListPlusSponge-3.4.1-SNAPSHOT TotalEconomy-v1.3.1 UltimateGames-0.3 vanish4.0.0 worldedit-forge-mc1.8.9-6.1.1 XtraPunish-1.1
I can see that there is some french in there, I am using english on my computer/console/server/everything lol not sure whats going on there
Okay, I'll test it out, not sure what the issue is. Also please use PasteBin for future logs.
Yeah sorry not sure why I didn't... lol
Let me know if you need me to test anything, I check github often.
@ThornsOfire Has this been resolved?
I get this error on the creation of the mutes table. The length of the UUID varchar doesn't need to be that long it only needs to be ~36 characters long.
OS: Windows 10 Mysql: 5.5.40 Java: 1.8.0_91 64 bit SpongeForge version: 1.10.2-2002-5.0.0-BETA-1525
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: 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)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:125)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at org.mariadb.jdbc.internal.util.ExceptionMapper.throwException(ExceptionMapper.java:69)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:242)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:270)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:283)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at io.github.hsyyid.essentialcmds.utils.Utils.execute(Utils.java:598)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at io.github.hsyyid.essentialcmds.utils.Utils.addMute(Utils.java:136)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at io.github.hsyyid.essentialcmds.cmdexecutors.MuteExecutor.executeAsync(MuteExecutor.java:66)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at io.github.hsyyid.essentialcmds.internal.AsyncCommandExecutorBase.lambda$execute$0(AsyncCommandExecutorBase.java:54)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at org.spongepowered.api.scheduler.Task$Builder.lambda$execute$0(Task.java:138)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at org.spongepowered.common.scheduler.SchedulerBase.lambda$startTask$0(SchedulerBase.java:177)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at java.util.concurrent.FutureTask.run(Unknown Source)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [io.github.hsyyid.essentialcmds.utils.Utils:execute:605]: at java.lang.Thread.run(Unknown Source)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [java.lang.Throwable:printStackTrace:-1]: Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: 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)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [java.lang.Throwable:printStackTrace:-1]: at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:938)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [java.lang.Throwable:printStackTrace:-1]: at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:604)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [java.lang.Throwable:printStackTrace:-1]: at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:261)
[12:56:00] [pool-2-thread-3/INFO] [STDERR/sponge]: [java.lang.Throwable:printStackTrace:-1]: ... 14 more
Also for windows compatibility, you should have the table names and database name in lowercase only, while it does still work when you use uppercase, you can't do a direct rename(by changing case only.), and you get a warning printed out in the mysql logs on every start about uppercase letters being used in the names.
I'm getting the same error as @cartman-2000 on Windows with MariaDB, so I'm unable to use MySQL backend. Can this be fixed soon?
SpongeForge 1094 Forge 1694