Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- [10:41:44] [ INFO ] [DB] Returned 0 rows, 0 new pokemon
- [10:41:46] [ INFO ] [PokeNotifier] checking for pokemon to notify
- [10:41:46] [ INFO ] [DB] Getting new pokemon
- [10:41:46] [ INFO ] [DB] Executing query:com.mysql.jdbc.JDBC42PreparedStatement@429b449a: SELECT pokemon_id, lat, lon, expire_timestamp, atk_iv, def_iv, sta_iv, move_1, move_2, gender, form, cp, level, weather_boosted_condition FROM sightings WHERE pokemon_id NOT IN null AND updated >= UNIX_TIMESTAMP('2018-01-23 10:41:44.897' - INTERVAL 1 SECOND)AND expire_timestamp > UNIX_TIMESTAMP(now() - INTERVAL '60' SECOND)
- [10:41:46] [ ERROR] [DB] Error executing getNewPokemon
- com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'null AND updated >= UNIX_TIMESTAMP('2018-01-23 10:41:44.897' - INTERVAL 1 SECOND' at line 1
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
- at java.lang.reflect.Constructor.newInstance(Unknown Source)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
- at com.mysql.jdbc.Util.getInstance(Util.java:408)
- at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
- at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
- at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
- at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
- at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
- at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
- at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
- at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
- at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
- at com.github.novskey.novabot.data.DBManager.getNewPokemon(DBManager.java:1028)
- at com.github.novskey.novabot.data.DataManager.getNewPokemon(DataManager.java:283)
- at com.github.novskey.novabot.notifier.PokeNotifier.run(PokeNotifier.java:27)
- at com.github.novskey.novabot.core.ScheduledExecutor$LogOnExceptionRunnable.run(ScheduledExecutor.java:48)
- at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
- at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
- at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
- at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
- at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
- at java.lang.Thread.run(Unknown Source)
- [10:41:46] [ INFO ] [DB] Returned 0 rows, 0 new pokemon
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement