SHARE
TWEET

Untitled

a guest Oct 13th, 2019 76 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
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top