Zabbix server goes down if aggregate item is created (Oracle)

[Fry]

Hi!

Zabbix server 1.1.3
DB - Oracle

Server goes down if i add an item with type "Zabbix aggregate"

log:

005911:20070112:174629 Query::select h.itemid,i.value_type,max(h.value) from items i,history h where h.itemid=i.itemid and h.itemid in (0,37789,37790,37786,37787,37782,37788,37785,37783 ,37784) and h.clock>1168612289 group by 1,2
005911:20070112:174629 Query failed:ORA-00979: not a GROUP BY expression

[Alexei]

Thanks for reporting this!

[Fry]

Could you provide a small fix for this? =)