Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.03 KB | None | 0 0
  1. [10:41:44] [ INFO ] [DB] Returned 0 rows, 0 new pokemon
  2. [10:41:46] [ INFO ] [PokeNotifier] checking for pokemon to notify
  3. [10:41:46] [ INFO ] [DB] Getting new pokemon
  4. [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)
  5. [10:41:46] [ ERROR] [DB] Error executing getNewPokemon
  6. 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
  7. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  8. at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
  9. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
  10. at java.lang.reflect.Constructor.newInstance(Unknown Source)
  11. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  12. at com.mysql.jdbc.Util.getInstance(Util.java:408)
  13. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)
  14. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973)
  15. at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909)
  16. at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527)
  17. at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680)
  18. at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
  19. at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1858)
  20. at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1966)
  21. at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
  22. at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
  23. at com.github.novskey.novabot.data.DBManager.getNewPokemon(DBManager.java:1028)
  24. at com.github.novskey.novabot.data.DataManager.getNewPokemon(DataManager.java:283)
  25. at com.github.novskey.novabot.notifier.PokeNotifier.run(PokeNotifier.java:27)
  26. at com.github.novskey.novabot.core.ScheduledExecutor$LogOnExceptionRunnable.run(ScheduledExecutor.java:48)
  27. at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
  28. at java.util.concurrent.FutureTask.runAndReset(Unknown Source)
  29. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(Unknown Source)
  30. at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
  31. at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
  32. at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
  33. at java.lang.Thread.run(Unknown Source)
  34. [10:41:46] [ INFO ] [DB] Returned 0 rows, 0 new pokemon
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement