[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 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

[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

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

[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

[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