Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-23 Thread Michael Kuhn
Just for the record: The solution was really easy - no update was necessary. Instead just add a missing semicolon after the curly bracket in line 138 of file "deletemem.pl" (see https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=114182=diff ) # cd

Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-22 Thread Katrin Fischer
Maybe helpful to know, if you add ALL at the beginning of your bugzilla search, the closed and resolved bugs will be included :) Katrin On 22.06.21 11:04, Jonathan Druart wrote: The bug is "resolved fixed", they are excluded from the default search. Le mar. 22 juin 2021 à 10:44, Michael Kuhn

Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-22 Thread Jonathan Druart
The bug is "resolved fixed", they are excluded from the default search. Le mar. 22 juin 2021 à 10:44, Michael Kuhn a écrit : > > Hi Joonas > > You wrote: > > > if you are really using 20.11.00 and not 20.11.01 or newer then I > > think you might be bumping into bug 27144 [1]. Please upgrade

Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-22 Thread Michael Kuhn
Hi Joonas You wrote: > if you are really using 20.11.00 and not 20.11.01 or newer then I > think you might be bumping into bug 27144 [1]. Please upgrade your > koha version to fix the issue. > > [1] https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27144 Yes, this sounds exactly like

Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-22 Thread Michael Kuhn
Hi Jonathan > Nothing in plack-error.log? > If you have a 500 you should see something useful there. No, sorry - absolutely nothing in "plack-error.log". Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123

Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-22 Thread Jonathan Druart
Nothing in plack-error.log? If you have a 500 you should see something useful there. Le mar. 22 juin 2021 à 09:48, Michael Kuhn a écrit : > > Hi Jonathan > > You wrote: > > > Hi Michael, what do you have in the Koha log files? > > When trying to delete a user, logfile

Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-22 Thread Joonas Kylmälä
Hi Michael, if you are really using 20.11.00 and not 20.11.01 or newer then I think you might be bumping into bug 27144 [1]. Please upgrade your koha version to fix the issue. Joonas [1] https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27144 On 21/06/2021 22:01, Michael Kuhn wrote: >

Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-22 Thread Javi Legido
Hi there. Given that web application logs are so laconic maybe you can temporary enable SQL query logging in your database to see which query is producing the error. Cheers. Javier On Tue, 22 Jun 2021 at 09:48, Michael Kuhn wrote: > Hi Jonathan > > You wrote: > > > Hi Michael, what do you

Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-22 Thread Michael Kuhn
Hi Jonathan You wrote: > Hi Michael, what do you have in the Koha log files? When trying to delete a user, logfile "/var/log/koha/embl/plack.log" says: 192.168.210.80 - - [21/Jun/2021:17:16:58 +0200] "GET /intranet/members/deletemem.pl?member=83 HTTP/1.1" 200 32438

Re: [Koha] Reoccurring DBMS auto increment issue

2021-06-22 Thread Jonathan Druart
Hi Michael, what do you have in the Koha log files? Le lun. 21 juin 2021 à 21:01, Michael Kuhn a écrit : > > Hi > > We are working with Debian GNU/Linux 10, MariaDB 10.3.27 and Koha > 20.11.00 (using Shibboleth authentication). > > To avoid auto increment issues we have implemented the solution

[Koha] Reoccurring DBMS auto increment issue

2021-06-21 Thread Michael Kuhn
Hi We are working with Debian GNU/Linux 10, MariaDB 10.3.27 and Koha 20.11.00 (using Shibboleth authentication). To avoid auto increment issues we have implemented the solution described in https://wiki.koha-community.org/wiki/DBMS_auto_increment_fix#Single_instance_setup - of course