Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-3380

Incorrect query in settings graphs list

XMLWordPrintable

      ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00918: column ambiguously defined[/var/www/zabbix/test/include/db.inc.php:444]
      SQL error [ORA-00918: column ambiguously defined] in [SELECT * FROM (SELECT DISTINCT g.graphid, g.name, g.graphtype,i.hostid,g.name FROM graphs g,graphs_items gi,items i WHERE ((g.graphid BETWEEN 000000000000000 AND 099999999999999)) AND (i.hostid IN (10017)) AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND ( (g.flags IN (0,4)) ) ORDER BY g.name ASC) WHERE rownum BETWEEN 0 AND 1001]
      ocifetchinto() [<a href='function.ocifetchinto'>function.ocifetchinto</a>]: ORA-24374: define not done before fetch or execute and fetch[/var/www/zabbix/test/include/db.inc.php:607]

      column "g.name" defined twice.

            Unassigned Unassigned
            dotneft Alexey Pustovalov
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: