http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9011

Jonathan Druart <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Signed Off                  |Failed QA
                 CC|                            |[email protected]
                   |                            |m

--- Comment #11 from Jonathan Druart <[email protected]> ---
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to