{"issue":{"pull_request":{"diff_url":null,"html_url":null,"patch_url":null},"state":"open","user":{"avatar_url":"https://secure.gravatar.com/avatar/c36ddddf7079e6e79d446e72ed19d4b3?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"c36ddddf7079e6e79d446e72ed19d4b3","url":"https://api.github.com/users/DmnNcls","login":"DmnNcls","id":1184801},"milestone":null,"assignee":null,"updated_at":"2011-11-12T15:29:19Z","labels":[],"closed_at":null,"comments":1,"url":"https://api.github.com/repos/DiddiZ/LogBlock/issues/37","body":"2011-11-11 01:46:55 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET lastlogin = FROM_UNIXTIME(1320972412), firstlogin = IF(firstlogin = 0, FROM_UNIXTIME(1320972412), firstlogin), ip = '/109.215.106.112:50782' WHERE playerid = 34;:\r\ncom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'lastlogin' in 'field list'\r\nat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\r\nat sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)\r\nat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)\r\nat java.lang.reflect.Constructor.newInstance(Unknown Source)\r\nat com.mysql.jdbc.Util.handleNewInstance(Util.java:407)\r\nat com.mysql.jdbc.Util.getInstance(Util.java:382)\r\nat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)\r\nat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)\r\nat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)\r\nat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)\r\nat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)\r\nat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)\r\nat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)\r\nat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)\r\nat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)\r\nat de.diddiz.LogBlock.Consumer.run(Consumer.java:276)\r\nat org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)\r\nat java.lang.Thread.run(Unknown Source)\r\n\r\n2011-11-11 01:46:35 [SEVERE] [LogBlock Consumer] SQL exception on UPDATE `lb-players` SET onlinetime = ADDTIME(onlinetime, TIMEDIFF(FROM_UNIXTIME(1320972390), lastlogin)) WHERE playerid = 34;:\r\ncom.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'onlinetime' in 'field list'\r\nat sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\r\nat sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)\r\nat sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)\r\nat java.lang.reflect.Constructor.newInstance(Unknown Source)\r\nat com.mysql.jdbc.Util.handleNewInstance(Util.java:407)\r\nat com.mysql.jdbc.Util.getInstance(Util.java:382)\r\nat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)\r\nat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)\r\nat com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)\r\nat com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)\r\nat com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)\r\nat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2620)\r\nat com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2570)\r\nat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:779)\r\nat com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:622)\r\nat de.diddiz.LogBlock.Consumer.run(Consumer.java:276)\r\nat org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)\r\nat java.lang.Thread.run(Unknown Source)\r\n\r\nhow i can fix that? i dont understand what is this bug\r\n\r\ncraftbukkit 1337\r\nspout 510\r\ncauth 1.4\r\nlogblock 1.4","html_url":"https://github.com/DiddiZ/LogBlock/issues/37","title":"SQL exception on UPDATE","number":37,"id":2205078,"created_at":"2011-11-11T00:59:28Z"},"action":"created","comment":{"user":{"avatar_url":"https://secure.gravatar.com/avatar/bb7e420dac793e636ada4510efca7c0d?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"bb7e420dac793e636ada4510efca7c0d","url":"https://api.github.com/users/DiddiZ","login":"DiddiZ","id":645819},"updated_at":"2011-11-12T15:29:19Z","url":"https://api.github.com/repos/DiddiZ/LogBlock/issues/comments/2717886","body":"Auto updater fail. \r\nSet version in config to '1.30' and restart.","id":2717886,"created_at":"2011-11-12T15:29:19Z"}}