Before I submit a ticket... What's this?

Tenelia · April 15, 2017, 5:10pm

So I recently got around to setting up a Sponge server, and I’m confused by this error because I don’t have a way to change the names of the default Nether world. It then throws up this error with RedProtect plugin trying to register a database. Does this merit a ticket or is there an obvious solution that I’m missing? I should be able to change the name easily somewhere right…

[01:05:53 ERROR] Query is : CREATE [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] Query is : CREATE [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [01:05:53 ERROR] [STDERR]: [STDERR]: java.sql.SQLSyntaxErrorException: (conn:1755) 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 ‘-1’ at line 1
DATABASE redprotect_DIM-1
at org.mariadb.jdbc.internal.util.ExceptionMapper.get(ExceptionMapper.java:134)
at org.mariadb.jdbc.internal.util.ExceptionMapper.getException(ExceptionMapper.java:101)
at org.mariadb.jdbc.internal.util.ExceptionMapper.throwAndLogException(ExceptionMapper.java:77)
at org.mariadb.jdbc.MariaDbStatement.executeQueryEpilog(MariaDbStatement.java:224)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:258)
at org.mariadb.jdbc.MariaDbStatement.executeUpdate(MariaDbStatement.java:387)
at br.net.fabiozumbi12.redprotect.WorldMySQLRegionManager.(WorldMySQLRegionManager.java:54)
at br.net.fabiozumbi12.redprotect.RegionManager.loadAll(RegionManager.java:32)
at br.net.fabiozumbi12.redprotect.RedProtect.onServerStart(RedProtect.java:88)
at org.spongepowered.common.event.listener.GameStartedServerEventListener_RedProtect_onServerStart64.handle(Unknown Source)
at org.spongepowered.common.event.RegisteredListener.handle(RegisteredListener.java:95)
at org.spongepowered.common.event.SpongeEventManager.post(SpongeEventManager.java:305)
at org.spongepowered.common.event.SpongeEventManager.post(SpongeEventManager.java:319)
at org.spongepowered.common.event.SpongeEventManager.post(SpongeEventManager.java:323)
at org.spongepowered.common.SpongeImpl.postState(SpongeImpl.java:188)
at org.spongepowered.server.SpongeVanilla.onServerStarting(SpongeVanilla.java:166)
at net.minecraft.server.dedicated.DedicatedServer.handler$callServerStarting$zob000(SourceFile:1249)
at net.minecraft.server.dedicated.DedicatedServer.func_71197_b(SourceFile:229)
at net.minecraft.server.MinecraftServer.run(SourceFile:436)
at java.lang.Thread.run(Unknown Source)
[STDERR]: Caused by: org.mariadb.jdbc.internal.util.dao.QueryException: 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 ‘-1’ at line 1
DATABASE redprotect_DIM-1
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1114)
at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:137)
at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:249)

d4rkfly3r · April 15, 2017, 5:33pm

If I remember correctly, MariaDB cannot have characters like the - sign in database names.

Tenelia · April 15, 2017, 5:57pm

Ah, but I can’t seem to change that name, can I??

d4rkfly3r · April 15, 2017, 6:28pm

I do not know for sure, but I’m guessing you can’t.

I’m pretty sure that the plugin author could create a check for invalid names and replace characters like the -,+,etc with an underscore.

I’m guessing that this is a valid reason for a ticket though.

Tenelia · April 16, 2017, 5:39am

Hmm, should I be submitting this ticket to Sponge or to RedProtect though? It seems like a problem if Sponge creates names that will have MySQL conflicts.

d4rkfly3r · April 16, 2017, 7:09am

Um no… DIM-1 is a Minecraft name, so unless you want to file a complaint to Mojang…?

Rather, the author of redprotect needs to sanitize the data being sent to the connector, and make sure it’s valid.

Tenelia · April 16, 2017, 7:21am

Ah thanks for clarifying