Re: [Koha-devel] [Koha] Koha January release with security fixes

2024-02-02 Thread Michael Kuhn via Koha-devel
Hi Fridolin You wrote: > The full release notes are available here: > https://koha-community.org/koha-23-11-02-released/ This link works. > https://koha-community.org/koha-23-05-08-released/ > https://koha-community.org/koha-22-11-14-released/ > https://koha-community.org/koha-22-05-18-release

[Koha-devel] Update to Koha 23.11.04 fails

2024-04-11 Thread Michael Kuhn via Koha-devel
Hi Today I tried to update a Koha 21.11.10 database to Koha 23.11.04 but the update process failed at the following point: Upgrade to 23.06.00.068 [22:55:59]: Bug 23798 - Convert OpacMaintenanceNotice system preference to additional contents ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db s

Re: [Koha-devel] Update to Koha 23.11.04 fails

2024-04-12 Thread Michael Kuhn via Koha-devel
'OpacMaintenanceNotice' Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch -Original Message- From: Ko

[Koha-devel] Error 500 when searching in Koha 23.11.0

2024-04-12 Thread Michael Kuhn via Koha-devel
Hi I have updated our database from koha 21.11.10 to the current Koha 23.11.04. When searching the catalogue I get a result list, but when clicking a single hit I get an error 500. In file "plack-error.log" I have found the following line which could be the reason: DBIx::Class::Storage::DBI:

Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0

2024-04-12 Thread Michael Kuhn via Koha-devel
Hi Ketan Kulkarni You wrote: > There's a command to upgrade koha db schema. You need to run that > command. > > Following is an example. Here, 'library' is the name of the instance. > You will need to replace that with the name of your instance. > ===// > > Upgrade Da

Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0

2024-04-12 Thread Michael Kuhn via Koha-devel
Hi Just for the record: I updated from Koha 21.11.10 to 23.11.04. When searching the catalogue I got a result list, but when clicking a single hit I got an error 500. In file "plack-error.log" I found this: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute faile

Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0

2024-04-15 Thread Michael Kuhn via Koha-devel
strasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch -Original Message- From: Koha-devel On Behalf Of Michael Kuhn via Koha-devel Sent: Saturday, 13 April 2024 9:28 AM To: k...@lists.katipo.co.nz; Koha-devel Subject: Re: [Koha-devel] [Koha] Erro

Re: [Koha-devel] [Koha] Error 500 when searching in Koha 23.11.0

2024-04-15 Thread Michael Kuhn via Koha-devel
ftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch On Mon, 15 Apr 2024, at 9:40 AM, Michael Kuhn via Koha-devel wrote: Hi David You wrote: > I don't th

[Koha-devel] Failed update to Koha 24.05.00: Unknown column 'item_id' in 'bookings'

2024-05-30 Thread Michael Kuhn via Koha-devel
Hi I just tried to update my Koha demo installation from 23.11.00 to 24.05.00 but the process failed with the following message: Upgrade to 23.12.00.044 [13:48:09]: Bug 36120 - Add pickup location to bookings ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Unknown column 'item

Re: [Koha-devel] Failed update to Koha 24.05.00: Unknown column 'item_id' in 'bookings'

2024-05-30 Thread Michael Kuhn via Koha-devel
· E m...@adminkuhn.ch · W www.adminkuhn.ch Am 30.05.24 um 14:47 schrieb Fridolin SOMERS via Koha-devel: Hi, Strange I see bookings.item_id in 23.11.00 sources both DBRev : /installer/data/mysql/db_revs/230600061.pl kohastructure.sql Le 30/05/2024 à 14:09, Michael Kuhn via Koha-devel a écrit : Hi

