Ad Widget

Collapse

Zabbix 1.5.2 & oracle 10g: error in select

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • afullana
    Junior Member
    • Apr 2008
    • 3

    #1

    Zabbix 1.5.2 & oracle 10g: error in select

    In web interface: monitoring->Events:
    SQL error [ORA-00933: comando SQL no terminado correctamente] in [SELECT DISTINCT t.triggerid FROM triggers t, functions f, items as i WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND (i.hostid NOT IN (10012,10020,10003,10023,10018,10022,10019,10024,1 0008,10021,10013,10001,10014,10011,10009,10016,100 07,10015,10004,10010,10002,10017))]

    the error is "items as i" in oracle the syntax is "items i"

    Thanks
  • Aly
    ZABBIX developer
    • May 2007
    • 1126

    #2
    As I remember, this already fixed in the latest SVN.
    Last edited by Aly; 30-05-2008, 17:22.
    Zabbix | ex GUI developer

    Comment

    Working...