java.sql.SQLException: Not contained in aggregate function or group by clause: COLUMN KONTONAVN in statement \[select kp.kontonr,kp.kontonavn,kp.type,m.navn,sum(kr.debit),sum(kr.kredit),sum(kr.saldo),sum(fkp.saldo),sum(momsbeloeb),kp.id,kp.sumfra,fk.kontonr,m.kontonr,kp.momsid from kontoplan as kp left join kasserapport as kr on kr.kontonr = kp.kontonr left join fastekonti as fk on fk.kontonr = kp.kontonr left join fastekontiposter as fkp on fkp.fastekontiid = fk.id left join moms as m on m.kontonr = kp.kontonr left join momsposter as mp on mp.momsid = m.id group by kp.kontonr\]

hsqldb | nobody | 1 decade ago
  1. 0

    Getting an odd sql exception?

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: Not contained in aggregate function or group by clause: COLUMN KONTONAVN in statement \[select kp.kontonr,kp.kontonavn,kp.type,m.navn,sum(kr.debit),sum(kr.kredit),sum(kr.saldo),sum(fkp.saldo),sum(momsbeloeb),kp.id,kp.sumfra,fk.kontonr,m.kontonr,kp.momsid from kontoplan as kp left join kasserapport as kr on kr.kontonr = kp.kontonr left join fastekonti as fk on fk.kontonr = kp.kontonr left join fastekontiposter as fkp on fkp.fastekontiid = fk.id left join moms as m on m.kontonr = kp.kontonr left join momsposter as mp on mp.momsid = m.id group by kp.kontonr\]
  2. 0

    Why is this alias not found?

    hsqldb | 1 decade ago | johansend
    java.sql.SQLException: Column not found: P\_NAME in statement \[see above\]
  3. 0

    Server Error Logs

    Oracle Community | 1 decade ago | 843841
    java.sql.SQLException: Unexpected end of command: 37000 Unexpected end of command in statement [update news" set visible=0 where ts=1070239728250]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    informix sql

    hsqldb | 1 decade ago | nobody
    java.sql.SQLException: Table not found: LEFT in statement \[ SELECT pmC\_52\_hr.rec ord\_date date, pmC\_52\_hr.start\_of\_interval time, pmC\_52\_hr.OMC\_id OMC\_id, pmC\_52 \_hr.MM\_id MM\_id, sum(IFNULL(pmC\_51\_hr.peg\_count\_1, 0)) so\_comp, sum(IFNULL(pmC\_5 1\_hr.peg\_count\_4, 0)) so\_usage FROM pmC\_52\_hr, LEFT\]
  6. 0

    Possible bug with 1.7.1 RC2

    hsqldb | 1 decade ago | jeffcampbell
    java.sql.SQLException: This function is not supported: org.hsqldb.Library.identity: java.lang.reflect.InvocationTargetException in statement \[CALL IDENTITY()\]

    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

      Not contained in aggregate function or group by clause: COLUMN KONTONAVN in statement \[select kp.kontonr,kp.kontonavn,kp.type,m.navn,sum(kr.debit),sum(kr.kredit),sum(kr.saldo),sum(fkp.saldo),sum(momsbeloeb),kp.id,kp.sumfra,fk.kontonr,m.kontonr,kp.momsid from kontoplan as kp left join kasserapport as kr on kr.kontonr = kp.kontonr left join fastekonti as fk on fk.kontonr = kp.kontonr left join fastekontiposter as fkp on fkp.fastekontiid = fk.id left join moms as m on m.kontonr = kp.kontonr left join momsposter as mp on mp.momsid = m.id group by kp.kontonr\]

      at org.hsqldb.Trace.getError()
    2. HSQLDB
      jdbcStatement.executeQuery
      1. org.hsqldb.Trace.getError(Unknown Source)
      2. org.hsqldb.jdbcResultSet.<init>(Unknown Source)
      3. org.hsqldb.jdbcConnection.executeStandalone(Unknown Source)
      4. org.hsqldb.jdbcConnection.execute(Unknown Source)
      5. org.hsqldb.jdbcStatement.fetchResult(Unknown Source)
      6. org.hsqldb.jdbcStatement.executeQuery(Unknown Source)
      6 frames
    3. kontoplan.funktion
      ConnectDB.select
      1. kontoplan.funktion.ConnectDB.select(ConnectDB.java:48)
      1 frame