theCrag/website — Issue #451: Error message when deleting node
Author: MelwinQ
Created: 2012-01-21 09:50:55+00:00
State: open

I tried to clean up the index for Switzerland and wanted to delete Schaffhausen (http://www.thecrag.com/area/11878993) as it is a Kanton, which is already present at the top level.
It failed with the following error message (same goes for Aargau):

Error
Cannot continue process: Unable to process actionDeleteNetworkNode transaction (id=11878993), database error: Cannot delete or update a parent row: a foreign key constraint fails (`cids/AreaAccountPermit`, CONSTRAINT `AreaAccountPermit_ibfk_3` FOREIGN KEY (`NetworkNode`) REFERENCES `NetworkNode` (`ID`))

State: 3931

Error Code: 4

CodeReference: CIDS::Process::SupplyInformation::DeleteNode, /opt/CIDS/perllib/CIDS/Process/SupplyInformation/DeleteNode.pm, 315