-
Incident report
-
Resolution: Fixed
-
Major
-
1.6
-
None
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]