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

Error in Event detail screen

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.8
    • Fix Version/s: 1.8, 1.9.0 (alpha)
    • Component/s: None
    • Labels:
      None
    • Environment:
      apache-2.2.3-11,php-5.1.6, MySQL 5.0.45

      Description

      When click on Events screen, there is no event in result list (filter all)
      but when I click on triggers screen, there is 1 item
      click on item (column Last change) --> Event screen with 1 item
      click on item (Time column) --> Show event detail with Error of SQL as bellows:
      ------------------------------------------------------------------------------------------------------------------------------
      Error in query [SELECT a.* FROM alerts a,events e,items i,hosts_groups hg,rights r,users_groups ug WHERE (a.alertid div 100000000000000) in (0) AND a.eventid=e.eventid AND e.object=0 AND e.objectid=f.triggerid AND f.itemid=i.itemid AND hg.hostid=i.hostid AND r.id=hg.groupid AND r.groupid=ug.usrgrpid AND ug.userid=4 AND r.permission>=2 AND NOT EXISTS( SELECT ff.triggerid FROM functions ff, items ii WHERE ff.triggerid=e.objectid AND ff.itemid=ii.itemid AND EXISTS( SELECT hgg.groupid FROM hosts_groups hgg, rights rr, users_groups gg WHERE hgg.hostid=ii.hostid AND rr.id=hgg.groupid AND rr.groupid=gg.usrgrpid AND gg.userid=4 AND rr.permission<2)) AND (a.eventid IN (761)) AND a.alerttype=0 ORDER BY a.clock DESC] [Unknown column 'f.triggerid' in 'where clause']
      ------------------------------------------------------------------------------------------------------------------------------

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            dusito Tran Anh Nhan
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: