ZABBIX BUGS AND ISSUES
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-4574

ctemplate->unlink fails when targetids = null

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 1.9.8 (beta)
    • Fix Version/s: 1.9.9 (beta)
    • Component/s: Frontend (F)
    • Labels:
      None

      Description

      When targetids in ctemplate->unlink is set to null, the generated SQL statement fails because the following statement is generated:

      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 ('10002')) ) AND (g.flags IN ('0','1'))

      Because h is not included in all cases (=when targetids is null), the SQL statement fails. As I honestly have no idea what happens where and why due to no documentation, I have no idea how to fix that. For my bug reporting issues, I simply have set the following near line 2092:

      $sql_from = ' graphs g,hosts h';

        Issue Links

          Activity

          Timo A. Hummel created issue -
          Alexei Vladishev made changes -
          Field Original Value New Value
          Priority Minor [ 4 ] Major [ 3 ]
          Zabbix ID NA Reviewed 2.0
          Alexey Fukalov made changes -
          Assignee Aleksey Fukalov [ vedmak ]
          Alexey Fukalov made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          Alexey Fukalov made changes -
          Status In Progress [ 3 ] Open [ 1 ]
          Alexey Fukalov made changes -
          Link This issue duplicates ZBX-4573 [ ZBX-4573 ]
          Alexey Fukalov made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Fix Version/s 1.9.9 (beta) [ 10800 ]
          Resolution Fixed [ 1 ]
          Alexei Vladishev made changes -
          Workflow Zabbix workflow [ 24167 ] Zabbix workflow - new [ 45571 ]

            People

            • Assignee:
              Alexey Fukalov
              Reporter:
              Timo A. Hummel
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: