- fixed oracle sql request limitation

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

1 files changed, 3 insertions, 3 deletions

diff --git a/frontends/php/report5.php b/frontends/php/report5.php
index 7615d7ec..5413490d 100644
--- a/frontends/php/report5.php
+++ b/frontends/php/report5.php
@@ -82,9 +82,9 @@
 	t.triggerid=f.triggerid and
 	t.triggerid=a.triggerid and
 	a.clock>$time_now-$time_dif
-	group by 1,2,3,4
-	order by 5 desc,1,3
-	limit 100");
+	group by h.host,t.triggerid,t.description,t.priority
+	order by 5 desc,1,3", 100);
+
         while($row=DBfetch($result))
         {
                 $priority_style=NULL;