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

can't delete template : Unknown column 'h.name'

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.9.9 (beta)
    • Component/s: API (A)
    • Labels:

      Description

      Error in query [SELECT DISTINCT t.triggerid,t.description,t.flags,t.expression,h.name as host FROM triggers t WHERE EXISTS ( SELECT ff.triggerid FROM functions ff,items ii WHERE ff.triggerid=t.templateid AND ii.itemid=ff.itemid AND (ii.hostid IN ('10299')) ) AND (t.flags IN ('0','1')) ] [Unknown column 'h.name' in 'field list']
      mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
      mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
      Error in query [SELECT DISTINCT g.graphid,g.name,g.flags,h.name as host FROM graphs g WHERE EXISTS ( SELECT ggi.graphid FROM graphs_items ggi,items ii WHERE ggi.graphid=g.templateid AND ii.itemid=ggi.itemid AND (ii.hostid IN ('10299')) ) AND (g.flags IN ('0','1')) ] [Unknown column 'h.name' in 'field list']
      mysql_fetch_assoc() expects parameter 1 to be resource, boolean given [include/db.inc.php:560]
      mysql_free_result() expects parameter 1 to be resource, boolean given [include/db.inc.php:561]
      Template [dep2] deleted.

      seems to be broken by ZBX-2737

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            richlv richlv
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: