- fixed SQL statements for PostgreSQL (Eugene)

git-svn-id: svn://svn.zabbix.com/trunk@3634 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 2 insertions, 2 deletions

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;