From da7c9d797a97c882f032b3860268970217b36a15 Mon Sep 17 00:00:00 2001 From: osmiy Date: Fri, 22 Dec 2006 10:04:06 +0000 Subject: - fixed SQL statements for PostgreSQL (Eugene) git-svn-id: svn://svn.zabbix.com/trunk@3634 97f52cf1-0a1b-0410-bd0e-c28be96e8082 --- frontends/php/include/export.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'frontends/php/include/export.inc.php') diff --git a/frontends/php/include/export.inc.php b/frontends/php/include/export.inc.php index 73454901..6f9ff48f 100644 --- a/frontends/php/include/export.inc.php +++ b/frontends/php/include/export.inc.php @@ -309,7 +309,7 @@ zbx_xmlwriter_start_element ($memory,XML_TAG_TRIGGERS); $db_triggers = DBselect('select f.triggerid, i.hostid, count(distinct i.hostid) as cnt '. ' from functions f, items i '. - ' where f.itemid=i.itemid group by f.triggerid'); + ' where f.itemid=i.itemid group by f.triggerid, i.hostid'); while($trigger = DBfetch($db_triggers)) { if($trigger['hostid'] != $hostid || $trigger['cnt']!=1) continue; @@ -322,7 +322,7 @@ zbx_xmlwriter_start_element ($memory, XML_TAG_GRAPHS); $db_graphs = DBselect('select gi.graphid, i.hostid, count(distinct i.hostid) as cnt '. ' from graphs_items gi, items i '. - ' where gi.itemid=i.itemid group by gi.graphid'); + ' where gi.itemid=i.itemid group by gi.graphid, i.hostid'); while($graph = DBfetch($db_graphs)) { if($graph['hostid'] != $hostid || $graph['cnt']!=1) continue; -- cgit