An error occured while executing the database patch v10 #90


  • New
  • Defect
Open
Assigned to _ForgeUser2779866
  • _ForgeUser7692978 created this issue Aug 22, 2012

    I upgrade Statistician v2.0.10 to Statistician v2.0.12 and i get much errors:

    2012-08-22 17:25:36 [INFO] [Statistician] Enabling Statistician v2.0.12
    2012-08-22 17:25:36 [INFO] [Statistician] Patching database from v9 to v10.
    2012-08-22 17:25:36 [SEVERE] [Statistician] Critical Error, could not connect to mySQL. Is the database Available? Check config file and try again. (An error occured
    while executing the database patch v10.)
    2012-08-22 17:25:36 [SEVERE] An error occured while executing the database patch v10.
    2012-08-22 17:25:36 [SEVERE]    at com.ChaseHQ.Statistician.Database.Database.patchDB(Database.java:193)
    2012-08-22 17:25:36 [SEVERE]    at com.ChaseHQ.Statistician.Database.Database.<init>(Database.java:29)
    2012-08-22 17:25:36 [SEVERE]    at com.ChaseHQ.Statistician.StatisticianPlugin.onEnable(StatisticianPlugin.java:51)
    2012-08-22 17:25:36 [SEVERE]    at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
    2012-08-22 17:25:36 [SEVERE]    at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:365)
    2012-08-22 17:25:36 [SEVERE]    at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
    2012-08-22 17:25:36 [SEVERE]    at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:265)
    2012-08-22 17:25:36 [SEVERE]    at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:247)
    2012-08-22 17:25:36 [SEVERE]    at net.minecraft.server.MinecraftServer.i(MinecraftServer.java:296)
    2012-08-22 17:25:36 [SEVERE]    at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:275)
    2012-08-22 17:25:36 [SEVERE]    at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:225)
    2012-08-22 17:25:36 [SEVERE]    at net.minecraft.server.DedicatedServer.init(DedicatedServer.java:140)
    2012-08-22 17:25:36 [SEVERE]    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:378)
    2012-08-22 17:25:36 [SEVERE]    at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
    2012-08-22 17:25:36 [SEVERE] Caused by: com.ChaseHQ.Statistician.Database.RuntimeSqlException: Error executing: /*
    * Update for Minecraft 1.3.1
    */
    INSERT INTO `resource_desc` VALUES ('125', 'Wooden Double Slab')
    .  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '125' for key 'PRIMARY'
    2012-08-22 17:25:36 [SEVERE]    at com.ChaseHQ.Statistician.Database.ScriptRunner.executeLineByLine(ScriptRunner.java:136)
    2012-08-22 17:25:36 [SEVERE]    at com.ChaseHQ.Statistician.Database.ScriptRunner.runScript(ScriptRunner.java:98)
    2012-08-22 17:25:36 [SEVERE]    at com.ChaseHQ.Statistician.Database.Database.patchDB(Database.java:191)
    2012-08-22 17:25:36 [SEVERE]    ... 13 more
    2012-08-22 17:25:36 [SEVERE] Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicate entry '125' for key 'PRIMARY'
    2012-08-22 17:25:36 [SEVERE]    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2012-08-22 17:25:36 [SEVERE]    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    2012-08-22 17:25:36 [SEVERE]    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    2012-08-22 17:25:36 [SEVERE]    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
    2012-08-22 17:25:36 [SEVERE]    at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
    2012-08-22 17:25:36 [SEVERE]    at com.ChaseHQ.Statistician.Database.ScriptRunner.executeStatement(ScriptRunner.java:217)
    2012-08-22 17:25:36 [SEVERE]    at com.ChaseHQ.Statistician.Database.ScriptRunner.handleLine(ScriptRunner.java:192)
    2012-08-22 17:25:36 [SEVERE]    at com.ChaseHQ.Statistician.Database.ScriptRunner.executeLineByLine(ScriptRunner.java:129)
    2012-08-22 17:25:36 [SEVERE]    ... 15 more
    2012-08-22 17:25:36 [INFO] [Statistician] Disabling Statistician v2.0.12

    Bukkit is Version 1.3.1-R2.0.

    Any ideas whats wrong?

  • _ForgeUser7692978 added the tags New Defect Aug 22, 2012

To post a comment, please login or register a new account.