June 2024 - Koha-bugs - lists.koha-community.org

[Bug 35799] New: Loading svc/cataloguing/framework bottlenecks advanced cataloging editor
by bugzilla-daemon＠bugs.koha-community.org 10 Oct '24

10 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35799 Bug ID: 35799 Summary: Loading svc/cataloguing/framework bottlenecks advanced cataloging editor Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: phil(a)chetcolibrary.org QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl, nick(a)bywatersolutions.com The advanced editor loads /cgi-bin/koha/svc/cataloguing/framework?frameworkcode=&callback=define with RequireJS, with a 30 second timeout and no failure handling. That gives you 30 seconds for request, generation, and download, or the advanced editor simply won't load and will sit with a progress indicator spinning forever (and in versions before bug 34275 landed, with no way to edit bibs without editing your cookie so you can get back to using the basic editor). There are two ways (plus the combination) to have it fail to load, generation or network. Network is easy enough to reproduce even in koha-testing-docker, since Firefox's devtools have network throttling that goes back to "Regular 2G" which will certainly time it out. Generation is a bit harder without a decent sized database: with 300K bibs and 600K authorities in my production database it's easy to either write reports that ExtractValue(biblio_metadata.metadata...) and run several at once, or to notice that authority search results actually support &resultsperpage=1000 despite not having UI to set it, and opening a few pages of a thousand authority records that require searching for the number of bibs using each of those thousands of authorities. svc/cataloguing/framework is a json representation of the requested framework plus all authorized values. Frameworks are incredibly compressible, consisting of things like 4273 instances of value_builder of which 4253 are "value_builder":"", but it's sent uncompressed, so 1.8MB for something that gzips to 160KB. It's sent with Cache-Control: no-cache and Pragma: no-cache headers, so even though it continues to load after the RequireJS timeout, just sitting waiting for it (I've had a painfully large number of times where it would consistently load in 31 or 32 seconds) and then reloading does no good. Not caching doesn't really do much of anything to ensure freshness, since if you stick to just one framework in an open instance of the editor, you won't ever reload svc/cataloguing/framework, but it does at least mean that if you know you've changed a framework and you don't see the change you can just open the editor in a new tab without having to actually clear the browser cache. The authorized values are too small of a percentage of the file size to make much difference there, but, they don't vary with the framework, so there's no reason to reload them for each change of framework, and they are 3/4 of the database connections (one for AV, one for itemtypes, one for classification sources), so loading them once separately probably would help for some generation-limited cases and certainly would for the combination of generation- and network-limited cases. Getting three db connections and then loading a tiny file in less than 30 seconds, then getting one db connection and loading a large file in less than a separate 30 seconds is easier than getting four connections and a large file in one 30 second period. Beyond that, there's no clear easy answer. Solving for my sketchy internet at home is easy, just gzip the json after generating it, but that adds server (though not db server) load. Okay, generate an already gzipped file once and serve that, after all, I typically only change my frameworks twice a year, how fresh do they need to be? But, editing frameworks consists of hundreds of tiny saves of each subfield of each tag, so making each one regenerate a static file is going to be painful. Okay, let the browser cache the output so at least a reload after getting it to load in 35 seconds works. Cache it for how long? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 13

[Bug 28805] New: Batch checkout shoudl have on-site checkout option
by bugzilla-daemon＠bugs.koha-community.org 09 Oct '24

09 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28805 Bug ID: 28805 Summary: Batch checkout shoudl have on-site checkout option Change sponsored?: --- Product: Koha Version: 20.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com The batch checkout is very useful, but currently doesn't support all advanced options of the normal search page. It's missing the "on-site checkout" functionality. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 44

[Bug 35651] New: Toggle for Advanced Editor should not show to staff without advanced_editor permissions
by bugzilla-daemon＠bugs.koha-community.org 09 Oct '24

