java.lang.RuntimeException: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'bungeecord.bungeeperms_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT 19:18:37 [INFO] [BungeePerms] permissions loaded

GitHub | Quaiby | 7 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    the problem is not recoverable database

    GitHub | 7 months ago | Quaiby
    java.lang.RuntimeException: java.sql.SQLException: Expression #1 of ORDER BY clause is not in SELECT list, references column 'bungeecord.bungeeperms_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT 19:18:37 [INFO] [BungeePerms] permissions loaded
  2. 0

    Bind database to existing JBDC Connection

    Stack Overflow | 2 years ago | Roemer Bakker
    java.sql.SQLException: No database selected
  3. 0

    MySQL Issue

    GitHub | 10 months ago | Lmmb74
    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 03:37:53 [INFORMACIÓN] [BungeePerms] permissions loaded
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    运行时报SQL异常

    GitHub | 3 years ago | gewanbo
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [select count(*) from piwik.piwik_log_link_visit_action]; SQL state [null ]; error code [10000]; session was killed!!; nested exception is java.sql.SQLException: session was killed!!
  6. 0

    MySQL error on first time startup

    GitHub | 3 years ago | wezell
    com.dotmarketing.exception.DotDataException: Table 'log_mapper' was not locked with LOCK TABLES

  1. Kialandei 1 times, last 3 months ago
  2. linxiaolong 4 times, last 7 months ago
3 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    Expression #1 of ORDER BY clause is not in SELECT list, references column 'bungeecord.bungeeperms_permissions2.id' which is not in SELECT list; this is incompatible with DISTINCT

    at com.mysql.jdbc.SQLError.createSQLException()
  2. MySQL jdbc
    StatementImpl.executeQuery
    1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:996)
    2. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
    3. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
    4. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
    5. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
    6. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
    7. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
    8. com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1446)
    8 frames