[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: |
|
||||||||
| 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 |