09 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35651 Bug ID: 35651 Summary: Toggle for Advanced Editor should not show to staff without advanced_editor permissions Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: kelly(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Bug 34275 introduces a toggle button for users to move from the basic editor to the advanced editor easily. Currently, this toggle button shows to staff without the advanced editor permission. If a staff chooses to try to toggle to the advanced editor, they will be logged out. It would be best to not show the toggle button if the staff member does not have the advanced_editor permission. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 17

[Bug 34275] New: Add a button to easily toggle between advanced/basic cataloging editors
by bugzilla-daemon＠bugs.koha-community.org 09 Oct '24

09 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34275 Bug ID: 34275 Summary: Add a button to easily toggle between advanced/basic cataloging editors Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: lucas(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Some librarians/catalogers would find it handy if there was a way to more easily toggle between the advanced and basic cataloging editors. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 51

[Bug 35127] New: Patron search ignores searchtype from the context menu
by bugzilla-daemon＠bugs.koha-community.org 09 Oct '24

09 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35127 Bug ID: 35127 Summary: Patron search ignores searchtype from the context menu Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Go to Patrons. Click the right context menu. Select the other option than the one selected. (Depends on a pref.) Search for some user. Verify that the searchtype has not been used correctly. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 18

[Bug 34580] New: ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'DefaultPatronSearchMethod' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 741
by bugzilla-daemon＠bugs.koha-community.org 09 Oct '24

09 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34580 Bug ID: 34580 Summary: ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'DefaultPatronSearchMethod' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 741 Change sponsored?: --- Product: Koha Version: 23.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: egpetridis(a)yahoo.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Created attachment 154671 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=154671&action=e… Error screenshot While updating from 22.11 to 23.05 Updating database structure Update errors : Upgrade to 23.05.01.002 [22:40:49]: Bug 33117 - Patron checkout is not able to find patrons if using a second surname or other name during the search ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'DefaultPatronSearchMethod' for key 'PRIMARY' at /usr/share/koha/lib/C4/Installer.pm line 741 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 9

[Bug 34083] New: Patron auto-complete fails if organization patron full name is in a single field separated by a space
by bugzilla-daemon＠bugs.koha-community.org 09 Oct '24

09 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34083 Bug ID: 34083 Summary: Patron auto-complete fails if organization patron full name is in a single field separated by a space Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Patrons Assignee: pedro.amorim(a)ptfs-europe.com Reporter: pedro.amorim(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, jonathan.druart+koha(a)gmail.com, jonathan.field(a)ptfs-europe.com, katrin.fischer(a)bsz-bw.de, kyle.m.hall(a)gmail.com, martin.renvoize(a)ptfs-europe.com, nick(a)bywatersolutions.com, tomascohen(a)gmail.com Depends on: 32772 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32772 [Bug 32772] Patron autocomplete should not use contains on all fields -- You are receiving this mail because: You are watching all bug changes.

1 26

[Bug 30275] New: Checkout renewals should be stored in their own table
by bugzilla-daemon＠bugs.koha-community.org 09 Oct '24

09 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30275 Bug ID: 30275 Summary: Checkout renewals should be stored in their own table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org Bug 23838 highlighted the need to have a clear distinction between renewals and original issues. I propose the addition of a new table, issue_renewals, to store this data. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 263

[Bug 32517] New: Patron search dies on case mismatch of patron category
by bugzilla-daemon＠bugs.koha-community.org 09 Oct '24

09 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32517 Bug ID: 32517 Summary: Patron search dies on case mismatch of patron category Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Staff interface Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com We load the categories in JS for transforming category codes to names, however, this introduces case sensitivity To recreate: 1 - sudo koha-mysql kohadev 2 - UPDATE borrowers SET categorycode = LCASE(categorycode) 3 - Try to search for patrons: Uncaught TypeError: categories_map[data] is undefined -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 26

[Bug 31002] New: Add ability to send notices over instant messaging services
by bugzilla-daemon＠bugs.koha-community.org 09 Oct '24

09 Oct '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31002 Bug ID: 31002 Summary: Add ability to send notices over instant messaging services Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org It would be great to add integration for sending notices via the various instant messaging services people use these days. * WhatsApp * Telegram * Signal * Teams * Slack I think we could work on the core infrastructure on one bug and then enable integrations via drivers or plugins similar to how SMS is dealt with. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 8