<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body>A new request with request id 7002 has been created by koha-devel-request@lists.koha-community.org. Short info on the request is : <br><br>Title : Koha-devel Digest, Vol 205, Issue 15<br>Category : <br>Description : <div>Send Koha-devel mailing list submissions to<br> koha-devel@lists.koha-community.org<br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>or, via email, send a message with subject or body 'help' to<br> koha-devel-request@lists.koha-community.org<br><br>You can reach the person managing the list at<br> koha-devel-owner@lists.koha-community.org<br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of Koha-devel digest..."<br><br><br>Today's Topics:<br><br> 1. Re: Formally give up on trying to provide PostgreSQL DB<br> support? (Jonathan Druart)<br> 2. Error - browsing Patrons by Last Name (Wainui Witika-Park)<br> 3. Re: Error - browsing Patrons by Last Name (Katrin Fischer)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Wed, 7 Dec 2022 21:59:08 +0100<br>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org><br>To: koha-devel <koha-devel@lists.koha-community.org><br>Subject: Re: [Koha-devel] Formally give up on trying to provide<br> PostgreSQL DB support?<br>Message-ID:<br> <CAJzKNY40mh_DHJoAU3opn+SE_G2SOsrvYpXU-L29_Kmf+iFQGw@mail.gmail.com><br>Content-Type: text/plain; charset="utf-8"<br><br>We are not giving up, we never really tried.<br>It could stay a long term goal, waiting for someone to work on it.<br>I don't think we should start again adding MySQLisms.<br><br>Le mar. 6 déc. 2022 à 02:49, David Cook <dcook@prosentient.com.au> a écrit :<br><br>> Hi all,<br>><br>><br>><br>> Should we formally give up on trying to provide PostgreSQL support?<br>><br>><br>><br>> I find it highly unlikely that we will ever provide it.<br>><br>><br>><br>> We may as well close issues like the following:<br>><br>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7365<br>><br>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7802<br>><br>> https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11422<br>><br>><br>><br>> Over the last year or so, the Keycloak community has undergone a lot of<br>> conversations on database support.<br>><br>><br>><br>> Historically, it’s provided support for MariaDB, MSSQL, MySQL, Oracle,<br>> PostgreSQL, and more.<br>><br>><br>><br>> However, going forward, Keycloak plans to only provide first class support<br>> for PostgreSQL and CockroachDB databases. CockroachDB uses the same wire<br>> protocol as PostgreSQL, so really they’re supporting 1 database type. You<br>> can read more about it all at the following links:<br>><br>> https://www.keycloak.org/2022/02/dbs.html<br>><br>> https://www.keycloak.org/2022/07/storage-map.html<br>><br>><br>><br>> Personally, I really like PostgreSQL. I use it for a number of other<br>> projects. But I think we’re pretty wedded to MySQL/MariaDB with Koha, and<br>> maybe we just need to own that?<br>><br>><br>><br>> David Cook<br>><br>> Senior Software Engineer<br>><br>> Prosentient Systems<br>><br>> Suite 7.03<br>><br>> 6a Glen St<br>><br>> Milsons Point NSW 2061<br>><br>> Australia<br>><br>><br>><br>> Office: 02 9212 0899<br>><br>> Online: 02 8005 0595<br>><br>><br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> website : https://www.koha-community.org/<br>> git : https://git.koha-community.org/<br>> bugs : https://bugs.koha-community.org/<br>><br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20221207/05ce37be/attachment-0001.htm><br><br>------------------------------<br><br>Message: 2<br>Date: Thu, 8 Dec 2022 11:24:31 +1300<br>From: Wainui Witika-Park <wainuiwitikapark@catalyst.net.nz><br>To: koha-devel@lists.koha-community.org<br>Subject: [Koha-devel] Error - browsing Patrons by Last Name<br>Message-ID: <0fa35144-e615-70c6-4ad0-7d1654ffc1a7@catalyst.net.nz><br>Content-Type: text/plain; charset=UTF-8; format=flowed<br><br>Hi everyone,<br><br>I was wondering if anyone can help me please, I am getting an error when <br>Browsing Patrons by Last Name.<br><br>When clicking on some letters, the search gets stuck on "Processing".<br><br>The letters that it seems to get stuck on are: A, H, N, T, V and W<br><br>It also gives a pop up error when clicking on S that sometimes says <br>"Something went wrong when loading the table. 500: Internal Server <br>Error" and sometimes says "Something went wrong. The note has not been <br>saved". The plack-error.log says:<br><br>[2022-12-06 14:47:41.21998] [19070] [warn] OpenAPI >>> GET <br>api/v1/patrons [{"message":"Expected string - got <br>null.","path":"\/body\/4\/extended_attributes\/0\/value"}]<br><br>Any help would very much appreciated :)<br><br>Wainui<br><br><br>------------------------------<br><br>Message: 3<br>Date: Wed, 7 Dec 2022 23:46:02 +0100<br>From: Katrin Fischer <katrin.fischer.83@web.de><br>To: koha-devel@lists.koha-community.org<br>Subject: Re: [Koha-devel] Error - browsing Patrons by Last Name<br>Message-ID: <a470a3c0-e57e-a4f7-a468-ec23fe46b3aa@web.de><br>Content-Type: text/plain; charset="utf-8"; Format="flowed"<br><br>Hi Wainui,<br><br>could it be this bug?<br><br>*Bug 31381*<br><https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31381> -<br>Searching patrons by letter broken when using non-mandatory extended<br>attributes<br><br>Hope this helps,<br><br>Katrin<br><br>On 07.12.22 23:24, Wainui Witika-Park wrote:<br>> Hi everyone,<br>><br>> I was wondering if anyone can help me please, I am getting an error<br>> when Browsing Patrons by Last Name.<br>><br>> When clicking on some letters, the search gets stuck on "Processing".<br>><br>> The letters that it seems to get stuck on are: A, H, N, T, V and W<br>><br>> It also gives a pop up error when clicking on S that sometimes says<br>> "Something went wrong when loading the table. 500: Internal Server<br>> Error" and sometimes says "Something went wrong. The note has not been<br>> saved". The plack-error.log says:<br>><br>> [2022-12-06 14:47:41.21998] [19070] [warn] OpenAPI >>> GET<br>> api/v1/patrons [{"message":"Expected string - got<br>> null.","path":"\/body\/4\/extended_attributes\/0\/value"}]<br>><br>> Any help would very much appreciated :)<br>><br>> Wainui<br>> _______________________________________________<br>> Koha-devel mailing list<br>> Koha-devel@lists.koha-community.org<br>> https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>> website : https://www.koha-community.org/<br>> git : https://git.koha-community.org/<br>> bugs : https://bugs.koha-community.org/<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20221207/e87ff6c1/attachment-0001.htm><br><br>------------------------------<br><br>Subject: Digest Footer<br><br>_______________________________________________<br>Koha-devel mailing list<br>Koha-devel@lists.koha-community.org<br>https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel<br>website : https://www.koha-community.org/<br>git : https://git.koha-community.org/<br>bugs : https://bugs.koha-community.org/<br><br><br>------------------------------<br><br>End of Koha-devel Digest, Vol 205, Issue 15<br>*******************************************<br></div><br><br>NOTE: You are receiving this mail because, the Requester/Technician wanted you to get notified on this request creation.<br></body></html>