{"action":"created","issue":{"url":"https://api.github.com/repos/Rsl1122/Plan-PlayerAnalytics/issues/838","repository_url":"https://api.github.com/repos/Rsl1122/Plan-PlayerAnalytics","labels_url":"https://api.github.com/repos/Rsl1122/Plan-PlayerAnalytics/issues/838/labels{/name}","comments_url":"https://api.github.com/repos/Rsl1122/Plan-PlayerAnalytics/issues/838/comments","events_url":"https://api.github.com/repos/Rsl1122/Plan-PlayerAnalytics/issues/838/events","html_url":"https://github.com/Rsl1122/Plan-PlayerAnalytics/issues/838","id":389037109,"node_id":"MDU6SXNzdWUzODkwMzcxMDk=","number":838,"title":"After logging in to Plan on BungeeCord side (Plan v4.5.1)","user":{"login":"kalleswe","id":19497539,"node_id":"MDQ6VXNlcjE5NDk3NTM5","avatar_url":"https://avatars2.githubusercontent.com/u/19497539?v=4","gravatar_id":"","url":"https://api.github.com/users/kalleswe","html_url":"https://github.com/kalleswe","followers_url":"https://api.github.com/users/kalleswe/followers","following_url":"https://api.github.com/users/kalleswe/following{/other_user}","gists_url":"https://api.github.com/users/kalleswe/gists{/gist_id}","starred_url":"https://api.github.com/users/kalleswe/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kalleswe/subscriptions","organizations_url":"https://api.github.com/users/kalleswe/orgs","repos_url":"https://api.github.com/users/kalleswe/repos","events_url":"https://api.github.com/users/kalleswe/events{/privacy}","received_events_url":"https://api.github.com/users/kalleswe/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-12-09T16:07:34Z","updated_at":"2018-12-09T16:45:03Z","closed_at":"2018-12-09T16:45:03Z","author_association":"NONE","body":"It told me to report issue here:\r\n\r\nThis is what I got:\r\nIt seems like the SQL query is wrong there and data is missing within the \"()\".\r\n\r\n```\r\ncom.djrapitops.plan.api.exceptions.ParseException: com.djrapitops.plan.api.exceptions.database.DBOpException: SQL Failed: SELECT server_id, date, players_online FROM plan_tps WHERE date>1543161906280 AND (); 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 ')' at line 1 | Failed to parse network page\r\n    com.djrapitops.plan.utilities.html.pages.NetworkPage.toHtml(NetworkPage.java:88)\r\n    com.djrapitops.plan.system.webserver.response.pages.NetworkPageResponse.(NetworkPageResponse.java:31)\r\n    com.djrapitops.plan.system.webserver.response.ResponseFactory.networkPageResponse(ResponseFactory.java:100)\r\n    com.djrapitops.plan.system.webserver.cache.ResponseCache.lambda$loadResponse$0(ResponseCache.java:63)\r\n    com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2039)\r\n    java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853)\r\n    com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2037)\r\n    com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2020)\r\n    com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:112)\r\n    com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:54)\r\n    com.djrapitops.plan.system.webserver.cache.ResponseCache.loadResponse(ResponseCache.java:63)\r\n    com.djrapitops.plan.system.webserver.pages.ServerPageHandler.getResponse(ServerPageHandler.java:85)\r\n    com.djrapitops.plan.system.webserver.ResponseHandler.getResponse(ResponseHandler.java:159)\r\n    com.djrapitops.plan.system.webserver.ResponseHandler.getResponse(ResponseHandler.java:104)\r\n    com.djrapitops.plan.system.webserver.RequestHandler.handle(RequestHandler.java:94)\r\n    com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79)\r\n    sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83)\r\n    com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:82)\r\n    sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:675)\r\n    com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79)\r\n    sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:645)\r\n    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\r\n    java.lang.Thread.run(Thread.java:748)\r\nCaused by: com.djrapitops.plan.api.exceptions.database.DBOpException: SQL Failed: SELECT server_id, date, players_online FROM plan_tps WHERE date>1543161906280 AND (); 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 ')' at line 1\r\n    com.djrapitops.plan.api.exceptions.database.DBOpException.forCause(DBOpException.java:37)\r\n    com.djrapitops.plan.system.database.databases.sql.SQLDB.query(SQLDB.java:372)\r\n    com.djrapitops.plan.system.database.databases.sql.tables.Table.query(Table.java:177)\r\n    com.djrapitops.plan.system.database.databases.sql.tables.TPSTable.getPlayersOnlineForServers(TPSTable.java:350)\r\n    com.djrapitops.plan.system.database.databases.sql.operation.SQLFetchOps.getPlayersOnlineForServers(SQLFetchOps.java:492)\r\n    com.djrapitops.plan.data.store.containers.NetworkContainer.lambda$addServerBoxes$1(NetworkContainer.java:101)\r\n    com.djrapitops.plan.data.store.containers.DataContainer.getValue(DataContainer.java:109)\r\n    com.djrapitops.plan.data.store.containers.NetworkContainer.lambda$addServerBoxes$5(NetworkContainer.java:109)\r\n    com.djrapitops.plan.utilities.formatting.PlaceholderReplacer.addPlaceholderFrom(PlaceholderReplacer.java:37)\r\n    com.djrapitops.plan.utilities.formatting.PlaceholderReplacer.addAllPlaceholdersFrom(PlaceholderReplacer.java:42)\r\n    com.djrapitops.plan.utilities.html.pages.NetworkPage.toHtml(NetworkPage.java:64)\r\n    com.djrapitops.plan.system.webserver.response.pages.NetworkPageResponse.(NetworkPageResponse.java:31)\r\n    com.djrapitops.plan.system.webserver.response.ResponseFactory.networkPageResponse(ResponseFactory.java:100)\r\n    com.djrapitops.plan.system.webserver.cache.ResponseCache.lambda$loadResponse$0(ResponseCache.java:63)\r\n    com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2039)\r\n    java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853)\r\n    com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2037)\r\n    com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2020)\r\n    com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:112)\r\n    com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:54)\r\n    com.djrapitops.plan.system.webserver.cache.ResponseCache.loadResponse(ResponseCache.java:63)\r\n    com.djrapitops.plan.system.webserver.pages.ServerPageHandler.getResponse(ServerPageHandler.java:85)\r\n    com.djrapitops.plan.system.webserver.ResponseHandler.getResponse(ResponseHandler.java:159)\r\n    com.djrapitops.plan.system.webserver.ResponseHandler.getResponse(ResponseHandler.java:104)\r\n    com.djrapitops.plan.system.webserver.RequestHandler.handle(RequestHandler.java:94)\r\n    com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79)\r\n    sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83)\r\n    com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:82)\r\n    sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:675)\r\n    com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79)\r\n    sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:645)\r\n    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\r\n    java.lang.Thread.run(Thread.java:748)\r\nCaused by: 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 ')' at line 1\r\n    sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)\r\n    sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)\r\n    sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)\r\n    java.lang.reflect.Constructor.newInstance(Constructor.java:423)\r\n    com.mysql.jdbc.Util.handleNewInstance(Util.java:425)\r\n    com.mysql.jdbc.Util.getInstance(Util.java:408)\r\n    com.mysql.jdbc.SQLError.createSQLException(SQLError.java:944)\r\n    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)\r\n    com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)\r\n    com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)\r\n    com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)\r\n    com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)\r\n    com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)\r\n    com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2011)\r\n    plan.com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)\r\n    plan.com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)\r\n    com.djrapitops.plan.system.database.databases.sql.processing.QueryStatement.executeQuery(QueryStatement.java:46)\r\n    com.djrapitops.plan.system.database.databases.sql.SQLDB.query(SQLDB.java:369)\r\n    com.djrapitops.plan.system.database.databases.sql.tables.Table.query(Table.java:177)\r\n    com.djrapitops.plan.system.database.databases.sql.tables.TPSTable.getPlayersOnlineForServers(TPSTable.java:350)\r\n    com.djrapitops.plan.system.database.databases.sql.operation.SQLFetchOps.getPlayersOnlineForServers(SQLFetchOps.java:492)\r\n    com.djrapitops.plan.data.store.containers.NetworkContainer.lambda$addServerBoxes$1(NetworkContainer.java:101)\r\n    com.djrapitops.plan.data.store.containers.DataContainer.getValue(DataContainer.java:109)\r\n    com.djrapitops.plan.data.store.containers.NetworkContainer.lambda$addServerBoxes$5(NetworkContainer.java:109)\r\n    com.djrapitops.plan.utilities.formatting.PlaceholderReplacer.addPlaceholderFrom(PlaceholderReplacer.java:37)\r\n    com.djrapitops.plan.utilities.formatting.PlaceholderReplacer.addAllPlaceholdersFrom(PlaceholderReplacer.java:42)\r\n    com.djrapitops.plan.utilities.html.pages.NetworkPage.toHtml(NetworkPage.java:64)\r\n    com.djrapitops.plan.system.webserver.response.pages.NetworkPageResponse.(NetworkPageResponse.java:31)\r\n    com.djrapitops.plan.system.webserver.response.ResponseFactory.networkPageResponse(ResponseFactory.java:100)\r\n    com.djrapitops.plan.system.webserver.cache.ResponseCache.lambda$loadResponse$0(ResponseCache.java:63)\r\n    com.github.benmanes.caffeine.cache.BoundedLocalCache.lambda$doComputeIfAbsent$14(BoundedLocalCache.java:2039)\r\n    java.util.concurrent.ConcurrentHashMap.compute(ConcurrentHashMap.java:1853)\r\n    com.github.benmanes.caffeine.cache.BoundedLocalCache.doComputeIfAbsent(BoundedLocalCache.java:2037)\r\n    com.github.benmanes.caffeine.cache.BoundedLocalCache.computeIfAbsent(BoundedLocalCache.java:2020)\r\n    com.github.benmanes.caffeine.cache.LocalCache.computeIfAbsent(LocalCache.java:112)\r\n    com.github.benmanes.caffeine.cache.LocalManualCache.get(LocalManualCache.java:54)\r\n    com.djrapitops.plan.system.webserver.cache.ResponseCache.loadResponse(ResponseCache.java:63)\r\n    com.djrapitops.plan.system.webserver.pages.ServerPageHandler.getResponse(ServerPageHandler.java:85)\r\n    com.djrapitops.plan.system.webserver.ResponseHandler.getResponse(ResponseHandler.java:159)\r\n    com.djrapitops.plan.system.webserver.ResponseHandler.getResponse(ResponseHandler.java:104)\r\n    com.djrapitops.plan.system.webserver.RequestHandler.handle(RequestHandler.java:94)\r\n    com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79)\r\n    sun.net.httpserver.AuthFilter.doFilter(AuthFilter.java:83)\r\n    com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:82)\r\n    sun.net.httpserver.ServerImpl$Exchange$LinkHandler.handle(ServerImpl.java:675)\r\n    com.sun.net.httpserver.Filter$Chain.doFilter(Filter.java:79)\r\n    sun.net.httpserver.ServerImpl$Exchange.run(ServerImpl.java:645)\r\n    java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\r\n    java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\r\n    java.lang.Thread.run(Thread.java:748)\r\n```"},"comment":{"url":"https://api.github.com/repos/Rsl1122/Plan-PlayerAnalytics/issues/comments/445552427","html_url":"https://github.com/Rsl1122/Plan-PlayerAnalytics/issues/838#issuecomment-445552427","issue_url":"https://api.github.com/repos/Rsl1122/Plan-PlayerAnalytics/issues/838","id":445552427,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0NTU1MjQyNw==","user":{"login":"Rsl1122","id":24460436,"node_id":"MDQ6VXNlcjI0NDYwNDM2","avatar_url":"https://avatars0.githubusercontent.com/u/24460436?v=4","gravatar_id":"","url":"https://api.github.com/users/Rsl1122","html_url":"https://github.com/Rsl1122","followers_url":"https://api.github.com/users/Rsl1122/followers","following_url":"https://api.github.com/users/Rsl1122/following{/other_user}","gists_url":"https://api.github.com/users/Rsl1122/gists{/gist_id}","starred_url":"https://api.github.com/users/Rsl1122/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rsl1122/subscriptions","organizations_url":"https://api.github.com/users/Rsl1122/orgs","repos_url":"https://api.github.com/users/Rsl1122/repos","events_url":"https://api.github.com/users/Rsl1122/events{/privacy}","received_events_url":"https://api.github.com/users/Rsl1122/received_events","type":"User","site_admin":false},"created_at":"2018-12-09T16:45:03Z","updated_at":"2018-12-09T16:45:03Z","author_association":"OWNER","body":"Duplicate of #812\r\n\r\nFixed in 4.5.2"}}
{"actor":{"display_login":"Rsl1122"}}