Guest User

Untitled

a guest
Oct 13th, 2019
80
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [23:36:02] [Plan WebServer Thread-3/ERROR]: [Plan] Error was caught by com.djrapitops.plan.delivery.webserver.ResponseHandler
  2. com.djrapitops.plan.exceptions.database.DBOpException: SQL Failed: SELECT * FROM (SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group) selectMultiple; (Message HY004 not found); SQL statement:
  3. SELECT * FROM (SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group) selectMultiple [50004-199]
  4. at com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:37) ~[?:?]
  5. at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:55) ~[?:?]
  6. at com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:228) ~[?:?]
  7. at com.djrapitops.plan.delivery.rendering.json.graphs.GraphJSONParser.activityGraphsJSONAsMap(GraphJSONParser.java:199) ~[?:?]
  8. at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.generateGraphDataJSONOfType(GraphsJSONHandler.java:102) ~[?:?]
  9. at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.lambda$getResponse$1(GraphsJSONHandler.java:67) ~[?:?]
  10. at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:52) ~[?:?]
  11. at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:75) ~[?:?]
  12. at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.getResponse(GraphsJSONHandler.java:67) ~[?:?]
  13. at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler$1.getResponse(TreePageHandler.java:54) ~[?:?]
  14. at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler.getResponse(TreePageHandler.java:81) ~[?:?]
  15. at com.djrapitops.plan.delivery.webserver.ResponseHandler.tryToGetResponse(ResponseHandler.java:147) ~[?:?]
  16. at com.djrapitops.plan.delivery.webserver.ResponseHandler.getResponse(ResponseHandler.java:94) ~[?:?]
  17. at com.djrapitops.plan.delivery.webserver.RequestHandler.handle(RequestHandler.java:99) ~[?:?]
  18. at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
  19. at sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83) ~[?:1.8.0_222]
  20. at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:82) ~[?:1.8.0_222]
  21. at sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:675) ~[?:1.8.0_222]
  22. at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
  23. at sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:647) ~[?:1.8.0_222]
  24. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_222]
  25. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_222]
  26. at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
  27. Caused by: plan.org.h2.jdbc.JdbcSQLNonTransientException: (Message HY004 not found); SQL statement:
  28. SELECT * FROM (SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group UNION SELECT activity_group, COUNT(1) as count FROM (SELECT ? as activity_group, activity_index FROM plan_user_info u LEFT JOIN (SELECT 5.0 - 5.0 * AVG(1 / (?/2 * (q1.active_playtime/?) +1)) as activity_index,q1.uuid FROM (SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid UNION SELECT uuid,SUM(session_end-session_start-afk_time) as active_playtime FROM plan_sessions WHERE server_uuid=? AND session_start>=? AND session_end<=? GROUP BY uuid) q1 GROUP BY q1.uuid) s on s.uuid=u.uuid WHERE u.server_uuid=? AND u.registered<=?) indexes WHERE COALESCE(indexes.activity_index,0)>=? AND COALESCE(indexes.activity_index,0)<? GROUP BY activity_group) selectMultiple [50004-199]
  29. at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:502) ~[?:?]
  30. at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:427) ~[?:?]
  31. at plan.org.h2.message.DbException.get(DbException.java:205) ~[?:?]
  32. at plan.org.h2.message.DbException.get(DbException.java:181) ~[?:?]
  33. at plan.org.h2.table.Table.setColumns(Table.java:442) ~[?:?]
  34. at plan.org.h2.table.TableView.initColumnsAndTables(TableView.java:239) ~[?:?]
  35. at plan.org.h2.table.TableView.init(TableView.java:112) ~[?:?]
  36. at plan.org.h2.table.TableView.<init>(TableView.java:71) ~[?:?]
  37. at plan.org.h2.table.TableView.createTempView(TableView.java:551) ~[?:?]
  38. at plan.org.h2.command.Parser.readTableFilter(Parser.java:1830) ~[?:?]
  39. at plan.org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2641) ~[?:?]
  40. at plan.org.h2.command.Parser.parseSelectSimple(Parser.java:2788) ~[?:?]
  41. at plan.org.h2.command.Parser.parseSelectSub(Parser.java:2636) ~[?:?]
  42. at plan.org.h2.command.Parser.parseSelectUnion(Parser.java:2469) ~[?:?]
  43. at plan.org.h2.command.Parser.readTableFilter(Parser.java:1819) ~[?:?]
  44. at plan.org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2641) ~[?:?]
  45. at plan.org.h2.command.Parser.parseSelectSimple(Parser.java:2788) ~[?:?]
  46. at plan.org.h2.command.Parser.parseSelectSub(Parser.java:2636) ~[?:?]
  47. at plan.org.h2.command.Parser.parseSelectUnion(Parser.java:2469) ~[?:?]
  48. at plan.org.h2.command.Parser.parseSelect(Parser.java:2440) ~[?:?]
  49. at plan.org.h2.command.Parser.parsePrepared(Parser.java:814) ~[?:?]
  50. at plan.org.h2.command.Parser.parse(Parser.java:788) ~[?:?]
  51. at plan.org.h2.command.Parser.parse(Parser.java:760) ~[?:?]
  52. at plan.org.h2.command.Parser.prepareCommand(Parser.java:683) ~[?:?]
  53. at plan.org.h2.engine.Session.prepareLocal(Session.java:627) ~[?:?]
  54. at plan.org.h2.engine.Session.prepareCommand(Session.java:565) ~[?:?]
  55. at plan.org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1292) ~[?:?]
  56. at plan.org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:77) ~[?:?]
  57. at plan.org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:349) ~[?:?]
  58. at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:51) ~[?:?]
  59. ... 21 more
  60. [23:36:02] [Plan WebServer Thread-4/ERROR]: [Plan] Error was caught by com.djrapitops.plan.delivery.webserver.ResponseHandler
  61. com.djrapitops.plan.exceptions.database.DBOpException: SQL Failed: SELECT geolocation, COUNT(1) as c FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN plan_user_info u on u.uuid=q1.uuid) WHERE last_used=m AND u.server_uuid=? GROUP BY geolocation; (Message 42001 not found); SQL statement:
  62. SELECT geolocation, COUNT(1) as c FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN plan_user_info u on u.uuid=q1.uuid) WHERE last_used=m AND u.server_uuid=? GROUP BY geolocation [42001-199]
  63. at com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:37) ~[?:?]
  64. at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:55) ~[?:?]
  65. at com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:228) ~[?:?]
  66. at com.djrapitops.plan.delivery.rendering.json.graphs.GraphJSONParser.geolocationGraphsJSONAsMap(GraphJSONParser.java:236) ~[?:?]
  67. at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.generateGraphDataJSONOfType(GraphsJSONHandler.java:104) ~[?:?]
  68. at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.lambda$getResponse$1(GraphsJSONHandler.java:67) ~[?:?]
  69. at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:52) ~[?:?]
  70. at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:75) ~[?:?]
  71. at com.djrapitops.plan.delivery.webserver.pages.json.GraphsJSONHandler.getResponse(GraphsJSONHandler.java:67) ~[?:?]
  72. at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler$1.getResponse(TreePageHandler.java:54) ~[?:?]
  73. at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler.getResponse(TreePageHandler.java:81) ~[?:?]
  74. at com.djrapitops.plan.delivery.webserver.ResponseHandler.tryToGetResponse(ResponseHandler.java:147) ~[?:?]
  75. at com.djrapitops.plan.delivery.webserver.ResponseHandler.getResponse(ResponseHandler.java:94) ~[?:?]
  76. at com.djrapitops.plan.delivery.webserver.RequestHandler.handle(RequestHandler.java:99) ~[?:?]
  77. at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
  78. at sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83) ~[?:1.8.0_222]
  79. at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:82) ~[?:1.8.0_222]
  80. at sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:675) ~[?:1.8.0_222]
  81. at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
  82. at sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:647) ~[?:1.8.0_222]
  83. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_222]
  84. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_222]
  85. at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
  86. Caused by: plan.org.h2.jdbc.JdbcSQLSyntaxErrorException: (Message 42001 not found); SQL statement:
  87. SELECT geolocation, COUNT(1) as c FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN plan_user_info u on u.uuid=q1.uuid) WHERE last_used=m AND u.server_uuid=? GROUP BY geolocation [42001-199]
  88. at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:451) ~[?:?]
  89. at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:427) ~[?:?]
  90. at plan.org.h2.message.DbException.getSyntaxError(DbException.java:243) ~[?:?]
  91. at plan.org.h2.command.Parser.getSyntaxError(Parser.java:991) ~[?:?]
  92. at plan.org.h2.command.Parser.read(Parser.java:4549) ~[?:?]
  93. at plan.org.h2.command.Parser.readTableFilter(Parser.java:1820) ~[?:?]
  94. at plan.org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2641) ~[?:?]
  95. at plan.org.h2.command.Parser.parseSelectSimple(Parser.java:2788) ~[?:?]
  96. at plan.org.h2.command.Parser.parseSelectSub(Parser.java:2636) ~[?:?]
  97. at plan.org.h2.command.Parser.parseSelectUnion(Parser.java:2469) ~[?:?]
  98. at plan.org.h2.command.Parser.parseSelect(Parser.java:2440) ~[?:?]
  99. at plan.org.h2.command.Parser.parsePrepared(Parser.java:814) ~[?:?]
  100. at plan.org.h2.command.Parser.parse(Parser.java:788) ~[?:?]
  101. at plan.org.h2.command.Parser.parse(Parser.java:764) ~[?:?]
  102. at plan.org.h2.command.Parser.prepareCommand(Parser.java:683) ~[?:?]
  103. at plan.org.h2.engine.Session.prepareLocal(Session.java:627) ~[?:?]
  104. at plan.org.h2.engine.Session.prepareCommand(Session.java:565) ~[?:?]
  105. at plan.org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1292) ~[?:?]
  106. at plan.org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:77) ~[?:?]
  107. at plan.org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:349) ~[?:?]
  108. at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:51) ~[?:?]
  109. ... 21 more
  110. [23:36:02] [Plan WebServer Thread-4/ERROR]: [Plan] Error was caught by com.djrapitops.plan.delivery.webserver.ResponseHandler
  111. com.djrapitops.plan.exceptions.database.DBOpException: SQL Failed: SELECT geolocation, MIN(min_ping) as minPing, MAX(max_ping) as maxPing, AVG(avg_ping) as avgPing FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN (SELECT max_ping, min_ping, avg_ping, uuid, server_uuid FROM plan_ping) sp on sp.uuid=q1.uuid) WHERE last_used=m AND sp.server_uuid=? GROUP BY geolocation; (Message 42001 not found); SQL statement:
  112. SELECT geolocation, MIN(min_ping) as minPing, MAX(max_ping) as maxPing, AVG(avg_ping) as avgPing FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN (SELECT max_ping, min_ping, avg_ping, uuid, server_uuid FROM plan_ping) sp on sp.uuid=q1.uuid) WHERE last_used=m AND sp.server_uuid=? GROUP BY geolocation [42001-199]
  113. at com.djrapitops.plan.exceptions.database.DBOpException.forCause(DBOpException.java:37) ~[?:?]
  114. at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:55) ~[?:?]
  115. at com.djrapitops.plan.storage.database.SQLDB.query(SQLDB.java:228) ~[?:?]
  116. at com.djrapitops.plan.delivery.rendering.json.JSONFactory.pingPerGeolocation(JSONFactory.java:223) ~[?:?]
  117. at com.djrapitops.plan.delivery.rendering.json.ServerTabJSONParser.apply(ServerTabJSONParser.java:33) ~[?:?]
  118. at com.djrapitops.plan.delivery.rendering.json.ServerTabJSONParser.apply(ServerTabJSONParser.java:27) ~[?:?]
  119. at com.djrapitops.plan.delivery.webserver.pages.json.ServerTabJSONHandler.lambda$getResponse$0(ServerTabJSONHandler.java:59) ~[?:?]
  120. at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:52) ~[?:?]
  121. at com.djrapitops.plan.delivery.webserver.cache.JSONCache.getOrCache(JSONCache.java:75) ~[?:?]
  122. at com.djrapitops.plan.delivery.webserver.pages.json.ServerTabJSONHandler.getResponse(ServerTabJSONHandler.java:59) ~[?:?]
  123. at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler$1.getResponse(TreePageHandler.java:54) ~[?:?]
  124. at com.djrapitops.plan.delivery.webserver.pages.TreePageHandler.getResponse(TreePageHandler.java:81) ~[?:?]
  125. at com.djrapitops.plan.delivery.webserver.ResponseHandler.tryToGetResponse(ResponseHandler.java:147) ~[?:?]
  126. at com.djrapitops.plan.delivery.webserver.ResponseHandler.getResponse(ResponseHandler.java:94) ~[?:?]
  127. at com.djrapitops.plan.delivery.webserver.RequestHandler.handle(RequestHandler.java:99) ~[?:?]
  128. at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
  129. at sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83) ~[?:1.8.0_222]
  130. at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:82) ~[?:1.8.0_222]
  131. at sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:675) ~[?:1.8.0_222]
  132. at com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79) ~[?:1.8.0_222]
  133. at sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:647) ~[?:1.8.0_222]
  134. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_222]
  135. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_222]
  136. at java.lang.Thread.run(Thread.java:748) [?:1.8.0_222]
  137. Caused by: plan.org.h2.jdbc.JdbcSQLSyntaxErrorException: (Message 42001 not found); SQL statement:
  138. SELECT geolocation, MIN(min_ping) as minPing, MAX(max_ping) as maxPing, AVG(avg_ping) as avgPing FROM ((SELECT uuid, geolocation, last_used FROM plan_geolocations) AS q1 JOIN (SELECT uuid, MAX(last_used) as m FROM plan_geolocations GROUP BY uuid) AS q2 ON q1.uuid = q2.uuid JOIN (SELECT max_ping, min_ping, avg_ping, uuid, server_uuid FROM plan_ping) sp on sp.uuid=q1.uuid) WHERE last_used=m AND sp.server_uuid=? GROUP BY geolocation [42001-199]
  139. at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:451) ~[?:?]
  140. at plan.org.h2.message.DbException.getJdbcSQLException(DbException.java:427) ~[?:?]
  141. at plan.org.h2.message.DbException.getSyntaxError(DbException.java:243) ~[?:?]
  142. at plan.org.h2.command.Parser.getSyntaxError(Parser.java:991) ~[?:?]
  143. at plan.org.h2.command.Parser.read(Parser.java:4549) ~[?:?]
  144. at plan.org.h2.command.Parser.readTableFilter(Parser.java:1820) ~[?:?]
  145. at plan.org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:2641) ~[?:?]
  146. at plan.org.h2.command.Parser.parseSelectSimple(Parser.java:2788) ~[?:?]
  147. at plan.org.h2.command.Parser.parseSelectSub(Parser.java:2636) ~[?:?]
  148. at plan.org.h2.command.Parser.parseSelectUnion(Parser.java:2469) ~[?:?]
  149. at plan.org.h2.command.Parser.parseSelect(Parser.java:2440) ~[?:?]
  150. at plan.org.h2.command.Parser.parsePrepared(Parser.java:814) ~[?:?]
  151. at plan.org.h2.command.Parser.parse(Parser.java:788) ~[?:?]
  152. at plan.org.h2.command.Parser.parse(Parser.java:764) ~[?:?]
  153. at plan.org.h2.command.Parser.prepareCommand(Parser.java:683) ~[?:?]
  154. at plan.org.h2.engine.Session.prepareLocal(Session.java:627) ~[?:?]
  155. at plan.org.h2.engine.Session.prepareCommand(Session.java:565) ~[?:?]
  156. at plan.org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1292) ~[?:?]
  157. at plan.org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:77) ~[?:?]
  158. at plan.org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:349) ~[?:?]
  159. at com.djrapitops.plan.storage.database.queries.QueryStatement.executeQuery(QueryStatement.java:51) ~[?:?]
  160. ... 22 more
RAW Paste Data