com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'franiprism.prism_data.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

GitHub | Eufranio | 5 months ago
  1. 0

    Can't connect with database

    GitHub | 5 months ago | Eufranio
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'franiprism.prism_data.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
  2. 0

    GitHub comment 12#161541759

    GitHub | 1 year ago | GoogleCodeExporter
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
  3. 0

    Spring 4.3.0.RELEASE + Hibernate 5.2.0.Final - GeneratedValue on mysql

    Stack Overflow | 5 months ago | Guyb
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'searcherdb.hibernate_sequence' doesn't exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Reindex problem when admin portlets in Italian language

    GitHub | 2 years ago | linuxatico
    com.dotmarketing.exception.DotRuntimeException: Could not execute query
  6. 0

    Can't save category permissions with Mysql and Lower case table Off

    GitHub | 4 years ago | mabouza
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'dotcms22.Inode' doesn't exist

  1. Kialandei 1 times, last 2 weeks ago
  2. davidvanlaatum 8 times, last 2 months ago
  3. AndrewProg 2 times, last 3 months ago
  4. kuldeep 2 times, last 3 months ago
  5. tvrmsmith 1 times, last 4 months ago
27 more registered users
64 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. com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException

    Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'franiprism.prism_data.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

    at sun.reflect.GeneratedConstructorAccessor480.newInstance()
  2. Java RT
    Constructor.newInstance
    1. sun.reflect.GeneratedConstructorAccessor480.newInstance(Unknown Source)
    2. sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    3. java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    3 frames
  3. MySQL jdbc
    PreparedStatement.executeQuery
    1. com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    2. com.mysql.jdbc.Util.getInstance(Util.java:382)
    3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
    4. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
    5. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
    6. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
    7. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
    8. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
    9. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
    10. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
    10 frames
  4. me.botsko.prism
    InspectorWand$1.run
    1. me.botsko.prism.actionlibs.ActionsQuery.lookup(ActionsQuery.java:113)
    2. me.botsko.prism.wands.InspectorWand$1.run(InspectorWand.java:106)
    2 frames
  5. org.bukkit.craftbukkit
    CraftAsyncTask.run
    1. org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
    2. org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
    2 frames
  6. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames