Bug 27727 - Add patron error
Summary: Add patron error
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: 20.11
Hardware: All All
: P5 - low normal (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-02-19 06:41 UTC by Nandan
Modified: 2021-12-13 21:10 UTC (History)
2 users (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments
Error display in add new petron (32.77 KB, image/png)
2021-02-19 06:41 UTC, Nandan
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nandan 2021-02-19 06:41:44 UTC
Created attachment 117018 [details]
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
Comment 1 Owen Leonard 2021-02-19 12:04:34 UTC
This sounds like a support request rather than a bug.

Questions about Koha should be asked on the Koha mailing list (http://koha-community.org/support/koha-mailing-lists/) or in the #koha IRC channel (http://koha-community.org/get-involved/irc/).

Hopefully you've already seen the Koha documentation: http://koha-community.org/documentation/

You can also find options for paid support here: https://koha-community.org/support/