[Koha-bugs] [Bug 27727] New: Add patron error

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27727

            Bug ID: 27727
           Summary: Add patron error
 Change sponsored?: ---
           Product: Koha
           Version: 20.11
          Hardware: PC
                OS: Linux
            Status: NEW
          Severity: critical
          Priority: P5 - low
         Component: bugs.koha-community.org
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: nandan.singh at chitkara.edu.in
        QA Contact: testopia at bugs.koha-community.org

Created attachment 117018
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=117018&action=edit
Error display in add new petron

Recently i have upgrade koha in new verion 20.11, I am getting error while add
new petron. Errror log is 


[Fri Feb 19 12:01:58.280111 2021] [cgi:error] [pid 442415] [client
x.x.x.x:42556] AH01215: [Fri Feb 19 12:01:58 2021] 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_1`
FOREIGN KEY (`categorycode`) REFERENCES `categories` (`categorycode`)) [for
Statement "INSERT INTO `borrowers` ( `B_address`, `B_address2`, `B_city`,
`B_country`, `B_email`, `B_phone`, `B_state`, `B_streetnumber`, `B_zipcode`,
`address`, `address2`, `altcontactaddress1`, `altcontactaddress2`,
`altcontactaddress3`, `altcontactcountry`, `altcontactfirstname`,
`altcontactphone`, `altcontactstate`, `altcontactsurname`, `altcontactzipcode`,
`autorenew_checkouts`, `borrowernotes`, `borrowernumber`, `branchcode`,
`cardnumber`, `categorycode`, `city`, `contactnote`, `country`, `date_renewed`,
`dateenrolled`, `dateexpiry`, `dateofbirth`, `debarred`, `email`, `emailpro`,
`fax`, `firstname`, `initials`, `lastseen`, `mobile`, `opacnote`, `othernames`,
`password`, `phone`, `phonepro`, `privacy`, `sex`, `sort1`, `sort2`, `state`,
`streetnumber`, `surname`, `title`, `updated_on`, `userid`, `zipcode`) VALUES (
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, current_timestamp, ?, ? )" with ParamValues: 0="", 1="", 2="", 3="",
4="", 5="", 6="", 7="", 8="", 9="", 10="", 11="", 12="", 13="", 14="", 15="",
16="", 17="", 18="", 19="", 20="1", 21="", 22=undef, 23="CL", 24="test00011",
25='S', 26="", 27="", 28="", 29=undef, 30='2021-02-19',
31='2029-05-19T00:00:00', 32='2003-02-19', 33=undef, 34="", 35="", 36="",
37="Test", 38="", 39=undef, 40="", 41="", 42="",
43='$2a$08$.VjCLVGfHyzq9lSqRFnwTOaq.OC4ArlxkAiDIgwdpkk9FQU.8QY.y', 44="",
45="", 46=1, 47="M", 48="", 49="", 50="", 51="", 52="test001", 53="Mr",
54="test0001", 55=""] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.:
/usr/share/koha/intranet/cgi-bin/members/memberentry.pl, referer:
http://10.0.1.1/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=S
[Fri Feb 19 12:01:58.281846 2021] [cgi:error] [pid 442415] [client
x.x.x.x:42556] AH01215: [Fri Feb 19 12:01:58 2021] memberentry.pl:
DBIx::Class::Storage::DBI::_dbh_execute(): Cannot add or update a child row: a
foreign key constraint fails (`koha_library`.`borrowers`, CONSTRAINT
`borrowers_ibfk_1` FOREIGN KEY (`categorycode`) REFERENCES `categories`
(`categorycode`)) at /usr/share/koha/lib/Koha/Object.pm line 169:
/usr/share/koha/intranet/cgi-bin/members/memberentry.pl, referer:
http://10.0.1.1/cgi-bin/koha/members/memberentry.pl?op=add&categorycode=S

-- 
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.