DiddiZ/LogBlock — Issue #76: TIME type in database for unline time tracking insufficient for tracking players with no live (i.e. Me)
Author: CyaNox
Created: 2012-01-27 19:46:37+00:00
State: open

20:45:22 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIX
TIME(1327693518), lastlogin)) WHERE playerid = 8;:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect time value: '839:22:40'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3591)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)
at de.diddiz.LogBlock.Consumer.run(Consumer.java:274)
at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
at java.lang.Thread.run(Thread.java:679)