{"action":"closed","issue":{"url":"https://api.github.com/repos/weaondara/BungeePerms/issues/281","repository_url":"https://api.github.com/repos/weaondara/BungeePerms","labels_url":"https://api.github.com/repos/weaondara/BungeePerms/issues/281/labels{/name}","comments_url":"https://api.github.com/repos/weaondara/BungeePerms/issues/281/comments","events_url":"https://api.github.com/repos/weaondara/BungeePerms/issues/281/events","html_url":"https://github.com/weaondara/BungeePerms/issues/281","id":172286843,"number":281,"title":"MySQL issue","user":{"login":"Rokirok","id":19169658,"avatar_url":"https://avatars.githubusercontent.com/u/19169658?v=3","gravatar_id":"","url":"https://api.github.com/users/Rokirok","html_url":"https://github.com/Rokirok","followers_url":"https://api.github.com/users/Rokirok/followers","following_url":"https://api.github.com/users/Rokirok/following{/other_user}","gists_url":"https://api.github.com/users/Rokirok/gists{/gist_id}","starred_url":"https://api.github.com/users/Rokirok/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/Rokirok/subscriptions","organizations_url":"https://api.github.com/users/Rokirok/orgs","repos_url":"https://api.github.com/users/Rokirok/repos","events_url":"https://api.github.com/users/Rokirok/events{/privacy}","received_events_url":"https://api.github.com/users/Rokirok/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":1,"created_at":"2016-08-20T19:29:19Z","updated_at":"2016-12-24T11:35:39Z","closed_at":"2016-12-24T11:35:39Z","body":"**Error:**\n\n21:23:51 [INFO] [BungeePerms] extracting lang/EN-gb.yml\n21:23:51 [INFO] [BungeePerms] extracted lang/EN-gb.yml\n21:23:53 [INFO] [BungeePerms] loading permissions ...\n21:23:53 [SEVERE] java.lang.RuntimeException: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'bungeeperms.bungeeperms_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT\n21:23:53 [SEVERE]   at net.alpenblock.bungeeperms.Mysql.returnQuery(Mysql.java:232)\n21:23:53 [SEVERE]   at net.alpenblock.bungeeperms.Mysql.returnQuery(Mysql.java:98)\n21:23:53 [SEVERE]   at net.alpenblock.bungeeperms.io.mysql2.MysqlPermsAdapter2.getGroups(MysqlPermsAdapter2.java:44)\n21:23:53 [INFO] [BungeePerms] permissions loaded\n21:23:53 [SEVERE]   at net.alpenblock.bungeeperms.io.MySQL2BackEnd.loadGroups(MySQL2BackEnd.java:68)\n21:23:53 [SEVERE]   at net.alpenblock.bungeeperms.PermissionsManager.loadPerms(PermissionsManager.java:116)\n21:23:53 [SEVERE]   at net.alpenblock.bungeeperms.PermissionsManager.<init>(PermissionsManager.java:65)\n21:23:53 [SEVERE]   at net.alpenblock.bungeeperms.BungeePerms.<init>(BungeePerms.java:56)\n21:23:53 [SEVERE]   at net.alpenblock.bungeeperms.platform.bungee.BungeePlugin.onLoad(BungeePlugin.java:63)\n21:23:53 [SEVERE]   at net.md_5.bungee.api.plugin.PluginManager.enablePlugin(PluginManager.java:309)\n21:23:53 [SEVERE]   at net.md_5.bungee.api.plugin.PluginManager.loadPlugins(PluginManager.java:212)\n21:23:53 [SEVERE]   at net.md_5.bungee.BungeeCord.start(BungeeCord.java:264)\n21:23:53 [SEVERE]   at net.md_5.bungee.BungeeCordLauncher.main(BungeeCordLauncher.java:111)\n21:23:53 [SEVERE]   at net.md_5.bungee.Bootstrap.main(Bootstrap.java:15)\n21:23:53 [SEVERE] Caused by: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'bungeeperms.bungeeperms_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT\n21:23:53 [SEVERE]   at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)\n21:23:53 [SEVERE]   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)\n21:23:53 [SEVERE]   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)\n21:23:53 [SEVERE]   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)\n21:23:53 [SEVERE]   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)\n21:23:53 [SEVERE]   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)\n21:23:53 [SEVERE]   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)\n21:23:53 [SEVERE]   at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)\n21:23:53 [SEVERE]   at net.alpenblock.bungeeperms.Mysql.returnQuery(Mysql.java:218)\n21:23:53 [SEVERE]   ... 12 more\n21:23:53 [INFO] Loaded plugin BungeePerms version 3.0 dev #47 by wea_ondara\n\n**Using:\nServer version: 5.7.13-0ubuntu0.16.04.2 (Ubuntu)**\n"}}
{"actor":{"display_login":"Rokirok"}}