http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9011 Jonathan Druart <jonathan.druart@biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA CC| |jonathan.druart@biblibre.co | |m --- Comment #11 from Jonathan Druart <jonathan.druart@biblibre.com> --- QA comment: I found an possible issue: If the borrowernumber stored in the new field items.last_returned_by is deleted, the dbms raises an error: DBD::mysql::st execute failed: Cannot delete or update a parent row: a foreign key constraint fails (`koha_coderun`.`items`, CONSTRAINT `items_ibfk_4` FOREIGN KEY (`last_returned_by`) REFERENCES `borrowers` (`borrowernumber`)) at /home/koha/src/C4/Members.pm line 1819. You should add a "on delete cascade" option (set null ?) or remove this constraint. It is a dilemma: in one case we loose the information, in other one we loose the constraint :-/ Marked as Failed QA. -- You are receiving this mail because: You are watching all bug changes.