When I navigate to Hosts -> items (of one of hosts) and there I use filter:
- Host group:
ociexecute(): ORA-00918: column ambiguously defined [include/db.inc.php:446]
SQL error [ORA-00918: column ambiguously defined] in [SELECT * FROM (SELECT DISTINCT i.*,g.name FROM items i,groups g,hosts_groups hg WHERE i.type<>9 AND ( (i.flags IN ('0','4')) ) AND g.groupid = hg.groupid AND hg.hostid=i.hostid AND UPPER(g.name)='SSW1_T1' AND i.itemid BETWEEN 000000000000000 AND 099999999999999 ORDER BY i.status) WHERE rownum BETWEEN 0 AND 2001]
ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:579]
when I use filter:
- Host group:
- Name like:
ociexecute(): ORA-00918: column ambiguously defined [include/db.inc.php:446]
SQL error [ORA-00918: column ambiguously defined] in [SELECT * FROM (SELECT DISTINCT i.*,g.name FROM items i,groups g,hosts_groups hg WHERE i.type<>9 AND ( UPPER(i.name) LIKE '%SDFS%' ESCAPE '!' ) AND ( (i.flags IN ('0','4')) ) AND g.groupid = hg.groupid AND hg.hostid=i.hostid AND UPPER(g.name)='SSW1_T1' AND i.itemid BETWEEN 000000000000000 AND 099999999999999 ORDER BY i.status) WHERE rownum BETWEEN 0 AND 2001]
ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:579]