[Bug 41981] New: Searching patrons by partial name not working
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41981 Bug ID: 41981 Summary: Searching patrons by partial name not working Initiative type: --- Sponsorship --- status: Product: Koha Version: 24.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: andres.castro@ues.edu.sv QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle@bywatersolutions.com For version 24.11.12, when searching for a patron by partial name in the intranet admin site, an alert error pops up saying: "Something went wrong when loading the table. 502: error." I have looked the following log files but I have not found any clues on what's wrong: - intranet-error - plack-intranet-error - api-error - plack When the search box is empty and I press enter, no errors appear but of course all patrons are shown. Searching by card number works without any issues. I upgraded to 24.11.13 since it's the latest version as of March 3rd 2026 but the error is still showing. -- 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=41981 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41981 --- Comment #1 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I can't replicate this behavior in our 24.11.12. Can you give some more information on what you search for and from where when the error occurs? -- 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=41981 --- Comment #2 from Andrés Castro <andres.castro@ues.edu.sv> --- (In reply to Katrin Fischer from comment #1)
I can't replicate this behavior in our 24.11.12.
Can you give some more information on what you search for and from where when the error occurs?
Greetings, It happens when I use the search box in any page (search patrons, check out). My university uses a format of two letters and five numbers for card numbers (CS26001 is an example). When the error occurs: - Searching by either name or last name - Searching by partial card number, two letters and three or less numbers (CS260) When the error doesn't occur: - When leaving the search box empty (all patrons are returned) - When searching by full or partial card number (two letters and four numbers) It's my understanding that the default value for search field is "standard". If I set that value to "surname" or "first name", no errors occur. -- 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=41981 --- Comment #3 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I am wondering if the search gives the error or the auto-complete. Does the auto-complete show for the search? -- 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=41981 --- Comment #4 from Andrés Castro <andres.castro@ues.edu.sv> --- (In reply to Katrin Fischer from comment #3)
I am wondering if the search gives the error or the auto-complete. Does the auto-complete show for the search?
Yes, the auto-complete works as expected. -- 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=41981 --- Comment #5 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- I have no idea what could be going on there. I am glad I asked for more details, but that reads like an error that is not so easy to reproduce. I believe a 502 should be indicating that some communication with the server took place? In that case the error should be visible in the logs. Can you try again with tail -f /var/logs/koha/your-instance-name/*.log and then triggering it? -- 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=41981 --- Comment #6 from Andrés Castro <andres.castro@ues.edu.sv> --- Created attachment 195002 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=195002&action=edit Logs -- 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=41981 --- Comment #7 from Andrés Castro <andres.castro@ues.edu.sv> --- (In reply to Katrin Fischer from comment #5)
I have no idea what could be going on there. I am glad I asked for more details, but that reads like an error that is not so easy to reproduce.
I believe a 502 should be indicating that some communication with the server took place? In that case the error should be visible in the logs.
Can you try again with tail -f /var/logs/koha/your-instance-name/*.log and then triggering it?
I uploaded the logs from that moment. It keeps returning a 200 code, so that's why I find it very weird. -- 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=41981 --- Comment #8 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- Hm, is there maybe a Javascript error visible on the side itself? (developer tools in the browser to check) -- 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=41981 --- Comment #9 from Andrés Castro <andres.castro@ues.edu.sv> --- (In reply to Katrin Fischer from comment #8)
Hm, is there maybe a Javascript error visible on the side itself? (developer tools in the browser to check)
The following is the output: jquery-migrate-3.3.2.min_24.1113000.js:2 JQMIGRATE: Migrate is installed, version 3.3.2 jquery-3.6.0.min_24.1113000.js:2 GET https://sb-intra.ues.edu.sv/api/v1/patrons?_page=1&_per_page=20&q=%5B%7B%22-and%22%3A%5B%5B%7B%22me.firstname%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.middle_name%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.surname%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.othernames%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.cardnumber%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.userid%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.preferred_name%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%5D%5D%7D%2C%7B%22-or%22%3A%5B%7B%22me.firstname%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.middle_name%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.surname%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.othernames%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.cardnumber%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.userid%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%2C%7B%22me.preferred_name%22%3A%7B%22like%22%3A%22castro%25%22%7D%7D%5D%7D%5D&_match=contains&_order_by=%2Bme.surname%2C%2Bme.preferred_name%2C%2Bme.firstname%2C%2Bme.middle_name%2C%2Bme.othernames%2C%2Bme.street_number%2C%2Bme.address%2C%2Bme.address2%2C%2Bme.city%2C%2Bme.state%2C%2Bme.postal_code%2C%2Bme.country 502 (Bad Gateway) send @ jquery-3.6.0.min_24.1113000.js:2 ajax @ jquery-3.6.0.min_24.1113000.js:2 s.ajax.s.ajax @ jquery-migrate-3.3.2.min_24.1113000.js:2 Ft @ datatables.min_24.1113000.js:41 S @ datatables.min_24.1113000.js:41 d @ datatables.min_24.1113000.js:41 (anonymous) @ datatables.min_24.1113000.js:41 iterator @ datatables.min_24.1113000.js:41 (anonymous) @ datatables.min_24.1113000.js:41 (anonymous) @ datatables.min_24.1113000.js:41 filter @ member.pl?quicksearch=1&circsearch=1&searchmember=castro:3990 dispatch @ jquery-3.6.0.min_24.1113000.js:2 v.handle @ jquery-3.6.0.min_24.1113000.js:2 trigger @ jquery-3.6.0.min_24.1113000.js:2 (anonymous) @ jquery-3.6.0.min_24.1113000.js:2 each @ jquery-3.6.0.min_24.1113000.js:2 each @ jquery-3.6.0.min_24.1113000.js:2 trigger @ jquery-3.6.0.min_24.1113000.js:2 s.fn.<computed> @ jquery-migrate-3.3.2.min_24.1113000.js:2 (anonymous) @ member.pl?quicksearch=1&circsearch=1&searchmember=castro:3863 e @ jquery-3.6.0.min_24.1113000.js:2 t @ jquery-3.6.0.min_24.1113000.js:2 setTimeout (anonymous) @ jquery-3.6.0.min_24.1113000.js:2 c @ jquery-3.6.0.min_24.1113000.js:2 fireWith @ jquery-3.6.0.min_24.1113000.js:2 fire @ jquery-3.6.0.min_24.1113000.js:2 c @ jquery-3.6.0.min_24.1113000.js:2 fireWith @ jquery-3.6.0.min_24.1113000.js:2 ready @ jquery-3.6.0.min_24.1113000.js:2 B @ jquery-3.6.0.min_24.1113000.js:2 datatables_24.1113000.js:399 Got 502 (error) datatables_24.1113000.js:408 DataTables warning: table id=memberresultst - Ajax error. For more information about this error, please see https://datatables.net/tn/7 -- 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=41981 --- Comment #10 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- We might need reinforcements to resolve this. Just a general question: do other API driven tables like the administration > libraries one work ok for you? -- 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=41981 --- Comment #11 from Andrés Castro <andres.castro@ues.edu.sv> --- Yes. That table does work without any issues. If any other information is needed I'm happy to share it. -- 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=41981 --- Comment #12 from Jonathan Druart <jonathan.druart@gmail.com> --- did you restart all the services? or rebooted the server? -- 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=41981 --- Comment #13 from Andrés Castro <andres.castro@ues.edu.sv> --- Yes, all services were rebooted first and then the server. The issue still happens with that table. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org