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@lists.koha-community.org Reporter: nandan.singh@chitkara.edu.in QA Contact: testopia@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.