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

ORACLE SQL errors in Administration->DM->Proxies w/o proxies defined

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.9.1 (alpha)
    • Fix Version/s: 1.8.4
    • Component/s: Frontend (F)
    • Labels:
      None
    • Environment:
      Oracle 10g2

      Description

      ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00918: column ambiguously defined[/var/www/zabbix/test/include/db.inc.php:453]
      SQL error [ORA-00918: column ambiguously defined] in [SELECT * FROM (SELECT h.hostid, h.host, h.status, h.lastaccess,h.host FROM hosts h WHERE ((h.hostid BETWEEN 000000000000000 AND 099999999999999)) AND h.status IN (5,6) ORDER BY h.host 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:617]

      when open DM->Proxies without any proxy

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: