[Koha] Patron search not working after upgrade to version 22

Wed Dec 7 10:55:15 NZDT 2022

Hi all,

with the error message I found a bug that would fit the description:

*Bug 31421*
<https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31421> -
Library limitation on patron category breaks patron search

The fix was released in 22.11.00 and 22.05.07.

Hope this helps,

Katrin

On 05.12.22 21:45, Aleisha Amohia wrote:
> Hi Kyle
>
> We're experiencing this error too.
>
> I wonder if it has something to do with patron categories being
> limited by library. We don't see the error all the time, only when we
> are logged in at a library where only a few of our patron categories
> are visible for them.
>
> Does that sound like a similar set up to yours?
>
> Aleisha
>
> On 9/08/22 01:23, Kyle Noakes wrote:
>> Hi Katrin,
>>
>> I have still been unable to solve the error. When I run the developer
>> tools
>> in my browser and try a search, I do receive an error message,
>> "Uncaught TypeError:
>> categories_map[data] is undefined" when I search for a particular
>> name. If
>> I use the link for a letter next to Browse by Last Name, I end up
>> getting
>> an "Internal Server Error" and a warning "DataTables warning: table
>> id=memberresultst - Ajax error." I saw these on the Console tab of
>> Firefox.
>> Let me know if I should be looking somewhere else as this is the
>> first time
>> I've used Developer Tools to try to solve a Koha problem.
>>
>> Thank you,
>>
>> Kyle Noakes
>> Manager of Information Systems
>> East Grand Rapids Public Schools
>> 616-974-0157
>>
>>
>> On Sun, Jul 31, 2022 at 6:22 AM Katrin Fischer<katrin.fischer.83 at web.de>
>> wrote:
>>
>>> Hi Kyle,
>>>
>>> did you solve you error yet?
>>>
>>> If not, you could check if you see any error with the developer
>>> tools in
>>> your browser. Sometimes bad data can break the patron search and the
>>> error
>>> might give a clue.
>>>
>>> Hope this helps,
>>>
>>> Katrin
>>> On 26.07.22 01:55, Kyle Noakes wrote:
>>>
>>> Hi Katrin,
>>>
>>> I am able to see all libraries under administration. I did put that
>>> in my
>>> original email, but I was not clear in my wording.
>>>
>>> On Mon, Jul 25, 2022, 4:29 PM Katrin Fischer<katrin.fischer.83 at web.de>
>>> wrote:
>>>
>>>> Hi Kyle,
>>>>
>>>> did you do the check with the Administration > Libraries table I
>>>> suggested? If the table doesn't show your configured libraries, it's
>>>> pointing to the API not working correctly.
>>>>
>>>> I can imagine because cardnumber gives only one result, this
>>>> bypasses the
>>>> API and goes to the account directly.
>>>>
>>>> Hope this helps,
>>>>
>>>> Katrin
>>>> On 25.07.22 18:03, Kyle Noakes wrote:
>>>>
>>>> Thanks for those ideas Evan. I did already find those not up to date
>>>> before posting, yet still deal with the problem.
>>>>
>>>> I did find that we are able to search for patrons using the card
>>>> number
>>>> instead of the last name. I thought I was going to be fine just
>>>> rolling
>>>> back to my old server version and database since I am at a school
>>>> during
>>>> the summer, but then noticed in the logs that my staff have been
>>>> checking
>>>> things out using ID so I am unable to just go back to that old
>>>> version as
>>>> easily as I thought.
>>>>
>>>> Maybe someone will have an idea of why I can search by card number,
>>>> but
>>>> not last name.
>>>>
>>>> Thank you,
>>>>
>>>> Kyle Noakes
>>>> Manager of Information Systems
>>>> East Grand Rapids Public Schools
>>>> 616-974-0157
>>>>
>>>>
>>>> On Mon, Jul 11, 2022 at 3:05 PM Evan Stewart<evanstewart406 at gmail.com>
>>>> wrote:
>>>>
>>>>> Correction to my apt install command in the previous reply.
>>>>>
>>>>> To fix, I upgraded "libmojolicious-perl" and "
>>>>> libmojolicious-plugin-openapi-perl" upgraded with it.
>>>>>
>>>>> I ran:  sudo apt install libmojolicious-perl
>>>>>
>>>>> -Evan
>>>>>
>>>>> On Sun, Jul 10, 2022 at 9:48 PM Evan
>>>>> Stewart<evanstewart406 at gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Hi,
>>>>>>
>>>>>> I found the solution on Raspberry Pi OS (based on Debian 10). I
>>>>>> noticed
>>>>>> that after running apt upgrade two packages were held back:
>>>>>>
>>>>>>     - libmojolicious-perl
>>>>>>     - libmojolicious-plugin-openapi-perl
>>>>>>
>>>>>> I didn't notice them before and probably wouldn't have noticed them
>>>>> had I
>>>>>> not learned about the REST API and then read a little about it in
>>>>>> the
>>>>> Koha
>>>>>> documentation (thanks Katrin!). Once I saw the REST API
>>>>>> references the
>>>>>> OpenAPI format I figured these packages were the culprit.  Also, I
>>>>>> confirmed in my About Koha settings page that the Open API module
>>>>>> was
>>>>>> flagged as "not installed" after I upgraded to Koha 22.
>>>>>>
>>>>>> The solution for me was to install the two packages with apt. 
>>>>>> Not sure
>>>>>> why they were held back using "apt upgrade", but running "sudo apt
>>>>> install
>>>>>> libmojolicious-plugin-openapi-perl" called in all other dependent
>>>>> packages;
>>>>>> including the upgrade for libmojolicious-perl and nine other new
>>>>> packages.
>>>>>> I rebooted my Raspberry Pi, logged into Koha and all is good. 
>>>>>> The Open
>>>>>> API module is listed as "Installed" in the About Koha settings page
>>>>> and the
>>>>>> patron search and library listing is working.
>>>>>>
>>>>>> Kyle, hopefully this helps your machine.
>>>>>>
>>>>>> -Evan Stewart
>>>>>>
>>>>>>
>>>>>>
>>>>>> On Fri, Jul 8, 2022 at 12:37 PM Katrin Fischer <
>>>>> katrin.fischer.83 at web.de>
>>>>>> wrote:
>>>>>>
>>>>>>> Hi Kyle,
>>>>>>>
>>>>>>> the API settings in administration are not related to Koha's
>>>>>>> internal
>>>>>>> use of the API, so if you are not using the API exeternally, you
>>>>>>> can
>>>>>>> turn these off again.
>>>>>>>
>>>>>>> Did you test if the list of libraries is visible for you in
>>>>>>> administration? If the list doesn't show, your problem is
>>>>>>> probably not
>>>>>>> the bug Tomas mentioned.
>>>>>>>
>>>>>>> What does your /etc/apt/sources.list.d/koha.list entry look like?
>>>>>>>
>>>>>>> Hope this helps,
>>>>>>>
>>>>>>> Katrin
>>>>>>>
>>>>>>>
>>>>>>> On 08.07.22 17:15, Kyle Noakes wrote:
>>>>>>>> I am having the same problem as Evan on Debian 10 (Buster)
>>>>>>>> after the
>>>>>>>> upgrade to 22.05.00 that has continued to 22.05.02. I did attempt
>>>>> to add
>>>>>>>> Tomas's patch to my pagination file manually, but it did not work,
>>>>>>>> although admittedly I have rarely needed to hand add any patch
>>>>>>>> so I
>>>>>>> could
>>>>>>>> have done something wrong. I was also unable to find any errors in
>>>>> the
>>>>>>> logs
>>>>>>>> that mention long search strings before I tried the pagination fix
>>>>>>> anyway.
>>>>>>>> I am unable to search for any patron string, not just long ones. I
>>>>> can't
>>>>>>>> even click on a letter in the alphabet to search and receive any
>>>>>>> results.
>>>>>>>> I did enable the API in administration. I can also see my branches
>>>>> in
>>>>>>>> libraries.
>>>>>>>>
>>>>>>>> Thank you,
>>>>>>>>
>>>>>>>> Kyle Noakes
>>>>>>>> Manager of Information Systems
>>>>>>>> East Grand Rapids Public Schools
>>>>>>>> 616-974-0157
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Jul 6, 2022 at 1:20 PM Tomas Cohen Arazi <
>>>>> tomascohen at gmail.com>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> This is certainly caused by a Koha bug I'm about to submit a
>>>>>>>>> patch
>>>>> for
>>>>>>> [1].
>>>>>>>>> The 22.05 release maintainer is AFK this week so he cannot
>>>>>>>>> release
>>>>> a
>>>>>>> new
>>>>>>>>> version yet.
>>>>>>>>>
>>>>>>>>> Best regards.
>>>>>>>>>
>>>>>>>>> [1]
>>>>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31104
>>>>>>>>> El mié, 6 jul 2022 a las 13:43, Evan Stewart (<
>>>>>>> evanstewart406 at gmail.com>)
>>>>>>>>> escribió:
>>>>>>>>>
>>>>>>>>>> Hello,
>>>>>>>>>>
>>>>>>>>>> I recently upgraded my Koka 21 to 22. Everything seemed to be
>>>>> working
>>>>>>>>> fine
>>>>>>>>>> until I tried searching for patrons.  Using the intranet
>>>>>>>>>> portal to
>>>>>>> search
>>>>>>>>>> for patrons provides zero results.  I see my patrons in the
>>>>> borrowers
>>>>>>>>>> table, but the GUI won't display them.  It's like the search
>>>>> function
>>>>>>>>> sees
>>>>>>>>>> no results.
>>>>>>>>>>
>>>>>>>>>> I upgraded to version 22.05.02, but the same problem still
>>>>>>>>>> occurs.
>>>>>>>>>>
>>>>>>>>>> I'm using Raspberry Pi OS (Buster).
>>>>>>>>>>
>>>>>>>>>> I can add a new patron, but even the new patron does not show in
>>>>> the
>>>>>>>>> search
>>>>>>>>>> results.
>>>>>>>>>>
>>>>>>>>>> Is there a way to refresh the indexer that handles patron
>>>>> searching?
>>>>>>> Any
>>>>>>>>>> other suggestions?
>>>>>>>>>>
>>>>>>>>>> -Evan Stewart
>>>>>>>>>> Africa's Hope, USA
>>>>>>>>>> _______________________________________________
>>>>>>>>>>
>>>>>>>>>> Koha mailing listhttp://koha-community.org
>>>>>>>>>> Koha at lists.katipo.co.nz
>>>>>>>>>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> Tomás Cohen Arazi
>>>>>>>>> Theke Solutions (http://theke.io)
>>>>>>>>> ✆ +54 9351 3513384
>>>>>>>>> GPG: B2F3C15F
>>>>>>>>> _______________________________________________
>>>>>>>>>
>>>>>>>>> Koha mailing listhttp://koha-community.org
>>>>>>>>> Koha at lists.katipo.co.nz
>>>>>>>>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>>>
>>>>>>>> Koha mailing listhttp://koha-community.org
>>>>>>>> Koha at lists.katipo.co.nz
>>>>>>>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>>> _______________________________________________
>>>>>>>
>>>>>>> Koha mailing listhttp://koha-community.org
>>>>>>> Koha at lists.katipo.co.nz
>>>>>>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>>>
>>>>> _______________________________________________
>>>>>
>>>>> Koha mailing listhttp://koha-community.org
>>>>> Koha at lists.katipo.co.nz
>>>>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
>>>>>
>> _______________________________________________
>>
>> Koha mailing listhttp://koha-community.org
>> Koha at lists.katipo.co.nz
>> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha