[Koha-bugs] [Bug 9011] Add the ability to store the last patron to return an item
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Thu May 30 15:21:50 CEST 2013
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9011
Jonathan Druart <jonathan.druart at biblibre.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|Signed Off |Failed QA
CC| |jonathan.druart at biblibre.co
| |m
--- Comment #11 from Jonathan Druart <jonathan.druart at 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.
More information about the Koha-bugs
mailing list