- fixed crash in case if MySQL server gone (support for signal PIPE) (Alexei)

 Thanks to Arturs.
 - fixed duplicate triggers in Availability Report (Alexei)
 - fixed division by zero in Availability Report (Alexei)


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

1 files changed, 1 insertions, 1 deletions

diff --git a/frontends/php/report2.php b/frontends/php/report2.php
index 10eee4c5..e534f733 100644
--- a/frontends/php/report2.php
+++ b/frontends/php/report2.php
@@ -26,7 +26,7 @@
 
 <?
 
-	$result=DBselect("select h.hostid,h.host,t.triggerid,t.expression,t.description,t.value from triggers t,hosts h,items i,functions f where f.itemid=i.itemid and h.hostid=i.hostid and t.status=0 and t.triggerid=f.triggerid and h.status in (0,2) and i.status=0 order by h.host,t.lastchange desc, t.description");
+	$result=DBselect("select distinct h.hostid,h.host,t.triggerid,t.expression,t.description,t.value from triggers t,hosts h,items i,functions f where f.itemid=i.itemid and h.hostid=i.hostid and t.status=0 and t.triggerid=f.triggerid and h.status in (0,2) and i.status=0 order by h.host, t.description");
 
 	$lasthost="";
 	$col=0;