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

Oracle errors in Audit screen

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Cannot Reproduce
    • Icon: Major Major
    • 1.9.0 (alpha)
    • 1.9.0 (alpha)
    • API (A)
    • None
    • Zabbix 1.7.1, revision 8241
      Oracle 11g2

      Steps for reproduce problem:

      • open screen Administration -> Audit;
      • select Actions;
      • open Filter and select Recipient;
      • press [Filter] button
      • ociexecute() [<a href='function.ociexecute'>function.ociexecute</a>]: ORA-00918: column ambiguously defined[/home/sasha/public_html/trunk/include/db.inc.php:500]
      • SQL error [ORA-00918: column ambiguously defined] in [SELECT * FROM (SELECT a.*,a.userid FROM alerts a WHERE round(a.alertid/100000000000000) in (0) AND (a.userid IN (1)) AND a.alerttype=0 AND a.clock>1257870600 ORDER BY a.clock DESC) WHERE rownum BETWEEN 0 AND 1001]
      • ocierror() expects parameter 1 to be resource, boolean given[/home/sasha/public_html/trunk/include/db.inc.php:419]
      • SQL error [] in []
      • ocifetchinto() expects parameter 1 to be resource, boolean given[/home/sasha/public_html/trunk/include/db.inc.php:550]

            alexei Alexei Vladishev
            sasha Alexander Vladishev
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: