Z_ChangeStockCode.php failed to delete the old stock master record : webERP v4.05

[terryp]

Hi Phil/Tim,

Is it safe to delete the old Item named part via Phpmyadmin directly at the database or is the error a indication of some serious problem ?


ERROR:
Adding the new stock master record ... completed
Changing stock location records ... completed
Changing stock movement records ... completed
Changing location transfer information ... completed
Changing MRP demands information ... completed
Changing MRP planned orders information ... completed
Changing MRP requirements information ... completed
Changing MRP supplies information ... completed
Changing sales analysis records ... completed
Changing order delivery differences records ... completed
Changing pricing records ... completed
Changing sales orders detail records ... completed
Changing purchase order details records ... completed
Changing purchasing data records ... completed
Changing the stock code in shipment charges records ... completed
Changing the stock check freeze file records ... completed
Changing the stock counts table records ... completed
Changing the GRNs table records ... completed
Changing the contract BOM table records ... completed
Changing the BOM table records - components ... completed
Changing the BOM table records - parents ... completed
Changing any image files ... completed
Changing the item properties table records - parents ... completed
Changing work order requirements information ... completed ... completed
Changing work order information ... completed
Changing any serialised item information ... completed
Deleting the old stock master record
Database Error : The SQL to delete the old stock master record failed
Cannot delete or update a parent row: a foreign key constraint fails (`tjporter/salescatprod`, CONSTRAINT `salescatprod_ibfk_1` FOREIGN KEY (`stockid`) REFERENCES `stockmaster` (`stockid`))
Database SQL Failure : The SQL statement that failed was
DELETE FROM stockmaster WHERE stockid='FNA-AMO-5G13'