MysticCity / MinigamesAPI

Rich MinigamesAPI supporting different types of Minigames
20 stars 15 forks source link

Mysql Wrong #358

Open AaronHzy opened 6 years ago

AaronHzy commented 6 years ago

MinigamesLibBungee-2.0.0 MinigamesLib-1.14.17 MGSplegg-1.14.17 PaperSpigot-1.11.2-b1104

After the game,Unable to save player data [MinigamesLib] exception com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ''player', 'points', 'wins', 'loses', 'kills', 'deaths', 'uuid', 'gamepoints') VA' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_152] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_152] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_152] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_152] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1540) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2595) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1468) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.comze_instancelabs.minigamesapi.sql.MainSQL.updateDeathStats(MainSQL.java:434) ~[?:?] at com.comze_instancelabs.minigamesapi.sql.MainSQL.updateDeathStats(MainSQL.java:397) ~[?:?] at com.comze_instancelabs.minigamesapi.Stats.updateSQLKillsDeathsAfter(Stats.java:153) ~[?:?] at com.comze_instancelabs.minigamesapi.Arena.lambda$leavePlayerRaw$13(Arena.java:1344) ~[?:?] at org.bukkit.craftbukkit.v1_11_R1.scheduler.CraftTask.run(CraftTask.java:58) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at org.bukkit.craftbukkit.v1_11_R1.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:356) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at net.minecraft.server.v1_11_R1.MinecraftServer.D(MinecraftServer.java:829) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:403) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:763) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:661) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_152] [18:25:19 WARN]: [MinigamesLib] exception com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ''player', 'points', 'wins', 'loses', 'kills', 'deaths', 'uuid', 'gamepoints') VA' at line 1 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_152] at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_152] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_152] at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_152] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:943) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3970) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3906) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2524) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2677) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2545) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.StatementImpl.executeUpdateInternal(StatementImpl.java:1540) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.StatementImpl.executeLargeUpdate(StatementImpl.java:2595) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1468) ~[PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at com.comze_instancelabs.minigamesapi.sql.MainSQL.updateLosterStats(MainSQL.java:306) ~[?:?] at com.comze_instancelabs.minigamesapi.sql.MainSQL.updateLoserStats(MainSQL.java:270) ~[?:?] at com.comze_instancelabs.minigamesapi.Stats.lose(Stats.java:95) ~[?:?] at com.comze_instancelabs.minigamesapi.Rewards.giveWinReward(Rewards.java:384) ~[?:?] at com.comze_instancelabs.minigamesapi.Arena.lambda$leavePlayerRaw$13(Arena.java:1347) ~[?:?] at org.bukkit.craftbukkit.v1_11_R1.scheduler.CraftTask.run(CraftTask.java:58) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at org.bukkit.craftbukkit.v1_11_R1.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:356) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at net.minecraft.server.v1_11_R1.MinecraftServer.D(MinecraftServer.java:829) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at net.minecraft.server.v1_11_R1.DedicatedServer.D(DedicatedServer.java:403) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at net.minecraft.server.v1_11_R1.MinecraftServer.C(MinecraftServer.java:763) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at net.minecraft.server.v1_11_R1.MinecraftServer.run(MinecraftServer.java:661) [PaperSpigot-1.11.2-b1104.jar:git-Paper-1104] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_152]