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

API host.massremove templateids_clear generates SQL error

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Minor
    • Resolution: Duplicate
    • Affects Version/s: 2.0.8
    • Fix Version/s: None
    • Component/s: API (A)
    • Labels:
    • Environment:
      Oracle Enterprise Linux 6.4, Zabbix RPMs from Zabbix repository

      Description

      Attempting to do a template "unlink and clear" via the API fails. Performing the operation manually (via the Web UI) works as expected.

      Request:

      {
      "method": "host.massremove",
      "params": {
      "hostids": [
      "10141"
      ],
      "templateids_clear":

      { "templateid": [ "10983" ] }

      },
      "auth": "8f0b53cfa9d56d8e65533d60d763bcef",
      "id": 73983,
      "jsonrpc": "2.0"
      }

      Response:

      { "code": -32500, "message": "Application error.", "data": "SQL statement execution has failed \"DELETE FROM hosts_templates WHERE templateid=Array AND hostid='10141'\"" }

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              iivs Ivo Kurzemnieks
              Reporter:
              gkra Gregory Ruiz-Ade
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: