[Koha-bugs] [Bug 29341] New: If OpacRenewalBranch = opacrenew, pseudonymization process leads to "internal server error" when patrons renew the loans at OPAC

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

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 at lists.koha-community.org
          Reporter: koha at univ-lyon3.fr
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com, kyle.m.hall at 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.