Bug #2571

tactical overview - charts/groups/customvars with postgresql query error

Added by dnsmichi almost 2 years ago. Updated almost 2 years ago.

Status:ResolvedStart date:04/30/2012
Priority:NormalDue date:
Assignee:jmosshammer% Done:

100%

Category:-
Target version:Icinga 1.x - 1.7
Icinga Version: DB Type:
Icinga Web Version: DB Version:
IDO Version: Browser Version:
OS Version:

Description

debian 6.0.4 x64
icinga-web git master
backend postgresql 9.1
idoutils 1.7.0-dev

commit 5af32a3843d8168bfc17e32c9dfc6009df09e8a4
Author: Jannis Mosshammer <jannis.mosshammer@netways.de>
Date:   Fri Apr 27 15:28:21 2012 +0200

    Applied sgronewold's patch for removing min/max/avg latencies
    fixes #2439
TO: Overall status with charts

SQLSTATE[42803]: Grouping error: 7 ERROR: column "i2.has_been_checked" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...t_object_id) AS i__1, i2.current_state AS i2__2, (i2.has_bee... ^
TO: By host- and servicegroups

Hostgroups    Servicegroups    Misc
SQLSTATE[42803]: Grouping error: 7 ERROR: column "i2.has_been_checked" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...t_object_id) AS i__1, i2.current_state AS i2__2, (i2.has_bee... ^
TO: Howto organize by customvariables

SQLSTATE[42803]: Grouping error: 7 ERROR: column "i2.has_been_checked" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...t_object_id) AS i__1, i2.current_state AS i2__2, (i2.has_bee... ^

Associated revisions

Revision 5d83134e
Added by jmosshammer almost 2 years ago

Fixed issues in TO views and strict legacyview (fixes #2571, refs #2439)

History

#1 Updated by jmosshammer almost 2 years ago

  • Assignee set to jmosshammer

#2 Updated by jmosshammer almost 2 years ago

  • Status changed from New to Resolved
  • % Done changed from 0 to 100

#3 Updated by viaLAN almost 2 years ago

Nach Einspielen des Diffs auf icinga-web 1.6.2 lautet die Fehlermeldung wie folgt:

TO: Overall status with charts

SQLSTATE[42803]: Grouping error: 7 FEHLER: Spalte »i.has_been_checked« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden LINE 1: ...ce_object_id) AS i2__1, i.current_state AS i__2, (i.has_been... ^

#4 Updated by dnsmichi almost 2 years ago

viaLAN wrote:

Nach Einspielen des Diffs auf icinga-web 1.6.2 lautet die Fehlermeldung wie folgt:

TO: Overall status with charts

SQLSTATE[42803]: Grouping error: 7 FEHLER: Spalte »i.has_been_checked« muss in der GROUP-BY-Klausel erscheinen oder in einer Aggregatfunktion verwendet werden LINE 1: ...ce_object_id) AS i2__1, i.current_state AS i__2, (i.has_been... ^

invalid. diffs do not match against 1.6.x tree.

my tests work fine, no more query issues on current git master.

$ git log -1
commit 8cdb2a1c7eaab3b60c598aaac7b9b1c282e57df6
Author: Marius Hein <marius.hein@netways.de>
Date:   Tue May 8 09:00:00 2012 +0200

    Layout fix for booleanImage renderer

    Centered positioning and qtip fix, refs #1558

#5 Updated by viaLAN almost 2 years ago

got the git version from today and it works without error

Also available in: Atom PDF