Bug 29011 - Error 500 on item checkout when Pseudonymization is used
Summary: Error 500 on item checkout when Pseudonymization is used
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Circulation (show other bugs)
Version: 21.05
Hardware: All All
: P5 - low normal
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-14 10:59 UTC by JanMueck
Modified: 2024-07-04 20:37 UTC (History)
4 users (show)

See Also:
GIT URL:
Initiative type: ---
Sponsorship status: ---
Comma delimited list of Sponsors:
Crowdfunding goal: 0
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments
screenshots (154.18 KB, application/pdf)
2021-09-14 10:59 UTC, JanMueck
Details

Note You need to log in before you can comment on or make changes to this bug.
Description JanMueck 2021-09-14 10:59:42 UTC
Created attachment 124863 [details]
screenshots

We want to checkout a item for a user, but have to search it by keywords. In that result list there is a button "ausleihe" (borrow) next to the item we want to checkout. When clicking on that there is an error 500. 

The item is then borrowed by the user (so everything is correct), but the page still shows error 500. I think its suppused to redirect to the borrowed page of that user..

see attachement.

Kind regards
Comment 1 Owen Leonard 2021-09-14 14:52:07 UTC
I can't reproduce this problem in my test system. Enabling the itemBarcodeFallbackSearch system preference and searching for an item by keyword works for me.

Do you have access to Koha's error logs?
Comment 2 Katrin Fischer 2021-09-19 22:07:23 UTC
Another thing to check:
Make sure that all your items have itemtype, holding branch and home branch set. These are the subfields a, b, and y in the item form.
Comment 3 JanMueck 2021-09-20 06:53:15 UTC
Hello and sorry for the late response.

Yes i have access to the logs. What files do you need?

I found out that the error only occures when the Pseudonymization (DSGVO) is enabled.
Comment 4 JanMueck 2021-09-20 06:56:56 UTC
subfields a, b, and y are set on all items on our test server

kind regards
Jan
Comment 5 Katrin Fischer 2021-09-20 17:14:35 UTC
Do you have access to the server and could check the plack-error-log maybe? There might be something useful there pointing the right direction.
Comment 6 JanMueck 2021-10-01 06:43:28 UTC
It states the following: 

DBIx::Class::Storage::DBI::_do_query(): DBI Exception: DBD::mysql::db do failed: Lost connection to backend server: network error (zd-dbsrv-5: 111, Connection refused) [for Statement "set NAMES 'utf8mb4'"] at /usr/share/koha/lib/C4/Context.pm line 624


Maybe this helps..

Kind regards
Jan
Comment 7 JanMueck 2021-10-25 07:14:56 UTC
Anyone got an idea to this problem?

Kind regards
Jan Mueck
Comment 8 Emmi Takkinen 2021-10-26 09:20:15 UTC
(In reply to JanMueck from comment #7)
> Anyone got an idea to this problem?
> 
> Kind regards
> Jan Mueck

Just checking, have you set key to your bcrypt_settings in koha-conf.xml as introduced in bug 24151?
Comment 9 Liz Rea 2021-11-23 20:32:24 UTC
100% if you do not have the kconf entry, you will have this problem. I believe this is fixed in 21.05.04 or 05.
Comment 10 Katrin Fischer 2023-06-24 17:54:38 UTC
(In reply to Liz Rea from comment #9)
> 100% if you do not have the kconf entry, you will have this problem. I
> believe this is fixed in 21.05.04 or 05.

Closing RESOLVED.