- PostreSQL related fixes (Alexei)

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

1 files changed, 1 insertions, 1 deletions

diff --git a/frontends/php/include/classes.inc.php b/frontends/php/include/classes.inc.php
index 4c82e47f..4e27760a 100644
--- a/frontends/php/include/classes.inc.php
+++ b/frontends/php/include/classes.inc.php
@@ -286,7 +286,7 @@
 			}
 			$str=substr($str,0,strlen($str)-1);
 
-			$sql="select itemid,round(900*((clock+$z)%($p))/($p)) as i,count(*) as count,avg(value) as avg,min(value) as min,max(value) as max from history where itemid in ($str) and clock>=".$this->from_time." and clock<=".$this->to_time." group by itemid,round(900*((clock+$z)%($p))/($p))";
+			$sql="select itemid,round(900*((clock+$z)%($p))/($p),0) as i,count(*) as count,avg(value) as avg,min(value) as min,max(value) as max from history where itemid in ($str) and clock>=".$this->from_time." and clock<=".$this->to_time." group by itemid,round(900*((clock+$z)%($p))/($p),0)";
 //			echo $sql;
 
 			$result=DBselect($sql);