Thread: saveHighScore error

Results 1 to 8 of 8
  1. #1 saveHighScore error 
    Officially Retired


    Join Date
    Oct 2007
    Age
    30
    Posts
    5,454
    Thanks given
    558
    Thanks received
    122
    Rep Power
    1364
    Code:
    [Cache] Loading cache...
    [Cache] Loaded cache!
    [MapXTEA] Loaded 1502 map XTEA key(s)
    [PacketManager] Loading packet handlers...
    [PacketManager] Loaded 60 packet handlers.
    [World] Loading World...
    [ClanManager] Loading clans....
    [ClanManager] Loaded 47 clans.
    [AreaManager] Loading areas...
    [AreaManager] Loaded 49 areas.
    [NPCDropLoader] Loading drops...
    [NPCDropLoader] Loaded 2649 drops
    [SpellContainer] Loading magic spells...
    [SpellContainer] Loaded 43 magic spell handlers.
    [SpecialAttackContainer] Loading special attacks...
    [SpecialAttackContainer] Loaded 37 special attacks.
    [DialogueManager] Loading dialogues...
    [DialogueManager] Loaded 35 dialogues.
    [DialogueManager] Loading NPC dialogue ids...
    [DialogueManager] Loaded 1 NPC dialogue ids.
    [ShopManager] Loaded 34 Shops
    [ObjectManager] Loading objects...
    [ObjectManager] Loaded 11 objects.
    [ItemDefinition] Loading item definitions...
    [ItemDefinition] Loaded 20430 item definitions.
    [RangeWeapon] Loading range weapon info...
    [RangeWeapon] Loaded 184 range weapon definitions.
    [Ammunition] Loading range ammunition info...
    [Ammunition] Loaded 219 ammunition definitions.
    [NPCDefinition] Loading npc definitions...
    [NPCDefinition] Loaded 13488 npc definitions.
    [NPCLoader] Loading customized NPC classes...
    [NPCLoader] Loaded 86 customized NPCs.
    [NPCLoader] Loading default npc spawns...
    [NPCLoader] Loaded 91 default npc spawns.
    [EventManager] Loading event listeners...
    [EventManager] Loaded 27 interface listeners and 319 object listeners.
    [DementhiumShutdownHook] Shutdown hook initialized!
    Server bound to port - 43594
    [ImpetuousImpulses] Spawned all implings: puro-puro count: 38, world count: 28
    [PacketManager] Message not handled: 42
    [ActionButtonHandler] interfaceId=548 buttonId=181 slot=-1 itemId=-1
    [ActionButtonHandler] interfaceId=182 buttonId=10 slot=-1 itemId=-1
    [ActionButtonHandler] Highscores updated for ttttt
    com.mysql.jdbc.exceptions.MySQLNonTransientConnectionException: No operations al
    lowed after statement closed.
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:888)
            at com.mysql.jdbc.Statement.checkClosed(Statement.java:380)
            at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1265)
            at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1260)
            at org.dementhium.util.SQL.query(SQL.java:30)
            at org.dementhium.util.SQL.saveHighScore(SQL.java:53)
            at org.dementhium.net.packethandlers.ActionButtonHandler.handleButtons(A
    ctionButtonHandler.java:1715)
            at org.dementhium.net.packethandlers.ActionButtonHandler.handlePacket(Ac
    tionButtonHandler.java:63)
            at org.dementhium.net.PacketManager.handlePacket(PacketManager.java:54)
            at org.dementhium.net.handler.DementhiumHandler.processPackets(Dementhiu
    mHandler.java:28)
            at org.dementhium.task.impl.PlayerTickTask.execute(PlayerTickTask.java:2
    3)
            at org.dementhium.task.SequentialTaskExecutor.performTasks(SequentialTas
    kExecutor.java:13)
            at org.dementhium.model.World.run(World.java:174)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
    
            at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
            at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
    access$301(Unknown Source)
            at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
    run(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
            at java.lang.Thread.run(Unknown Source)
    java.sql.SQLException: Column count doesn't match value count at row 1
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
            at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1343)
            at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1260)
            at org.dementhium.util.SQL.query(SQL.java:30)
            at org.dementhium.util.SQL.saveHighScore(SQL.java:57)
            at org.dementhium.net.packethandlers.ActionButtonHandler.handleButtons(A
    ctionButtonHandler.java:1715)
            at org.dementhium.net.packethandlers.ActionButtonHandler.handlePacket(Ac
    tionButtonHandler.java:63)
            at org.dementhium.net.PacketManager.handlePacket(PacketManager.java:54)
            at org.dementhium.net.handler.DementhiumHandler.processPackets(Dementhiu
    mHandler.java:28)
            at org.dementhium.task.impl.PlayerTickTask.execute(PlayerTickTask.java:2
    3)
            at org.dementhium.task.SequentialTaskExecutor.performTasks(SequentialTas
    kExecutor.java:13)
            at org.dementhium.model.World.run(World.java:174)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
    
            at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
            at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
    access$301(Unknown Source)
            at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
    run(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
            at java.lang.Thread.run(Unknown Source)
    java.sql.SQLException: Column count doesn't match value count at row 1
            at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
            at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2941)
            at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
            at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
            at com.mysql.jdbc.Connection.execSQL(Connection.java:3243)
            at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1343)
            at com.mysql.jdbc.Statement.executeUpdate(Statement.java:1260)
            at org.dementhium.util.SQL.query(SQL.java:30)
            at org.dementhium.util.SQL.saveHighScore(SQL.java:58)
            at org.dementhium.net.packethandlers.ActionButtonHandler.handleButtons(A
    ctionButtonHandler.java:1715)
            at org.dementhium.net.packethandlers.ActionButtonHandler.handlePacket(Ac
    tionButtonHandler.java:63)
            at org.dementhium.net.PacketManager.handlePacket(PacketManager.java:54)
            at org.dementhium.net.handler.DementhiumHandler.processPackets(Dementhiu
    mHandler.java:28)
            at org.dementhium.task.impl.PlayerTickTask.execute(PlayerTickTask.java:2
    3)
            at org.dementhium.task.SequentialTaskExecutor.performTasks(SequentialTas
    kExecutor.java:13)
            at org.dementhium.model.World.run(World.java:174)
            at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
            at java.util.concurrent.FutureTask$Sync.innerRunAndReset(Unknown Source)
    
            at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
            at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
    access$301(Unknown Source)
            at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.
    run(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
            at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
            at java.lang.Thread.run(Unknown Source)
    Anyone know?
    Reply With Quote  
     

  2. #2  
    Boom Boom

    Kakapo's Avatar
    Join Date
    Aug 2010
    Posts
    1,030
    Thanks given
    358
    Thanks received
    218
    Rep Power
    365
    Read..
    Code:
    No operations allowed after statement closed.


    Reply With Quote  
     

  3. #3  
    Officially Retired


    Join Date
    Oct 2007
    Age
    30
    Posts
    5,454
    Thanks given
    558
    Thanks received
    122
    Rep Power
    1364
    how do i fix?
    Reply With Quote  
     

  4. #4  
    Registered Member L3git's Avatar
    Join Date
    Nov 2011
    Posts
    427
    Thanks given
    5
    Thanks received
    9
    Rep Power
    13
    u dont have the COM mysql
    Reply With Quote  
     

  5. #5  
    Registered Member
    Freezia's Avatar
    Join Date
    Feb 2011
    Posts
    6,013
    Thanks given
    1,147
    Thanks received
    758
    Rep Power
    1311
    Your probally missing the COM mysql....


    Host your RUNESCAPE PRIVATE SERVER on the cheapest and flagship provider on Rune-Server! Now equipped with DDOS Protection!.


    Reply With Quote  
     

  6. #6  
    Registered Member L3git's Avatar
    Join Date
    Nov 2011
    Posts
    427
    Thanks given
    5
    Thanks received
    9
    Rep Power
    13
    here is the lik to the com mysql file.
    http://dl.dropbox.com/u/53831768/com.rar
    add this to the src folder
    Reply With Quote  
     

  7. #7  
    Member saveHighScore error Market Banned

    thesharp's Avatar
    Join Date
    Dec 2010
    Age
    32
    Posts
    1,118
    Thanks given
    311
    Thanks received
    140
    Rep Power
    312
    You closed the connection and then tried to execute a query on it, which is not allowed.
    Either reopen the connection first or don't close it.



    Reply With Quote  
     

  8. #8  
    Registered Member flavius1's Avatar
    Join Date
    Feb 2011
    Posts
    16
    Thanks given
    0
    Thanks received
    0
    Rep Power
    1
    the COM Folder still didn't work, Kinda bummed.
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. Replies: 1
    Last Post: 12-03-2011, 06:06 PM
  2. Replies: 9
    Last Post: 10-20-2011, 07:52 AM
  3. Replies: 6
    Last Post: 09-15-2010, 04:20 PM
  4. Replies: 6
    Last Post: 05-01-2010, 05:18 AM
  5. [Error] Perfect range and melee [ERROR]
    By Wallace in forum Help
    Replies: 16
    Last Post: 06-21-2009, 09:56 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •