DiddiZ/LogBlock — Issue #97: Time Value Error (For Playing Time Logging)
Author: DaneEveritt
Created: 2012-03-09 22:43:01+00:00
State: open

Getting this error below. Talked to md_5, confirmed to be some type of bug with logging player times.

```java
17:30:00 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET onlinetime = onlinetime + TIMESTAMPDIFF(SECOND, lastlogin, FROM_UNIXTIME('1331332199')) WHERE lastlogin > 0 && playerid = 78;:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect time value: '1.38873e+06' for column 'onlinetime' at row 1
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:292)
at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
at java.lang.Thread.run(Thread.java:679)
```