[Koha-bugs] [Bug 15246] New: adding new patron results in branchcode foreign key error

[bugzilla-daemon at bugs.koha-community.org]

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 at gmail.com
          Reporter: lauraerinmann at gmail.com
        QA Contact: testopia at 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.