Bug 31501 - After upgrading to 22.05, I am not able to search Patrons.
Summary: After upgrading to 22.05, I am not able to search Patrons.
Status: CLOSED FIXED
Alias: None
Product: Koha
Classification: Unclassified
Component: Patrons (show other bugs)
Version: 22.05
Hardware: All All
: P1 - high critical
Assignee: Bugs List
QA Contact: Testopia
URL: /cgi-bin/koha/members/members-home.pl...
Keywords:
Depends on:
Blocks:
 
Reported: 2022-08-31 17:24 UTC by Liny Varghese
Modified: 2023-06-08 22:26 UTC (History)
5 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
Patron are not displaying here (81.45 KB, image/png)
2022-08-31 17:24 UTC, Liny Varghese
Details
Error 500 (130.21 KB, image/png)
2022-09-05 06:31 UTC, aeisjean
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Liny Varghese 2022-08-31 17:24:58 UTC
Created attachment 140011 [details]
Patron are not displaying here

After upgrading to 22.05, I am not able to search Patrons. It says Processing. But no results or errors are coming. Log file also has no information. if I give a cardnumber in search box its redirecting to that patrons page directly. But if there are more one result, it shows nothing in datatable.

Please help
Comment 1 Joonas Kylmälä 2022-08-31 18:48:45 UTC
Just a guess: could this be caused by non-latin characters. Does either the name or Notes field contain non-latin letters, apostrophes or similar? You can open the developer javascript console in the web browser to get more information usually, it might tell us the error that happens.
Comment 2 Liny Varghese 2022-09-01 04:22:23 UTC
Thank you for the reply.

borrowernotes are all ''. Also I can list all patrons with all details in borrowers report
Comment 3 Liny Varghese 2022-09-02 05:56:06 UTC
Please help..
Comment 4 Liny Varghese 2022-09-02 07:14:27 UTC
While inspecting the datatables after member search  I got this :

<td colspan="11" class="dataTables_empty" valign="top">No matching records found</td>
Comment 5 Joonas Kylmälä 2022-09-02 16:04:57 UTC
Can you verify you don't have any custom javascript or CSS from the system preferences? The "Patrons found for" doesn't match with the search box on the left in your picture, it limits the patrons to start with the capital letter M. Maybe this is difference between master and 22.05 but in master the search query is shown in the search box, in your case it doesn't show it.
Comment 6 Liny Varghese 2022-09-03 05:31:37 UTC
No javascripts are in system preferences. I have searched using the search criteria on left side and also with the first letter. In both cases 'Processing ' message comes, but no results after that.
Comment 7 aeisjean 2022-09-05 06:29:31 UTC
Good day, I am having the same problem. I attached screenshot in developers mode.
Comment 8 aeisjean 2022-09-05 06:31:00 UTC
Created attachment 140204 [details]
Error 500
Comment 9 Joonas Kylmälä 2022-09-05 18:58:33 UTC
 (In reply to aeisjean from comment #7)
> Good day, I am having the same problem. I attached screenshot in developers
> mode.

Since the failure is in the API request, could you check on the server side plack-api-error.log and plack-error.log files? I think the first one should contain the error message but if not check the other one too.
Comment 10 aeisjean 2022-09-06 01:29:15 UTC
This is what I found at the plack-error.log

Error while loading /etc/koha/plack.psgi: Can't load application from file "/usr/share/koha/api/v1/app.pl": Can't locate JSON/Validator/Schema/OpenAPIv2.pm in @INC (you may need to install the JSON::Validator::Schema::OpenAPIv2 module) (@INC contains: /usr/share/koha/lib /usr/share/koha/installer /usr/share/koha/lib/installer /etc/perl /usr/local/lib/x86_64-linux-gnu/perl/5.30.0 /usr/local/share/perl/5.30.0 /usr/lib/x86_64-linux-gnu/perl5/5.30 /usr/share/perl5 /usr/lib/x86_64-linux-gnu/perl/5.30 /usr/share/perl/5.30 /usr/local/lib/site_perl /usr/lib/x86_64-linux-gnu/perl-base /var/lib/koha/cvsumain/plugins) at /usr/share/koha/lib/Koha/REST/V1.pm line 25.
Comment 11 aeisjean 2022-09-06 03:22:34 UTC
I was able to fix mine by installing libmojolicious-plugin-openapi-perl deb package
I just run this script and everything works fine now, thanks...

sudo apt-get install libmojolicious-plugin-openapi-perl
Comment 12 Liny Varghese 2022-09-06 05:30:03 UTC
On upgrade, this statement was not executed(don't know the reason). I have done it manually now and it seems working now.

 ALTER TABLE `borrower_attributes` ADD `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST

Thank you all for your support