[Koha-devel] IMPORTANT: Koha hotfix

2024-04-11 Thread Tomas Cohen Arazi via Koha-devel
Hi everyone, we just identified an error on last week's releases and are publishing a quick update. Packages are generally available with the patched versions and should be applied. Source tarballs are a bit delayed but will be published as well. Thanks to all involved -- Tomás Cohen Arazi Thek

[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-11 Thread David Cook via Koha-devel
Hi Michael, I've noticed that a bunch of the database changes for the additional_contents table can half-complete and not fatally fail in very ungraceful ways. In this case, I'd say an earlier update probably failed to rename "idnew" to "id". Hopefully this was a test upgrade, because otherwi

[Koha-devel] Finding invalid XML characters in Koha data via SQL

2024-04-11 Thread David Cook via Koha-devel
Hi all, I just wanted to share a (MariaDB) SQL report that I wrote for finding bib records with invalid XML characters: select biblionumber from biblio_metadata where metadata REGEXP '[^\\x{0009}\\x{000A}\\x{000D}\\x{0020}-\\x{D7FF}\\x{E000}-\\x{FFFD}\\x{1000 0}-\\x{10}]+'; Newer versi

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

2024-04-11 Thread David Cook via Koha-devel
Alas, I couldn't think of a really clever way of doing the items table, so I think it'll need a Perl-based solution. I have a RepairRecord plugin, so I might do a version in that first, and if that goes well I could look at upstreaming a patch. David Cook Senior Software Engineer Prosenti

[Koha-devel] Bug 36586 - Self-checkouts will get CSRF errors if left inactive for 8 hours

2024-04-11 Thread David Cook via Koha-devel
Hi all, We recently noticed that self-checkouts will generate CSRF errors when left unattended for over 8 hours (the lifetime of the CSRF token). Our solution is to use a timer to refresh the page every 8 hours or so, but open to other ideas. This will potentially affect Vue.js driven

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

2024-04-11 Thread Marcel de Rooy via Koha-devel
+1 Van: Koha-devel namens David Cook via Koha-devel Verzonden: vrijdag 12 april 2024 03:36 Aan: 'Koha-devel' Onderwerp: [Koha-devel] Finding invalid XML characters in Koha data via SQL Hi all, I just wanted to share a (MariaDB) SQL report that I wrote for f

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

2024-04-11 Thread Magnus Enger via Koha-devel
Hi! Den 12.04.2024 03:36, skrev David Cook via Koha-devel: Hi all, I just wanted to share a (MariaDB) SQL report that I wrote for finding bib records with invalid XML characters: select biblionumber from biblio_metadata where metadata REGEXP '[^\\x{0009}\\x{000A}\\x{000D}\\x{0020}-\\x{D7FF}

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

2024-04-11 Thread Magnus Enger via Koha-devel
Den 12.04.2024 04:13, skrev David Cook via Koha-devel: I have a RepairRecord plugin, so I might do a version in that first, and if that goes well I could look at upstreaming a patch… Intriguing! :-) Is it available somewhere? Best regards, Magnus _

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

2024-04-11 Thread David Cook via Koha-devel
Yeah, I was thinking it would be good to add to the SQL Report Library. I've just been flat out today... (but wanted to make sure I shared it with you folk at least) David Cook Senior Software Engineer Prosentient Systems Suite 7.03 6a Glen St Milsons Point NSW 2061 Australia Office: 02 9212 08

Re: [Koha-devel] Finding invalid XML characters in Koha data via SQL

2024-04-11 Thread David Cook via Koha-devel
Not yet. At some point I need to get better at sharing Koha plugins more widely. 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 -Original Message- From: Koha-devel On Behalf Of M