On start error.

Create issue
Issue #279 resolved
Liger XT5 created an issue

Updated to newest release, been using Stats 3. On start, receiving this error.

[10:43:27] [Server thread/ERROR]: null
nl.lolmewn.stats.api.storage.StorageException: Could not check if conversion was done properly
   at nl.lolmewn.stats.mysql.MySQLStorage.fixConversionError(MySQLStorage.java:480) ~[?:?]
   at nl.lolmewn.stats.mysql.MySQLStorage.lambda$enable$77(MySQLStorage.java:447) ~[?:?]
   at org.bukkit.craftbukkit.v1_9_R1.scheduler.CraftTask.run(CraftTask.java:71) [Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at org.bukkit.craftbukkit.v1_9_R1.scheduler.CraftScheduler.mainThreadHeartbeat(CraftScheduler.java:350) [Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at net.minecraft.server.v1_9_R1.MinecraftServer.D(MinecraftServer.java:729) [Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at net.minecraft.server.v1_9_R1.DedicatedServer.D(DedicatedServer.java:400) [Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at net.minecraft.server.v1_9_R1.MinecraftServer.C(MinecraftServer.java:660) [Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at net.minecraft.server.v1_9_R1.MinecraftServer.run(MinecraftServer.java:559) [Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at java.lang.Thread.run(Thread.java:745) [?:1.8.0_92]
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: COLLATION 'latin1_general_cs' is not valid for CHARACTER SET 'utf8'
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:1.8.0_92]
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:1.8.0_92]
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:1.8.0_92]
   at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[?:1.8.0_92]
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at com.mysql.jdbc.Util.getInstance(Util.java:387) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:941) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3870) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3806) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2470) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2617) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2546) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2504) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1370) ~[Spigot.jar:git-Spigot-e6f93f4-ed60c01]
   at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) ~[?:?]
   at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207) ~[?:?]
   at nl.lolmewn.stats.mysql.MySQLStorage.fixConversionForDeath(MySQLStorage.java:523) ~[?:?]
   at nl.lolmewn.stats.mysql.MySQLStorage.fixConversionError(MySQLStorage.java:476) ~[?:?]
   ... 8 more

Comments (8)

  1. Sybren Gjaltema repo owner

    I need you to open a MySQL terminal and give me the output of the following two queries:

    show collation;

    show character set;

  2. Sean Kim

    I am receiving the same error but I have deleted all of the tables. Basically, I don't have any past data that should intefere with the plugin.

  3. Sybren Gjaltema repo owner
    • changed status to open

    Looking into this issue. Was not able to reproduce but this is likely due to a different MySQL version or installment.

  4. Sean Kim

    I have done some testing and it seems that only stats3.1.0 is the only one generating the error. Does this information help?

  5. Log in to comment