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

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 1.9.9 (beta)
    • None
    • API (A)

      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

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

              Created:
              Updated:
              Resolved: