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 | 5 months ago
  1. 0

    the problem is not recoverable database

    GitHub | 5 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 | 8 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 | 2 years ago | wezell
    com.dotmarketing.exception.DotDataException: Table 'log_mapper' was not locked with LOCK TABLES

  1. Kialandei 1 times, last 2 weeks ago
  2. linxiaolong 4 times, last 4 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