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