December 2023 - Koha-bugs - lists.koha-community.org

[Bug 23272] New: Koha::AuthorisedValue should use Koha::Object::Limit::Library
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '24

31 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23272 Bug ID: 23272 Summary: Koha::AuthorisedValue should use Koha::Object::Limit::Library 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: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Koha::Patron::Attribute::Type should be used as example. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 30

[Bug 28366] New: Add batch patron modification to patron search results
by bugzilla-daemon＠bugs.koha-community.org 31 Jan '24

31 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28366 Bug ID: 28366 Summary: Add batch patron modification to patron search results Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com I think it would be useful to be able to pass checked patron search results to batch patron modification without going through the step of adding them to a list. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 18

[Bug 31969] New: Options for cleanup_database.pl to remove finished jobs from the background job queue
by bugzilla-daemon＠bugs.koha-community.org 30 Jan '24

30 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31969 Bug ID: 31969 Summary: Options for cleanup_database.pl to remove finished jobs from the background job queue Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: bjorn.nylen(a)ub.lu.se QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com The background jobs queue will need purging of finished jobs. Bug 31629 focuses on the elastic indexing jobs but the table will fill up with other types of jobs -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 38

[Bug 35165] New: Batch item deletions are run in a single transaction and cause locking issues
by bugzilla-daemon＠bugs.koha-community.org 30 Jan '24

30 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35165 Bug ID: 35165 Summary: Batch item deletions are run in a single transaction and cause locking issues Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org We recently saw a site perform a batch deletion of ~18k items (and subsequently 2k bibs) While running the jobs we suddenly started seeing all sorts of actions fail, most notably placing reserves, and errors in the logs like: DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Lock wait timeout exceeded; try restarting transaction at /usr/share/koha/lib/Koha/Object.pm line 170 I believe part of the problem is that the entire batch deletion is a single transaction. While we should make parts of this atomic, I don't think the entire job should succeed or fail on an error. I think we should commit each item, then each bib, then continue. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 27

[Bug 23487] New: Utf8mb4 collation causes problems with missing tables when upgrading the database
by bugzilla-daemon＠bugs.koha-community.org 30 Jan '24

30 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23487 Bug ID: 23487 Summary: Utf8mb4 collation causes problems with missing tables when upgrading the database Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: andreas.hedstrom.mace(a)sub.su.se QA Contact: testopia(a)bugs.koha-community.org Changing the default encoding to utf8mb4 and collation to utf8mb4_unicode_ci, can create duplicate unique keys as it ignores differences in accented characters vs non-accented characters. An example would be the Swedish letter ö, which is treated like the letter o. More is discussed here: https://stackoverflow.com/questions/47119794/mysql-mariadb-unable-to-handle… When upgrading a large database to any version with the new encoding and collation, there is a chance of duplicate unique keys crashing the collation change of the table (or tables) and as a result corrupting InnoDB tablespace. The final result is one or more tables that both exist and don't exist, and thus can't be deleted or created again. We, not so fondly, called them Schrödinger's tables. For Stockholm University Library, we had about 30 duplicate unique keys in the borrowers table (out of ~220K patrons), mostly in userid. Which crashed the database every time we tried to upgrade until we found the cause. The workaround solution was to change/remove these duplicates, but perhaps a better solution for the community would be to change the default encoding/collation for columns with unique keys? Perhaps utf8mb4_bin? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 7

[Bug 33966] New: "Update and run SQL" for non-English templates
by bugzilla-daemon＠bugs.koha-community.org 30 Jan '24

30 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33966 Bug ID: 33966 Summary: "Update and run SQL" for non-English templates Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Bug 23824 unfortunately introduced issues when the "Update and run SQL" button is used in translated templates. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 18

[Bug 35343] New: record method, required for bug 26611, missing from Koha::Authority
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '24

29 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35343 Bug ID: 35343 Summary: record method, required for bug 26611, missing from Koha::Authority Change sponsored?: --- Product: Koha Version: 22.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Bug 26611 was backported to 22.11.x, but missed that Koha::Authority->record was added in bug 31794. We need the record method adding for 22.11 to prevent code explosions when matches are found. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 16

[Bug 27767] New: Batch delete from cart doesn't change the number of items
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '24

29 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27767 Bug ID: 27767 Summary: Batch delete from cart doesn't change the number of items Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: david(a)davidnind.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Using the staff interface, if you use the 'Batch delete' option in the cart: - the items are deleted, - they no longer appear in the list of items in the cart, - but the number of items shown as in the cart (next to the menu icon) stays the same (that is, it isn't reduced). For example, 5 items added, 2 items batch deleted, only three items are listed in the cart, the number of items in the cart still shows as 5 (Cart (5)). To replicate using the staff interface: 1. Add some items to a cart. 2. Note the number of items shown next to the cart menu icon in brackets. 3. Open the cart. 4. Select one or more items. 5. Select 'Batch delete'. 6. Delete the items. 7. Open the cart again. 8. The items deleted are no longer listed. 9. The number of items in the cart has not changed. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 8

[Bug 32377] New: GetBudgetHierarchy slows down acqui/histsearch.pl
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '24

29 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32377 Bug ID: 32377 Summary: GetBudgetHierarchy slows down acqui/histsearch.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: emmi.takkinen(a)koha-suomi.fi QA Contact: testopia(a)bugs.koha-community.org Like in bug 30359, when acqui/histsearch.pl is opened and there are lot of budgets, loading the page takes a long time. Bug 30359 added parameter skiptotals to GetBudgetHierarchy. We should set this parameter also to call of GetBudgetHierarchy in acqui/histsearch.pl. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 17

[Bug 19372] New: Selecti MARC framework doesn' t work when adding to basket from an external source
by bugzilla-daemon＠bugs.koha-community.org 29 Jan '24

29 Jan '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19372 Bug ID: 19372 Summary: Selecti MARC framework doesn't work when adding to basket from an external source Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: mglavica(a)ffzg.hr QA Contact: testopia(a)bugs.koha-community.org In acquisitions, when adding items to basket from an external source there is an option to select MARC framework. No matter what we choose, the record is created in default framework. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 20