-
Incident report
-
Resolution: Fixed
-
Trivial
-
2.2.4
Client had a number of graph prototypes with HighID.
The node-based system (2.0) was converted to nodeless (2.2.4).
Client added new item prototype with LowID.
When trying to create a graph prototype, the newly added item prototype is not shown in the list.
Debug shows the following query:
SQL (0.207164): SELECT DISTINCT g.groupid,g.name FROM groups g,hosts_groups hg,hosts h WHERE hg.groupid=g.groupid AND h.hostid=hg.hostid AND h.status IN (0,1,3) AND g.groupid BETWEEN 100000000000000 AND 199999999999999 popup.php:388 ? CPageFilter->__construct() ? CPageFilter->_initGroups() ? CAPIObject->get() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHostGroup->get() ? DBselect() in /slpzxs03/appli/ihs/data/web/apache2_zabbix_php/crt.2.2.4/api/classes/CHostGroup.php:351 SQL (0.003619): SELECT DISTINCT id.parent_itemid,i.* FROM items i,item_discovery id WHERE i.flags=2 AND id.parent_itemid='100100001519846' AND i.itemid=id.itemid AND i.value_type IN ('0','3') AND i.itemid BETWEEN 100000000000000 AND 199999999999999 popup.php:1282 ? CAPIObject->get() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CItemPrototype->get() ? DBselect() in /slpzxs03/appli/ihs/data/web/apache2_zabbix_php/crt.2.2.4/api/classes/CItemPrototype.php:247