Zabbix 2 with Oracle - ORA-00907: missing right parenthesis

[Mizukusai]

hi,
Just installed a Zabbix 2 with Oracle DB.
When I try to view the graphs, here is what happens :

ociexecute(): ORA-00907: missing right parenthesis [include/db.inc.php:446]

SQL error [ORA-00907: missing right parenthesis] in [SELECT DISTINCT g.* FROM groups g,hosts_groups hg,hosts h WHERE hg.groupid=g.groupid AND h.hostid=hg.hostid AND h.status=0 AND EXISTS (SELECT 1 FROM items i,graphs_items gi WHERE i.hostid=hg.hostid AND i.itemid=gi.itemid ROWNUM <=1) AND g.groupid BETWEEN 000000000000000 AND 099999999999999]

ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:579]

[Mizukusai]

Problem is with the function zbx_limit for Oracle.
there is a AND missing.

[Mizukusai]

This function is only used twice, and only for Graphs. (lucky!)

[dankre]

The same problem in Zabbix 2.0.2 with DB2:

db2_execute(): Statement Execute Failed [include/db.inc.php:461]
SQL error [SELECT h.hostid,h.name FROM hosts h WHERE h.status=0 AND EXISTS ( SELECT 1 FROM items i,graphs_items gi WHERE i.hostid=h.hostid AND i.itemid=gi.itemid ROWNUM <=1) AND h.hostid BETWEEN 000000000000000 AND 099999999999999] in [[IBM][CLI Driver][DB2/AIX64] SQL0104N An unexpected token "ROWNUM" was found following "D i.itemid=gi.itemid". Expected tokens may include: "OR". SQLSTATE=42601]
db2_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:593]
db2_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:594]

Resolved in 2.0.3rc1 r29500 and 2.1.0 r29501

https://support.zabbix.com/browse/ZBX-5389