[ZBX-707] SQL error occurs when trying to filter items by host group. Created: 2009 Feb 13  Updated: 2017 May 30  Resolved: 2009 Feb 13

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

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


 Description   

In "Configuration"=> "Item" screan, when filter "from Host group like" is enabled, SQL error occurs.
Alias "hg" for table "hosts_groups" is defined two times.

  • mysql_query() [<a href='http://www.mysql.com/doc'>http://www.mysql.com/doc</a>]: Not unique table/alias: 'hg'[C:\inet\www\zabbix16\frontends\php\include\db.inc.php:383]
  • Error in query [SELECT DISTINCT th.host as template_host,th.hostid as template_hostid, h.host, h.hostid, hg.groupid, i.* FROM hosts h,hosts_groups hg,groups g,items i LEFT JOIN items ti ON i.templateid=ti.itemid LEFT JOIN hosts th ON ti.hostid=th.hostid LEFT JOIN hosts_groups hg ON hg.hostid=th.hostid WHERE i.hostid=h.hostid AND (h.hostid IN (0,10070,10017)) AND h.hostid=10017 AND i.status <> 1 AND i.hostid=hg.hostid AND g.groupid=hg.groupid AND g.name like '%ZABBIX Servers%' ORDER BY i.description ASC,i.itemid] [Not unique table/alias: 'hg']
  • mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource[C:\inet\www\zabbix16\frontends\php\include\db.inc.php:519]


 Comments   
Comment by Alexey Fukalov [ 2009 Feb 13 ]

Fixed in 1.6 and 1.7

Generated at Fri Apr 19 14:16:25 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.