Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Exception in build 112 #111

Closed
ZathrasNotTheOne opened this issue Mar 31, 2012 · 2 comments
Closed

SQL Exception in build 112 #111

ZathrasNotTheOne opened this issue Mar 31, 2012 · 2 comments

Comments

@ZathrasNotTheOne
Copy link

02:08:49 [INFO] Starting minecraft server version 1.2.4
02:08:49 [INFO] Loading properties
02:08:49 [INFO] Starting Minecraft server on *:25565
02:08:49 [INFO] This server is running CraftBukkit version git-Bukkit-1.2.4-R1.0-b2126jnks (MC: 1.2.4) (Implementing API version 1.2.4-R1.0)
...
02:08:50 [INFO] [LogBlock] Loading LogBlock v1.52
02:08:51 [INFO] [LogBlock] [LogBlock] Version check: Your version is up to date
02:08:51 [INFO] [LogBlock] [LogBlock] Connecting to root@jdbc:mysql://localhost:3306/minecraft...

Upon logout, this might occur...

02:47:12 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE lb-players SET onlinetime = onlinetime + TIMESTAMPDIFF(SECOND, lastlogin, FROM_UNIXTIME('1333176423')) WHERE lastlogin > 0 && playerid = 1;:
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect time value: '4.23623e+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:680)

@DiddiZ
Copy link
Member

DiddiZ commented Mar 31, 2012

It's the same as:
https://github.com/DiddiZ/LogBlock/issues/97

Either change the columns data type manually to INT, or set version in config to '1.51' to make the autoupdater work.

@DiddiZ DiddiZ closed this as completed Mar 31, 2012
@ZathrasNotTheOne
Copy link
Author

Setting to 1.51 re-ran the updater and I verified that the field is now an INT. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants