java.sql.SQLException: Not in aggregate function or group by clause: org.hsqldb.Expression@1262f7c in statement [select count(*) as NOTIF_COUNT, PAGEID, SPACEID, lower(USERNAME) as USERNAME from NOTIFICATIONS group by lower(USERNAME), PAGEID, SPACEID]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via hsqldb by mabap
, 1 year ago
Cannot be in ORDER BY clause in statement \[SELECT x."resfrom", x.SIZE,y.GROWTH FROM (SELECT "resfrom", SUM("size"\*"amountThousands") AS SIZE FROM "Factory2Base" AS a JOIN "BaseStatus" AS b ON a."baseID"=b."baseID" JOIN "ResUsageNoResearch" as r ON
via hsqldb by croudet
, 1 year ago
Table not found in statement \[select sequence\_name from system\_sequences\]
via openejb-users by David Blevins, 4 months ago
Tabella non trovata in statement [select sequence_name fr om user_sequences]
via openejb-users by David Blevins, 4 months ago
Tabella non trovata in statement [select sequence_name fr om user_sequences]
java.sql.SQLException: Not in aggregate function or group by clause: org.hsqldb.Expression@1262f7c in statement [select count(*) as NOTIF_COUNT, PAGEID, SPACEID, lower(USERNAME) as USERNAME from NOTIFICATIONS group by lower(USERNAME), PAGEID, SPACEID]
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
at com.atlassian.confluence.upgrade.DuplicateNotificationsCleanupUpgradeTask.doUpgrade(DuplicateNotificationsCleanupUpgradeTask.java:66)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
11 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.