Hi everybody
I'm having some issue with the update graph function in zabbix before 2.2.10 and now with 2.4.7.
When I try to rename the grapsh or modify some items in an already created grapsh the php interface say:
Details:
No permissions to referred object or it does not exist!
And in the bottom of the page I get
reset() expects parameter 1 to be array, null given [graphs.php:568 → reset() in /var/www/zabbix-2.4.7/graphs.php:568]
Undefined index: hostid [ in /var/www/zabbix-2.4.7/graphs.php:571]
Undefined index: name [ in /var/www/zabbix-2.4.7/graphs.php:572]
Undefined index: key_ [ in /var/www/zabbix-2.4.7/graphs.php:573]
Undefined index: flags [ in /var/www/zabbix-2.4.7/graphs.php:574]
In other cases I get
Error in query [UPDATE graphs_items SET gitemid='10010000000007301', graphid='10010000000003032', itemid='10010000000027440', sortorder='0', type='0', calc_fnc='2', drawtype='0', yaxisside='0', color='00C800' WHERE gitemid='10010000000007301'] [Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`graphs_items`, CONSTRAINT `c_graphs_items_1` FOREIGN KEY (`graphid`) REFERENCES `graphs` (`graphid`) ON DELETE CASCADE)]
SQL statement execution has failed "UPDATE graphs_items SET gitemid='10010000000007301', graphid='10010000000003032', itemid='10010000000027440', sortorder='0', type='0', calc_fnc='2', drawtype='0', yaxisside='0', color='00C800' WHERE gitemid='10010000000007301'".
The server was created in "node mode" but there was only a single node (not a real DM setup), now it was changed to a single node environment but the problem remains.
PS please notice how in the forth screenshot it change also the items selected automatically (I've not changed the items)
The environment:
CentOS Linux release 7.1.1503 (64bit)
PHP 5.4.16
MariaDB Server 5.5.44
Zabbix server v2.4.7 (revision 56694) (manually compiled)
I'm having some issue with the update graph function in zabbix before 2.2.10 and now with 2.4.7.
When I try to rename the grapsh or modify some items in an already created grapsh the php interface say:
Details:
No permissions to referred object or it does not exist!
And in the bottom of the page I get
reset() expects parameter 1 to be array, null given [graphs.php:568 → reset() in /var/www/zabbix-2.4.7/graphs.php:568]
Undefined index: hostid [ in /var/www/zabbix-2.4.7/graphs.php:571]
Undefined index: name [ in /var/www/zabbix-2.4.7/graphs.php:572]
Undefined index: key_ [ in /var/www/zabbix-2.4.7/graphs.php:573]
Undefined index: flags [ in /var/www/zabbix-2.4.7/graphs.php:574]
In other cases I get
Error in query [UPDATE graphs_items SET gitemid='10010000000007301', graphid='10010000000003032', itemid='10010000000027440', sortorder='0', type='0', calc_fnc='2', drawtype='0', yaxisside='0', color='00C800' WHERE gitemid='10010000000007301'] [Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`graphs_items`, CONSTRAINT `c_graphs_items_1` FOREIGN KEY (`graphid`) REFERENCES `graphs` (`graphid`) ON DELETE CASCADE)]
SQL statement execution has failed "UPDATE graphs_items SET gitemid='10010000000007301', graphid='10010000000003032', itemid='10010000000027440', sortorder='0', type='0', calc_fnc='2', drawtype='0', yaxisside='0', color='00C800' WHERE gitemid='10010000000007301'".
The server was created in "node mode" but there was only a single node (not a real DM setup), now it was changed to a single node environment but the problem remains.
PS please notice how in the forth screenshot it change also the items selected automatically (I've not changed the items)
The environment:
CentOS Linux release 7.1.1503 (64bit)
PHP 5.4.16
MariaDB Server 5.5.44
Zabbix server v2.4.7 (revision 56694) (manually compiled)
Attached Files