[ZBX-3239] ORACLE SQL errors in Administration->DM->Proxies w/o proxies defined Created: 2010 Nov 28  Updated: 2017 May 30  Resolved: 2010 Dec 13

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Frontend (F)
Affects Version/s: 1.9.1 (alpha)
Fix Version/s: 1.8.4

Type: Incident report Priority: Blocker
Reporter: Alexey Pustovalov Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Oracle 10g2


Issue Links:
Duplicate
is duplicated by ZBX-3250 ORACLE SQL errors in Administration->... Closed

 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



 Comments   
Comment by Alexey Fukalov [ 2010 Dec 13 ]

branches/1.8 16037

Generated at Thu Mar 28 21:57:59 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.