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

SQL error in "Latest host group issues" screen element

    Details

      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']

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              jelisejev Pavels Jelisejevs (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: