https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29341
Bug ID: 29341
Summary: If OpacRenewalBranch = opacrenew, pseudonymization
process leads to "internal server error" when patrons
renew the loans at OPAC
Change sponsored?: ---
Product: Koha
Version: 20.11
Hardware: All
OS: All
Status: NEW
Severity: critical
Priority: P5 - low
Component: Patrons
Assignee: koha-bugs@lists.koha-community.org
Reporter: k...@univ-lyon3.fr
QA Contact: testo...@bugs.koha-community.org
CC: gmcha...@gmail.com, kyle.m.h...@gmail.com
When you activate the pseudonymization process and the system preference
OpacRenewalBranch = opacrenew, there's an "internal server error" when patrons
renew there loans at the OPAC.
In logs, you can find :
DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key
constraint fails (`koha`.`pseudonymized_trans
actions`, CONSTRAINT `pseudonymized_transactions_borrowers_ibfk_3` FOREIGN KEY
(`transaction_branchcode`) REFERENCES `branches` (`branchcode`)) [for Stat
ement "INSERT INTO `pseudonymized_transactions` ( `branchcode`, `categorycode`,
`ccode`, `dateenrolled`, `datetime`, `has_cardnumber`, `hashed_borrowernu
mber`, `holdingbranch`, `homebranch`, `itemcallnumber`, `itemnumber`,
`itemtype`, `location`, `sort1`, `sort2`, `transaction_branchcode`,
`transaction_ty
pe`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with
ParamValues: 0='MAN', 1='ETUL3', 2=undef, 3='2021-01-11', 4='2021-10-27
06:28:28'
, 5=1, 6="$xxxxxxxxxxxxxxxxxxxxxxxxx", 7='MAN', 8='MAN', 9='345 PIN',
10="728028", 11='PRET', 12='MANDG3', 13='ELdro',
14='3101000IL', 15='OPACRenew', 16='renew'] at
/usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836.
--
You are receiving this mail because:
You are watching all bug changes.
You are the assignee for the bug.
_______________________________________________
Koha-bugs mailing list
Koha-bugs@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
