Plugin error: Stored procedure failed #100


  • New
  • Defect
Open
Assigned to _ForgeUser2779866
  • _ForgeUser4882315 created this issue Oct 26, 2012

    What steps will reproduce the problem?
    1. Reloading the server
    2. Starting the server
    3. blockplacing, joining, blockbreaking etc.....

    What is the expected output? What do you see instead?
    none

    What version of the product are you using?
    current version

    Do you have an error log of what happened?

    That is what happens if i load up the server:
    2012-10-26 13:26:50 [WARNING] [Statistician] CALL `statistik`.pluginStartup(); :: Stored procedure failed, checking connection... (PROCEDURE statistik.pluginStartup does not exist)
    2012-10-26 13:26:50 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: PROCEDURE statistik.pluginStartup does not exist
    2012-10-26 13:26:50 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2012-10-26 13:26:50 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2012-10-26 13:26:50 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2012-10-26 13:26:50 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
    2012-10-26 13:26:50 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
    2012-10-26 13:26:50 [SEVERE]     at com.ChaseHQ.Statistician.Database.Database.callStoredProcedure(Database.java:117)
    2012-10-26 13:26:50 [SEVERE]     at com.ChaseHQ.Statistician.StatisticianPlugin.onEnable(StatisticianPlugin.java:72)
    2012-10-26 13:26:50 [SEVERE]     at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
    2012-10-26 13:26:50 [SEVERE]     at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:365)
    2012-10-26 13:26:50 [SEVERE]     at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
    2012-10-26 13:26:50 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:265)
    2012-10-26 13:26:50 [SEVERE]     at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:247)
    2012-10-26 13:26:50 [SEVERE]     at net.minecraft.server.MinecraftServer.i(MinecraftServer.java:296)
    2012-10-26 13:26:50 [SEVERE]     at net.minecraft.server.MinecraftServer.d(MinecraftServer.java:275)
    2012-10-26 13:26:50 [SEVERE]     at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:225)
    2012-10-26 13:26:50 [SEVERE]     at net.minecraft.server.DedicatedServer.init(DedicatedServer.java:140)
    2012-10-26 13:26:50 [SEVERE]     at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:378)
    2012-10-26 13:26:50 [SEVERE]     at net.minecraft.server.ThreadServerApplication.run(SourceFile:539)
    2012-10-26 13:26:50 [INFO] [Statistician] Connection is still present, it may of been a malformed query.

    joining player results in this:
    2012-10-26 13:27:00 [INFO] omega79[/171.4.12.86:29782] logged in with entity id 554 at ([Crafters-United] -1475.7499778269425, 76.0, -14005.142097675085)
    2012-10-26 13:27:00 [INFO] [VanishNoPacket] omega79 disappeared.
    2012-10-26 13:27:01 [WARNING] [Statistician] CALL `statistik`.loginPlayer('e6fe5447-09df-466e-9c21-0647859efc20'); :: Stored procedure failed, checking connection... (PROCEDURE statistik.loginPlayer does not exist)
    2012-10-26 13:27:01 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: PROCEDURE statistik.loginPlayer does not exist
    2012-10-26 13:27:01 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2012-10-26 13:27:01 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2012-10-26 13:27:01 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2012-10-26 13:27:01 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2012-10-26 13:27:01 [WARNING] [PrefixedPlayerlist]: Prefix '§9C§f§4§6[O]' for player 'omega79' is too long (>10)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
    2012-10-26 13:27:01 [SEVERE]     at com.ChaseHQ.Statistician.Database.Database.callStoredProcedure(Database.java:117)
    2012-10-26 13:27:01 [SEVERE]     at com.ChaseHQ.Statistician.Database.DBSynchDataGetSet.playerLogin(DBSynchDataGetSet.java:175)
    2012-10-26 13:27:01 [SEVERE]     at com.ChaseHQ.Statistician.EventDataHandlers.EDHPlayer$4.run(EDHPlayer.java:57)
    2012-10-26 13:27:01 [SEVERE]     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    2012-10-26 13:27:01 [SEVERE]     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    2012-10-26 13:27:01 [SEVERE]     at java.lang.Thread.run(Thread.java:636)
    2012-10-26 13:27:01 [INFO] [Statistician] Connection is still present, it may of been a malformed query.
    2012-10-26 13:27:01 [WARNING] [Statistician] CALL `statistik`.updateMostEverOnline(); :: Stored procedure failed, checking connection... (PROCEDURE statistik.updateMostEverOnline does not exist)
    2012-10-26 13:27:01 [SEVERE] com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: PROCEDURE statistik.updateMostEverOnline does not exist
    2012-10-26 13:27:01 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    2012-10-26 13:27:01 [SEVERE]     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    2012-10-26 13:27:01 [SEVERE]     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    2012-10-26 13:27:01 [SEVERE]     at java.lang.reflect.Constructor.newInstance(Constructor.java:532)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.Util.getInstance(Util.java:382)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1662)
    2012-10-26 13:27:01 [SEVERE]     at com.mysql.jdbc.StatementImpl.executeUpdate(StatementImpl.java:1581)
    2012-10-26 13:27:01 [SEVERE]     at com.ChaseHQ.Statistician.Database.Database.callStoredProcedure(Database.java:117)
    2012-10-26 13:27:01 [SEVERE]     at com.ChaseHQ.Statistician.EventDataHandlers.EDHPlayer$4.run(EDHPlayer.java:75)
    2012-10-26 13:27:01 [SEVERE]     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
    2012-10-26 13:27:01 [SEVERE]     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
    2012-10-26 13:27:01 [SEVERE]     at java.lang.Thread.run(Thread.java:636)
    2012-10-26 13:27:01 [INFO] [Statistician] Connection is still present, it may of been a malformed query.

    Please provide any additional information below.
    I just did setup a new system on my root ... imported the databasebackup ...
    for logblock and the other plugins it seemed to work but not for statistican

  • _ForgeUser4882315 added the tags New Defect Oct 26, 2012

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