On enter to just created "test" screen and choose "Change" link for change definition screen field I see on top page error messages:
Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: column "h.host" must appear in the GROUP BY clause or be used in an aggregate function in /srv/httpd/apps/zabbix/include/db.inc.php on line 108
Error in query [select h.host,g.graphid,g.name from graphs g,graphs_items gi,hosts h,items i where gi.graphid=g.graphid and h.hostid=i.hostid and gi.itemid=i.itemid and h.status=0 and i.status=0 group by g.graphid order by h.host,g.name] [ERROR: column "h.host" must appear in the GROUP BY clause or be used in an aggregate function]
Warning: pg_fetch_array() expects parameter 1 to be resource, boolean given in /srv/httpd/apps/zabbix/include/db.inc.php on line 185
I'm using Postgresql 8.x backend.
kloczek
Warning: pg_exec() [function.pg-exec]: Query failed: ERROR: column "h.host" must appear in the GROUP BY clause or be used in an aggregate function in /srv/httpd/apps/zabbix/include/db.inc.php on line 108
Error in query [select h.host,g.graphid,g.name from graphs g,graphs_items gi,hosts h,items i where gi.graphid=g.graphid and h.hostid=i.hostid and gi.itemid=i.itemid and h.status=0 and i.status=0 group by g.graphid order by h.host,g.name] [ERROR: column "h.host" must appear in the GROUP BY clause or be used in an aggregate function]
Warning: pg_fetch_array() expects parameter 1 to be resource, boolean given in /srv/httpd/apps/zabbix/include/db.inc.php on line 185
I'm using Postgresql 8.x backend.
kloczek
Comment