[Bug 15246] New: adding new patron results in branchcode foreign key error
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15246 Bug ID: 15246 Summary: adding new patron results in branchcode foreign key error Change sponsored?: --- Product: Koha Version: 3.18 Hardware: All OS: Linux Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: gmcharlt@gmail.com Reporter: lauraerinmann@gmail.com QA Contact: testopia@bugs.koha-community.org I volunteer at a small library that wants to make available it's rare books. Another volunteer has taken the time to enter our collection. I am tasked with adding our patrons, but unable to do so. For context, our koha installation predates me, so I don't know the history of it. Steps to reproduce: 1. Go to patrons, choose "New Patron", and select "Guest/Casual User" 2. Fill out all required fields in the patron form 3. Submit the form Then I end up on: `/members/moremember.pl?borrowernumber=0` And see this message: "This patron does not exist." Just to double check, when I go back to review the patrons list for the patron I attempted to create, I can't find them. Steps I have taken: 1. updated to the (latest) package in Precise (Ubuntu 12.04) "last" repository (Koha V 3.18.12). I inherited this installation, so I can't say if this function ever worked for our library. Here is a dump of the relevant log entries from `intranet-error.log` ``` [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrowers`, CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)) at /usr/share/koha/lib/C4/SQLHelper.pm line 184., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=DAY [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=DAY [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=DAY [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=DAY [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_transport_preferences`, CONSTRAINT `borrower_message_transport_preferences_ibfk_1` FOREIGN KEY (`borrower_message_preference_id`) REFERENCES `borrower_message_) at /usr/share/koha/lib/C4/Members/Messaging.pm line 185., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=DAY [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=DAY [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=DAY ``` -- You are receiving this mail because: You are watching all bug changes.
http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15246 --- Comment #1 from Laura <lauraerinmann@gmail.com> --- I was able to get past this by changing my Home > Administration > System Preferences > Patrons. I noticed that the "BorrowerUnwantedField was set to "title|dateofbirth|branchcode" This was causing the field not to render (even as a hidden field). By removing branchcode from BorrowerUnwantedField, the branchcode field now renders, and chooses as it's only option our library branch code (our koha instance only has one libary). As for solutions, instead of getting the database error and having to chase through mysql logs, I would have ideally been met with a more understandable "Branch code is required" or better yet, the branch code, being a required field, should be rendered as a hidden input or computed server side. -- You are receiving this mail because: You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org