Menu

#3204 Stendhal 0.70: timothy's db problem

closed-fixed
None
5
2007-07-08
2007-07-06
No

15 INFO games.stendhal.server.StendhalRPRuleProcessor - No server extensions configured in ini file.
9524 INFO marauroa.server.marauroad - marauroa is up and running...
9526 INFO marauroa.server.game.Statistics - Total/Used memory: 40060/28811
10229 WARN marauroa.server.game.rp.RPServerManager - Turn duration overflow by 107 ms: 0 0 0 375 375 393 401 401 407 407 408
32595 ERROR marauroa.server.game.db.JDBCDatabase - Can't add player(timothyb89) character()
java.sql.SQLException: Unknown column 'data' in 'field list'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at marauroa.server.game.db.JDBCDatabase.storeRPObject(JDBCDatabase.java:1339)
at marauroa.server.game.db.JDBCDatabase.addCharacter(JDBCDatabase.java:528)
at games.stendhal.server.StendhalPlayerDatabase.addCharacter(StendhalPlayerDatabase.java:94)
at games.stendhal.server.StendhalRPRuleProcessor.createCharacter(StendhalRPRuleProcessor.java:652)
at marauroa.server.game.rp.RPServerManager.createCharacter(RPServerManager.java:258)
at marauroa.server.game.GameServerManager.processCreateCharacter(GameServerManager.java:790)
at marauroa.server.game.GameServerManager.run(GameServerManager.java:370)
32598 ERROR games.stendhal.server.StendhalRPRuleProcessor - Can't create character
java.sql.SQLException: Unknown column 'data' in 'field list'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2928)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2994)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:936)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1166)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1082)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1067)
at marauroa.server.game.db.JDBCDatabase.storeRPObject(JDBCDatabase.java:1339)
at marauroa.server.game.db.JDBCDatabase.addCharacter(JDBCDatabase.java:528)
at games.stendhal.server.StendhalPlayerDatabase.addCharacter(StendhalPlayerDatabase.java:94)
at games.stendhal.server.StendhalRPRuleProcessor.createCharacter(StendhalRPRuleProcessor.java:652)
at marauroa.server.game.rp.RPServerManager.createCharacter(RPServerManager.java:258)
at marauroa.server.game.GameServerManager.processCreateCharacter(GameServerManager.java:790)
at marauroa.server.game.GameServerManager.run(GameServerManager.java:370)
32600 ERROR marauroa.server.game.GameServerManager - Unable to create a character
marauroa.test.FailedException: Forced fail.
at marauroa.test.TestHelper.fail(TestHelper.java:12)
at games.stendhal.server.StendhalRPRuleProcessor.createCharacter(StendhalRPRuleProcessor.java:661)
at marauroa.server.game.rp.RPServerManager.createCharacter(RPServerManager.java:258)
at marauroa.server.game.GameServerManager.processCreateCharacter(GameServerManager.java:790)
at marauroa.server.game.GameServerManager.run(GameServerManager.java:370)
49579 INFO marauroa.server.net.nio.NIONetworkServerManager - NET Disconnecting java.nio.channels.SocketChannel[connected local=/127.0.0.1:32168 remote=/127.0.0.1:38885]
49579 INFO marauroa.server.game.GameServerManager - GAME Disconnecting java.nio.channels.SocketChannel[connected local=/127.0.0.1:32168 remote=/127.0.0.1:38885]
52330 WARN marauroa.server.game.rp.RPServerManager - Turn duration overflow by 130 ms: 0 0 0 415 415 415 424 424 430 430 430
69547 INFO marauroa.server.game.Statistics - Total/Used memory: 60372/33907
129550 INFO marauroa.server.game.Statistics - Total/Used memory: 60372/33929
189556 INFO marauroa.server.game.Statistics - Total/Used memory: 60372/37683
249562 INFO marauroa.server.game.Statistics - Total/Used memory: 60372/35233

Discussion

  • ChadF

    ChadF - 2007-07-07

    Logged In: YES
    user_id=1668474
    Originator: NO

    Already fixed. He used the old marauroa.jar on the new database once before replacing it, which created the old schema.

     
  • Miguel Angel Blanch Lardin

    • status: open --> closed-fixed
     

Anonymous
Anonymous

Add attachments
Cancel