[Bug 40065] New: Search for patron - error
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 Bug ID: 40065 Summary: Search for patron - error Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: Igor.A.Sychev@mail.ru QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com When searching for "Search for patron", the message "502: error" is returned. /cgi-bin/koha/members/members-home.pl 1. Result - 502: error Search: Остапенко Search field: Standard 2. Patrons found for: Standard starting with 'Остап' Search: Остап Search field: Standard Result: Остапенко, Эвелина Шимко, Остап 3. Patrons found for: Surname starting with 'Остапенко' Search: Остапенко Search field: Surname Result: Остапенко, Эвелина -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 Jonathan Druart <jonathan.druart@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@gmail.com --- Comment #1 from Jonathan Druart <jonathan.druart@gmail.com> --- 502 is "bad gateway". Did you restart the services (memcached, apache2, koha-common)? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 --- Comment #2 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Also: which version of Koha? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 David Nind <david@davidnind.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |david@davidnind.com --- Comment #3 from David Nind <david@davidnind.com> --- I can't replicate on the current main (using koha-testing-docker). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 --- Comment #4 from Igor A. Sychev <Igor.A.Sychev@mail.ru> --- I was restarting all the services. I also did a reboot. 24.11.03 25.05.00 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 --- Comment #5 from Igor A. Sychev <Igor.A.Sychev@mail.ru> --- 4. Patrons found for: Standard starting with 'Сычев' Result: Сычев, Игорь Алексеевич Сычева, Анастасия Андреевна Assumption. The error occurs if only one patron is found in the search results. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 --- Comment #6 from Igor A. Sychev <Igor.A.Sychev@mail.ru> --- Update Koha 24.11.07 and 25.05.02 Perhaps some data is missing? What should I pay attention to? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 --- Comment #7 from David Nind <david@davidnind.com> --- For what it is worth (and I don't know the answer to why this is happening), testing on the current main using koha-testing-docker: 1. I created these patrons in the 'Patron' category (no other data added, apart from adding a card number): 1.1 Surname = Остапенко 1.2 Surname = Остапенко Firstname = Эвелина 1.3 Surname = Шимко Firstname = Остап 1.4 Surname = Сычев Firstname = Игорь Алексеевич 1.5 Surname = Сычева Firstname = Анастасия Андреевна 2. The DefaultPatronSearchFields system preference is set to the default: "firstname|preferred_name|middle_name|surname|othernames|cardnumber|userid" 3. If I do the first search in the description comment, I get a 500 server error in a pop-up window and a "Processing..." message. Search result, using the search in the sidebar with Search field = as per search, Search type = Starts with, Category =Any, Library = Any): Search: - Search: Остапенко - Search field: Standard Result - pop-up message: Something went wrong when loading the table. 500: Internal Server Error. Expected integer - got boolean. Expected integer - got boolean. Browser developer tools console error: Got 500 (Internal Server Error) DataTables warning: table id=memberresultst - Ajax error. For more information about this error, please see https://datatables.net/tn/7 Error logs: ==> /var/log/koha/kohadev/plack-api-error.log <== [2025/08/29 23:15:43] [WARN] OpenAPI >>> GET api/v1/patrons [{"message":"Expected integer - got boolean.","path":"\/body\/0\/privacy_guarantor_checkouts"},{"message":"Expected integer - got boolean.","path":"\/body\/1\/privacy_guarantor_checkouts"}] I get similar messages for the other searches, except there may be more "Expected integer - got boolean" messages. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 --- Comment #8 from Jonathan Druart <jonathan.druart@gmail.com> --- (In reply to David Nind from comment #7)
Error logs: ==> /var/log/koha/kohadev/plack-api-error.log <== [2025/08/29 23:15:43] [WARN] OpenAPI >>> GET api/v1/patrons [{"message":"Expected integer - got boolean.","path":"\/body\/0\/privacy_guarantor_checkouts"},{"message": "Expected integer - got boolean.","path":"\/body\/1\/privacy_guarantor_checkouts"}]
This should be fixed by commit aea3b3c7002630489190fe6ea582757e1497b692 Bug 39835: (follow-up) Fix API specs to check for boolean modified: api/v1/swagger/definitions/patron.yaml @ api/v1/swagger/definitions/patron.yaml:323 @ properties: type: integer description: patron's privacy settings related to their checkout history privacy_guarantor_checkouts: - type: integer + type: boolean Can you confirm you get this error even after `yarn api:bundle && restart_all`? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 Paul Derscheid <paul.derscheid@lmscloud.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |paul.derscheid@lmscloud.de -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 --- Comment #9 from David Nind <david@davidnind.com> --- I can't replicate the error at all today, I even tried on 24.11.x! -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=40065 Jonathan Druart <jonathan.druart@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |INVALID --- Comment #10 from Jonathan Druart <jonathan.druart@gmail.com> --- Closing, please reopen if still valid. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org