Getting error Can't update table 'prefix_nodes' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

[sushilshah]

Hi I am trying to follow the steps and delete a node

Hide or show nodes from subtree, explains as following:

Step 1. call p_get_tree(6) get the HARDWARE subtree,
Step 2. call p_node_hide(6, 0) to hide a subtree,
Step 3. call p_get_tree(6) get the HARDWARE subtree, when you get a subtree, it is not show in the result.
Step 4. call p_node_hide(6, 1) show HARDWARE subtree

However, getting an error as ERROR 1442 (HY000): Can't update table 'prefix_nodes' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

Any help will be much appreciated.