[Arianne-bugs] [ arianne-Bugs-1756015 ] Error adding game event com.mysql.jdbc.MysqlDataTruncation

[SourceForge.net <no...@so...>]

Bugs item #1756015, was opened at 2007-07-18 12:54
Message generated for change (Comment added) made by arianne_rpg
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101111&aid=1756015&group_id=1111

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
>Resolution: Accepted
Priority: 5
Private: No
Submitted By: Katie (kymara)
>Assigned to: Miguel Angel Blanch Lardin (arianne_rpg)
Summary: Error adding game event com.mysql.jdbc.MysqlDataTruncation

Initial Comment:
2007-07-18 12:24:26 WARN  [verManager] RPServerManager               (459 ) - Turn duration overflow by 760 ms:  0 0 0 63 63 1034 1049 1049 1060 1060 1061
2007-07-18 12:24:38 WARN  [verManager] JDBCPlayerDatabase            (1460) - error adding game event
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'param2' at row 1
        at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:709)
        at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3410)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1804)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
        at com.mysql.jdbc.Statement.execute(Statement.java:529)
        at marauroa.server.game.JDBCPlayerDatabase.addGameEvent(JDBCPlayerDatabase.java:1457)
        at games.stendhal.server.StendhalRPRuleProcessor.addGameEvent(StendhalRPRuleProcessor.java:168)
        at games.stendhal.server.actions.ChatAction.onTell(ChatAction.java:191)
        at games.stendhal.server.actions.ChatAction.onAction(ChatAction.java:69)
        at games.stendhal.server.StendhalRPRuleProcessor.execute(StendhalRPRuleProcessor.java:402)
        at marauroa.server.game.RPScheduler.visit(RPScheduler.java:154)
        at marauroa.server.game.RPServerManager.run(RPServerManager.java:489)
2007-07-18 12:24:38 WARN  [verManager] StendhalRPRuleProcessor       (171 ) - Can't store game event
marauroa.server.game.GenericDatabaseException: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'param2' at row 1
        at marauroa.server.game.JDBCPlayerDatabase.addGameEvent(JDBCPlayerDatabase.java:1461)
        at games.stendhal.server.StendhalRPRuleProcessor.addGameEvent(StendhalRPRuleProcessor.java:168)
        at games.stendhal.server.actions.ChatAction.onTell(ChatAction.java:191)
        at games.stendhal.server.actions.ChatAction.onAction(ChatAction.java:69)
        at games.stendhal.server.StendhalRPRuleProcessor.execute(StendhalRPRuleProcessor.java:402)
        at marauroa.server.game.RPScheduler.visit(RPScheduler.java:154)
        at marauroa.server.game.RPServerManager.run(RPServerManager.java:489)
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'param2' at row 1
        at com.mysql.jdbc.SQLError.convertShowWarningsToSQLWarnings(SQLError.java:709)
        at com.mysql.jdbc.MysqlIO.scanForAndThrowDataTruncation(MysqlIO.java:3410)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1804)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2988)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:2917)
        at com.mysql.jdbc.Statement.execute(Statement.java:529)
        at marauroa.server.game.JDBCPlayerDatabase.addGameEvent(JDBCPlayerDatabase.java:1457)


----------------------------------------------------------------------

>Comment By: Miguel Angel Blanch Lardin (arianne_rpg)
Date: 2007-07-20 10:10

Message:
Logged In: YES 
user_id=3949
Originator: NO

I think hendrik changed the size of param2 in the hope of using less disk
space.
I fix this error but it is not important anyway.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=101111&aid=1756015&group_id=1111