[Koha-devel] {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY'

2024-07-10 Thread Michael Kuhn via Koha-devel
Hi We have loaded our Koha 19.11 database into a new Koha 24.05 instance. When running "koha-upgrade-schema" the following error appears: ... Upgrade to 19.12.00.017 [12:00:41]: Bug 21674 - Add unique key (parent_id, branchcode) to library_group {UNKNOWN}: DBI Exception: DBD::mysql::db do fa

Re: [Koha-devel] [Koha] {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY'

2024-07-10 Thread Michael Kuhn via Koha-devel
Hi Philippe You wrote: > updatedatabase.pl line 20736 > > It's the conversion from issuingrules to circulation_rules. What's the > state of your DB right now? Has it started to convert? The script stopped just after giving the shown message. > How many circ rules already created? I suspect i

Re: [Koha-devel] [Koha] {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY'

2024-07-10 Thread Michael Kuhn via Koha-devel
Hi Philippe Many thanks! You wrote: > Ok, let's cheat. You have very few rules, and most of the info has > been moved already. So just comment the lines 20734 to 20746 and run > updatedatabase.pl again. > > OR modify the version to move ahead. > > update systempreferences set value = '19.12000

Re: [Koha-devel] [Koha] {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY'

2024-07-10 Thread Michael Kuhn via Koha-devel
· Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch Am 10.07.24 um 15:20 schrieb Michael Kuhn via Koha-devel: Hi Philippe Many thanks! You wrote: > Ok, let's cheat.  You have very few rules, and most of the info has > been

Re: [Koha-devel] [Koha] {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY'

2024-07-10 Thread Michael Kuhn via Koha-devel
idg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch On 2024-07-10 09:44, Michael Kuhn via Koha-devel wrote: Hi At my own risk I have modified the version to 19.12.00.029 and then moved ahead... (o

Re: [Koha-devel] [Koha] {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY'

2024-07-22 Thread Michael Kuhn via Koha-devel
Hi Philippe You wrote: > If you went with an existing 23.11 and tried to overwrite the database > with you 19.05 one, it's possible it got conflicts since it drop-and- > add in the order in the file and dependencies might break. Always > easier to just drop the old database and load the "new" o

Re: [Koha-devel] {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry '0' for key 'PRIMARY'

2024-07-24 Thread Michael Kuhn via Koha-devel
some of us for review? El mié, 10 jul 2024 a la(s) 7:46 a.m., Michael Kuhn via Koha-devel (koha-devel@lists.koha-community.org <mailto:koha-devel@lists.koha-community.org>) escribió: Hi We have loaded our Koha 19.11 database into a new Koha 24.05 instance. When running &quo

[Koha-devel] Koha Community Newsletter: November 2024

2024-11-27 Thread Michael Kuhn via Koha-devel
The Koha Community Newsletter for November 2024 is here: https://koha-community.org/koha-community-newsletter-november-2024/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me (m...@adminkuhn.ch) with any corrections or suggestions. Micha

[Koha-devel] Invalid value "0000-00-00 00:00:00" in field "borrowers.updated_on" with LDAP

2024-11-18 Thread Michael Kuhn via Koha-devel
Hi In an installation of Koha 24.05.03 I am successfully authenticating against an LDAP server which is writing the data of the authenticating user into the Koha database. But as soon as I search for the added user in the staff client I get the message: "500: Internal Server Error. Month out

Re: [Koha-devel] [Koha] Invalid value "0000-00-00 00:00:00" in field "borrowers.updated_on" with LDAP

2024-11-20 Thread Michael Kuhn via Koha-devel
Hi Chris Many thanks for your message! You wrote: > My far from optimal "workaround" (yeah... permanent workaround :) ) > for this issue was to cron a shellscript to run every minute during > library hours which does this: > > /usr/bin/mysql -u *db user* -D "*library database name*" -e "update

Re: [Koha-devel] Invalid value "0000-00-00 00:00:00" in field "borrowers.updated_on" with LDAP

2024-11-20 Thread Michael Kuhn via Koha-devel
is Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch On 19/11/24 9:50 am, Michael Kuhn via Koha-devel wrote: Hi In an installation of Koha 24.05.03 I am successfully authenticating against an LDAP server which is writing

[Koha-devel] Mailinglist "koha" does not accept e-mails from kohan...@gmail.com

2024-11-13 Thread Michael Kuhn via Koha-devel
Hi - to whom it may concern On 28 October I tried to send the e-mail about the current Koha newsletter as usual from the address kohan...@gmail.com to both mailinglists "koha" and "koha-devel", but it appeared only in "koha-devel". I also tried to reach the maintainers of list "koha" (as give

Re: [Koha-devel] Mailinglist "koha" does not accept e-mails from kohan...@gmail.com

2024-11-17 Thread Michael Kuhn via Koha-devel
t email provider might be the only available fix right now. Hope that helps, Katrin On 14.11.24 00:34, Michael Kuhn via Koha-devel wrote: Hi - to whom it may concern On 28 October I tried to send the e-mail about the current Koha newsletter as usual from the address kohan...@gmail.com to both maili

[Koha-devel] Koha Community Newsletter: December 2024

2024-12-28 Thread Michael Kuhn via Koha-devel
The Koha Community Newsletter for December 2024 is here: https://koha-community.org/koha-community-newsletter-december-2024/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me (m...@adminkuhn.ch) with any corrections or suggestions. Micha

[Koha-devel] Call for news - Newsletter December 2024

2024-12-13 Thread Michael Kuhn via Koha-devel
Hi I'm collecting news for the December 2024 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text form

[Koha-devel] Koha Community Newsletter: January 2025

2025-01-27 Thread Michael Kuhn via Koha-devel
The Koha Community Newsletter for January 2025 is here: https://koha-community.org/koha-community-newsletter-january-2025/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me (m...@adminkuhn.ch) with any corrections or suggestions. Michael

[Koha-devel] Activating preference "ILLModule" leads to error 500 in Koha 24.05

2025-01-13 Thread Michael Kuhn via Koha-devel
Hi When in Koha 24.05 trying to activate the system preference "ILLModule" it leads to error 500 when clicking Koha staff client menu "ILL requests" or clicking menu "About > System information". In file "/var/log/koha//plack-error.log" it says: Can't call method "GetPlugins" on an undefined

[Koha-devel] Call for news - Newsletter January 2025

2025-01-13 Thread Michael Kuhn via Koha-devel
BETREFF: Call for news - Newsletter January 2025 Hi I'm collecting news for the January 2025 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Ko

Re: [Koha-devel] Activating preference "ILLModule" leads to error 500 in Koha 24.05

2025-01-14 Thread Michael Kuhn via Koha-devel
that seems normal in Koha 24.05). Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch On Mon, 13 Jan 2025 at 17:

[Koha-devel] Call for news - Newsletter February 2025

2025-02-13 Thread Michael Kuhn via Koha-devel
Hi I'm collecting news for the February 2025 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text form

Re: [Koha-devel] oom-killer / Out of memory: Killed process 1026641 (/usr/share/koha)

2025-03-18 Thread Michael Kuhn via Koha-devel
Hi David On 11 March you wrote: > That opac-search.pl log looks like a bot that is really stuck. That > looks like it would yield an ever growing search query. > > Yeah, most bots don't honour robots.txt anymore it seems. > > Blocking bots that self-identify with user agent strings is certainly

Re: [Koha-devel] oom-killer / Out of memory: Killed process 1026641 (/usr/share/koha)

2025-03-19 Thread Michael Kuhn via Koha-devel
shes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz T 0041 (0)61 261 55 61 · E m...@adminkuhn.ch · W www.adminkuhn.ch On Tue, 11 Mar 2025, at 9:43 PM, Michael Kuhn via Koha-devel wrote: Hi Michael Yester

[Koha-devel] oom-killer / Out of memory: Killed process 1026641 (/usr/share/koha)

2025-03-15 Thread Michael Kuhn via Koha-devel
Hi Our host "bib" owns 4 virtual CPU, 8 GB RAM and 18 GB swap space. It runs on Debian GNU/Linux 12 with Koha 24.05.01 and around 78'000 bibliographic records. Since some time Koha sporadically just stops (today already twice), in such cases log file "/var/log/syslog" contains messages as at

[Koha-devel] Call for news - Newsletter April 2025

2025-04-13 Thread Michael Kuhn via Koha-devel
Hi I'm collecting news for the April 2025 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format

[Koha-devel] Koha Community Newsletter: April 2025

2025-04-29 Thread Michael Kuhn via Koha-devel
The Koha Community Newsletter for April 2025 is here: https://koha-community.org/koha-community-newsletter-april-2025/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to e-mail me (m...@adminkuhn.ch) with any corrections or suggestions. Michael Ku

[Koha-devel] Koha Community Newsletter: February 2025

2025-03-01 Thread Michael Kuhn via Koha-devel
The Koha Community Newsletter for February 2025 is here: https://koha-community.org/koha-community-newsletter-february-2025/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to email me (m...@adminkuhn.ch) with any corrections or suggestions. Micha

[Koha-devel] Can't call method "biblioitemnumber" on an undefined value

2025-03-05 Thread Michael Kuhn via Koha-devel
Hi We are using Debian GNU/Linux 12 with Koha 24.05.05. When running script "search_for_data_inconsistencies.pl" it shows only the following message: Can't call method "biblioitemnumber" on an undefined value at /usr/share/koha/bin/maintenance/search_for_data_inconsistencies.pl line 152. W

Re: [Koha-devel] Can't call method "biblioitemnumber" on an undefined value

2025-03-05 Thread Michael Kuhn via Koha-devel
nance/search_for_data_inconsistencies.pl#L152 probably that the biblio in question doesnt have a biblioitem associated. if thats the cause an extra step could be introduced that prevents calling biblio->biblioitem->biblioitemnumber if biblio->biblioitem is not defined. On Wed, 5 Mar 20

Re: [Koha-devel] oom-killer / Out of memory: Killed process 1026641 (/usr/share/koha)

2025-03-11 Thread Michael Kuhn via Koha-devel
y, thus also reduced the memory usage, and at least for now Koha seems to work all right again. Many thanks fpr your explanations, hints and inputs! Best wishes: Michael -- Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis Admin Kuhn GmbH · Pappelstrasse 20 · 4

Re: [Koha-devel] oom-killer / Out of memory: Killed process 1026641 (/usr/share/koha)

2025-03-11 Thread Michael Kuhn via Koha-devel
Hi David Today you wrote: > I actually just discovered a bug with /cgi-bin/koha/patroncards/ > create-pdf.pl which I'll be working on fixing today which could cause > resource exhaustion. I had some Starman workers using obscene amounts > of memory and CPU, and it's because they got trapped in i

[Koha-devel] Call for news - Newsletter March 2025

2025-03-13 Thread Michael Kuhn via Koha-devel
Hi I'm collecting news for the March 2025 Koha Community Newsletter. Please send anything noteworthy to: kohanews (at) gmail (dot) com News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format

[Koha-devel] Koha Community Newsletter: March 2025

2025-03-27 Thread Michael Kuhn via Koha-devel
The Koha Community Newsletter for March 2025 is here: https://koha-community.org/koha-community-newsletter-march-2025/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to e-mail me (m...@adminkuhn.ch) with any corrections or suggestions. Michael Ku

[Koha-devel] Call for news - Newsletter May 2025

2025-05-13 Thread Michael Kuhn via Koha-devel
Hi I'm collecting news for the May 2025 Koha Community Newsletter. Please send anything noteworthy to: mik (at) adminkuhn (dot) ch News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format crit

[Koha-devel] Koha Community Newsletter: May 2025

2025-05-28 Thread Michael Kuhn via Koha-devel
The Koha Community Newsletter for May 2025 is here: https://koha-community.org/koha-community-newsletter-may-2025/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to e-mail me (m...@adminkuhn.ch) with any corrections or suggestions. Michael Kuhn E

[Koha-devel] Call for news - Newsletter June 2025

2025-06-13 Thread Michael Kuhn via Koha-devel
Hi I'm collecting news for the June 2025 Koha Community Newsletter. Please send anything noteworthy to: mik (at) adminkuhn (dot) ch News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format cri

[Koha-devel] Koha Community Newsletter: May 2025

2025-06-27 Thread Michael Kuhn via Koha-devel
The Koha Community Newsletter for June 2025 is here: https://koha-community.org/koha-community-newsletter-june-2025/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to e-mail me (m...@adminkuhn.ch) with any corrections or suggestions. Michael Kuhn

[Koha-devel] Call for news - Newsletter July 2025

2025-07-13 Thread Michael Kuhn via Koha-devel
Hi I'm collecting news for the July 2025 Koha Community Newsletter. Please send anything noteworthy to: mik (at) adminkuhn (dot) ch News criteria: * Relevant news items can be of any length. * Images are fine. * Anything and everything Koha. * Submit by the 26th of the month. Text format cri

[Koha-devel] Koha Community Newsletter: July 2025

2025-07-26 Thread Michael Kuhn via Koha-devel
The Koha Community Newsletter for July 2025 is here: https://koha-community.org/koha-community-newsletter-july-2025/ Many thanks to everyone who submitted articles and news to this newsletter! Please feel free to e-mail me (m...@adminkuhn.ch) with any corrections or suggestions. Michael Kuhn