[#ZBXNEXT-581] Ability to filter by multiple LLD macros

24739:20131216:100958.161 [Z3005] query failed: [0] PGRES_FATAL_ERROR:ERROR: insert or update on table "item_condition" violates foreign key constraint "c_item_condition_2" DETAIL: Key (templateid)=(22444) is not present in table "item_condition". [insert into item_condition (item_conditionid,itemid,templateid,macro,value) values (23278,23278,22444,'{#IFNAME}','@Network interfaces for discovery')]

array(33) { ["itemid"]=> NULL ["interfaceid"]=> string(1) "1" ["name"]=> string(27) "Network interface discovery" ["description"]=> string(0) "" ["key_"]=> string(16) "net.if.discovery" ["hostid"]=> string(5) "10105" ["delay"]=> string(2) "30" ["status"]=> string(1) "0" ["type"]=> string(1) "0" ["snmp_community"]=> NULL ["snmp_oid"]=> NULL ["trapper_hosts"]=> NULL ["port"]=> NULL ["snmpv3_contextname"]=> NULL ["snmpv3_securityname"]=> NULL ["snmpv3_securitylevel"]=> NULL ["snmpv3_authprotocol"]=> string(1) "0" ["snmpv3_authpassphrase"]=> NULL ["snmpv3_privprotocol"]=> string(1) "0" ["snmpv3_privpassphrase"]=> NULL ["delay_flex"]=> string(0) "" ["authtype"]=> NULL ["username"]=> NULL ["password"]=> NULL ["publickey"]=> NULL ["privatekey"]=> NULL ["params"]=> NULL ["ipmi_sensor"]=> NULL ["lifetime"]=> string(2) "30" ["filter"]=> array(2) { ["evaltype"]=> string(1) "0" ["conditions"]=> array(0) { } } ["flags"]=> int(1) ["value_type"]=> int(4) ["data_type"]=> int(0) }

(30) [AF] Create a discovery rule in frontend and add a filter macro there. Save it and open it for editing. Now let's say you forgot you opened it in browser and you open API and execute the following code. For example:

{
    "name": "test",
    "itemid": "23761",
    "filter": {
        "evaltype": "0",
        "conditions": []
    }
}

This should delete the filter. It's a succeeds. Now try to save again from previously opened tab. It says it succeeds, but we now have undefined indexes there. Because we no longer had those old condition ID's.

Undefined offset: 91 [host_discovery.php:300 → CAPIObject->update() → CAPIObject->__call() → czbxrpc::call() → czbxrpc::callAPI() → call_user_func() → CDiscoveryRule->update() → CDiscoveryRule->updateReal() → DB::replace() in C:\Development\ZBXNEXT-581-test\frontends\php\include\classes\db\DB.php:642]
Argument 2 passed to DB::recordModified() must be of the type array, null given, called in C:\Development\ZBXNEXT-581-test\frontends\php\include\classes\db\DB.php on line 642 and defined [host_discovery.php:300 → CAPIObject->update() → CAPIObject->__call() → czbxrpc::call() → czbxrpc::callAPI() → call_user_func() → CDiscoveryRule->update() → CDiscoveryRule->updateReal() → DB::replace() → DB::recordModified() in C:\Development\ZBXNEXT-581-test\frontends\php\include\classes\db\DB.php:689]
Invalid argument supplied for foreach() [host_discovery.php:300 → CAPIObject->update() → CAPIObject->__call() → czbxrpc::call() → czbxrpc::callAPI() → call_user_func() → CDiscoveryRule->update() → CDiscoveryRule->updateReal() → DB::replace() → DB::recordModified() in C:\Development\ZBXNEXT-581-test\frontends\php\include\classes\db\DB.php:690]

The filter is empty, although we had value there when we opened the form for editing. I think the way it should work it should save it as new, with new condition IDs.

[ZBXNEXT-581] Ability to filter by multiple LLD macros Created: 2010 Dec 12 Updated: 2017 Jan 26 Due: 2014 Apr 17 Resolved: 2014 Feb 13
Status:	Closed
Project:	ZABBIX FEATURE REQUESTS
Component/s:	Frontend (F), Installation (I), Server (S)
Affects Version/s:	None
Fix Version/s:	2.3.0

[ZBXNEXT-581] Ability to filter by multiple LLD macros Created: 2010 Dec 12 Updated: 2017 Jan 26 Due: 2014 Apr 17 Resolved: 2014 Feb 13