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

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Minor Minor
    • None
    • 2.0.8
    • API (A)
    • Oracle Enterprise Linux 6.4, Zabbix RPMs from Zabbix repository

      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'\"" }

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

              Created:
              Updated:
              Resolved: