[ZBX-7256] SQL error in "Latest host group issues" screen element Created: 2013 Oct 31  Updated: 2017 May 30  Resolved: 2013 Nov 01

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A), Frontend (F)
Affects Version/s: 2.1.9
Fix Version/s: 2.1.9

Type: Incident report Priority: Major
Reporter: Pavels Jelisejevs (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: api, screen, sql, triggers
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified


 Description   

When I create a "Latest host group issues" screen element and set "Sort triggers by" to "Host", an error is displayed:

Error in query [SELECT DISTINCT t.triggerid,t.state,t.error,t.url,t.expression,t.description,t.priority,t.lastchange,t.hostname FROM triggers t,functions f,items i,hosts_groups hg,hosts h WHERE hg.hostid=i.hostid AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND hg.groupid='4' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts h WHERE t.triggerid=f.triggerid AND f.itemid=i.itemid AND i.hostid=h.hostid AND (i.status<>0 OR h.status<>0)) AND t.status=0 AND t.value='1' AND t.flags IN ('0','4') AND t.triggerid = f.triggerid AND f.itemid = i.itemid AND i.hostid = h.hostid ORDER BY h.name ,t.lastchange DESC LIMIT 50 OFFSET 0] [Unknown column 't.hostname' in 'field list']



 Comments   
Comment by Pavels Jelisejevs (Inactive) [ 2013 Oct 31 ]

RESOLVED in svn://svn.zabbix.com/branches/dev/ZBX-7256.

Comment by Oleg Egorov (Inactive) [ 2013 Oct 31 ]

TESTED

Comment by Pavels Jelisejevs (Inactive) [ 2013 Oct 31 ]

Fixed in 2.1.9 r39727.

CLOSED.

Comment by Alexander Vladishev [ 2013 Nov 01 ]

(1) if opening "Triggers to 100 report", an error appears:

Undefined index:  hostname [ in /home/monitoring/trunk/frontends/php/report5.php:161]

jelisejev RESOLVED in svn://svn.zabbix.com/branches/dev/ZBX-7256.
Eduards CLOSED

Comment by Eduards Samersovs (Inactive) [ 2013 Nov 01 ]

Tested!

Comment by Pavels Jelisejevs (Inactive) [ 2013 Nov 01 ]

Fixed in 2.1.9 r39784.

CLOSED.

Generated at Fri Apr 19 09:36:51 EEST 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.