[ZBX-6068] proxy deletion fails with sql error Created: 2013 Jan 07  Updated: 2017 May 30  Resolved: 2013 Jan 23

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: API (A)
Affects Version/s: None
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: richlv Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: proxy
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

2.0 branch rev 32496


Issue Links:
Duplicate
duplicates ZBX-6126 Inconsistent delete API methods Closed

 Description   

{"jsonrpc":"2.0","method":"proxy.delete","params":

{"proxyid":["10278"]}

,"auth":"ab9638041ec6922cb14b07982b268f47","id":1}



 Comments   
Comment by richlv [ 2013 Jan 07 ]
{
    "jsonrpc": "2.0",
    "error": {
        "code": -32500,
        "message": "Application error.",
        "data": "SQL statement execution has failed \"DELETE FROM conditions WHERE conditiontype='20' AND value=Array\"",
        "debug": [
            {
                "file": "/srv/www/htdocs/zabbix/include/classes/db/DB.php",
                "line": 631,
                "function": "exception",
                "class": "DB",
                "type": "::",
                "args": [
                    1,
                    "SQL statement execution has failed \"DELETE FROM conditions WHERE conditiontype='20' AND value=Array\""
                ]
            },
            {
                "file": "/srv/www/htdocs/zabbix/api/classes/CProxy.php",
                "line": 520,
                "function": "delete",
                "class": "DB",
                "type": "::",
                "args": [
                    "conditions",
                    {
                        "conditiontype": 20,
                        "value": [
                            [
                                "10278"
                            ]
                        ]
                    }
                ]
            },
            {
                "function": "delete",
                "class": "CProxy",
                "type": "->",
                "args": [
                    {
                        "proxyid": [
                            "10278"
                        ]
                    }
                ]
            },
            {
                "file": "/srv/www/htdocs/zabbix/api/rpc/class.czbxrpc.php",
                "line": 120,
                "function": "call_user_func",
                "args": [
                    [
                        {},
                        "delete"
                    ],
                    {
                        "proxyid": [
                            "10278"
                        ]
                    }
                ]
            },
            {
                "file": "/srv/www/htdocs/zabbix/api/rpc/class.czbxrpc.php",
                "line": 72,
                "function": "callAPI",
                "class": "czbxrpc",
                "type": "::",
                "args": [
                    "proxy.delete",
                    {
                        "proxyid": [
                            "10278"
                        ]
                    }
                ]
            },
            {
                "file": "/srv/www/htdocs/zabbix/api/rpc/class.cjsonrpc.php",
                "line": 71,
                "function": "call",
                "class": "czbxrpc",
                "type": "::",
                "args": [
                    "proxy.delete",
                    {
                        "proxyid": [
                            "10278"
                        ]
                    },
                    "ab9638041ec6922cb14b07982b268f47"
                ]
            },
            {
                "file": "/srv/www/htdocs/zabbix/api_jsonrpc.php",
                "line": 54,
                "function": "execute",
                "class": "CJSONrpc",
                "type": "->",
                "args": []
            }
        ]
    },
    "id": 1
}
Comment by richlv [ 2013 Jan 07 ]

as paavels noted, square brackets for proxyid are not needed. nevertheless, we should not get an sql error

Comment by Pavels Jelisejevs (Inactive) [ 2013 Jan 15 ]

This will be fixed under ZBX-6126.

Generated at Sat Mar 15 07:17:02 EET 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.