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

[Bug 30899] New: Upgrade sometimes fails at "Upgrade to 21.11.05.004"
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '25

05 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30899 Bug ID: 30899 Summary: Upgrade sometimes fails at "Upgrade to 21.11.05.004" Change sponsored?: --- Product: Koha Version: 21.11 Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org I just ran a Debian package upgrade on a test server, from 21.11.04-2 to 21.11.06-1. Some of the upgrades ran just fine, while others stopped at 21.11.05.004: ... Upgrade to 21.11.05.003 [10:59:51]: Bug 30565 - Update table stockrotationrotas Upgrade to 21.11.05.004 [10:59:51]: Bug 30449 - Check borrower_attribute_types FK constraint ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'CONSTRAINT category_code_fk' at line 1 at /usr/share/koha/lib/C4/Installer.pm line 739 Upgrading database schema for <next site> ... The server has 79 instances on the server, and 19 of those were affected by this problem. So far I can not really see a pattern based on the age of the sites, or similar things. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 51

[Bug 11530] Recalculating an item's total issue count with update_totalissues.pl ignores deleted items
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '25

05 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11530 --- Comment #9 from Victor Grousset/tuxayo <victor(a)tuxayo.net> --- Created attachment 177523 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=177523&action=e… Bug 11530: (QA follow-up): fix terminology Even if the script itself has the wrong terminology (issue vs checkout). The POD and help can have the right one. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11530] Recalculating an item's total issue count with update_totalissues.pl ignores deleted items
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '25

05 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11530 Victor Grousset/tuxayo <victor(a)tuxayo.net> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Failed QA CC| |victor(a)tuxayo.net -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11530] Recalculating an item's total issue count with update_totalissues.pl ignores deleted items
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '25

05 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11530 --- Comment #8 from Victor Grousset/tuxayo <victor(a)tuxayo.net> --- Comment on attachment 176300 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=176300 Bug 11530: Add a use-deleted-items option to totalissues.pl Review of attachment 176300: --> (https://bugs.koha-community.org/bugzilla3/page.cgi?id=splinter.html&bug=115…) ----------------------------------------------------------------- ::: misc/cronjobs/update_totalissues.pl @@ +113,5 @@ > sub process_items { > + my $query = > + $include_deleted > + ? "SELECT all_items.biblionumber, SUM(all_items.issues) FROM (SELECT items.biblionumber,items.issues FROM items UNION ALL SELECT deleteditems.biblionumber, deleteditems.issues FROM deleteditems) all_items GROUP BY all_items.biblionumber;" > + : "SELECT items.biblionumber, SUM(items.issues) FROM items GROUP BY items.biblionumber;"; Just a quick glance at code when passing by: some formatting of the SQL is needed: https://wiki.koha-community.org/wiki/Coding_Guidelines#SQL9:_SELECT -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 39037] New: Batch edit authority records
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '25

05 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39037 Bug ID: 39037 Summary: Batch edit authority records Change sponsored?: --- Product: Koha Version: 24.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: thaycock(a)spanishfork.gov QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Created attachment 177522 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=177522&action=e… Man-woman relationships Drama duplicates I would love to be able to batch edit and/or merge authorities. I know that our catalog has many many duplicate authority records, but it is very tedious trying to clean them up. It's also hard to search for them. It would be nice to be able to search for authority records the same way we search for MARC records, and be able to batch edit them the same way too. I'd like to to be able to select all of the duplicate "Man-woman relationships Drama" records at once and be able to merge them, rather than having to select two at a time to merge. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4

[Bug 39036] New: Batch edit MARC modification templates
by bugzilla-daemon＠bugs.koha-community.org 05 Feb '25

05 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39036 Bug ID: 39036 Summary: Batch edit MARC modification templates Change sponsored?: --- Product: Koha Version: 24.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: thaycock(a)spanishfork.gov QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Created attachment 177521 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=177521&action=e… The first few of 191 MARC modification templates For a while now I've been dreaming of being able to batch edit my MARC modification templates. I have 191 MARC modification templates at this moment, and many of them are the same except for one detail, the genre. It would be so amazing if I could edit all adult fiction MARC modification templates at once, or all teen nonfiction templates at once, etc. There are probably things I'd apply to almost all of the templates if I had the option. If there's a change I really want to make, I end up editing just one genre, deleting the others, and then duplicating it to make the others again but with the new change. I envision being able to select any or all of my templates, creating a new action, and applying it all at once. Or being able to edit an action in one template, and apply the same change to other templates. It would also be great to be able to delete an action from multiple items at the same time. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0

[Bug 37931] New: Wrong OPAC facet item types label
by bugzilla-daemon＠bugs.koha-community.org 04 Feb '25

04 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37931 Bug ID: 37931 Summary: Wrong OPAC facet item types label Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: lari.taskula(a)hypernova.fi QA Contact: testopia(a)bugs.koha-community.org Bug 36750 patch "Bug 36750: Fix some labels" missed OPAC item type label changes. https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=166289 -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 39030] New: Search results in the index, when in Arabic, are based on the letters that make up the searched word in the index. Therefore, the results display the entire index, unlike in French or English, where the results are accurate and based on complete words.
by bugzilla-daemon＠bugs.koha-community.org 04 Feb '25

04 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39030 Bug ID: 39030 Summary: Search results in the index, when in Arabic, are based on the letters that make up the searched word in the index. Therefore, the results display the entire index, unlike in French or English, where the results are accurate and based on complete words. Change sponsored?: --- Product: Koha Version: 24.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: riadilan(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: f.demians(a)tamil.fr, jonathan.druart(a)gmail.com Created attachment 177515 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=177515&action=e… pictur Search results in the index when in Arabic are based on the letters that make up the searched word in the index. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 39033] New: BlockExpiredPatronOpacActions set to block renewals gives 500 error if OverduesBlockRenewing set to "Allow"
by bugzilla-daemon＠bugs.koha-community.org 04 Feb '25

04 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39033 Bug ID: 39033 Summary: BlockExpiredPatronOpacActions set to block renewals gives 500 error if OverduesBlockRenewing set to "Allow" Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: heather(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com If a library has the system preference OverduesBlockRenewing set to "Allow" renewals of overdue items AND the system preference BlockExpiredPatronOpacActions set to block "Renewing an item," clicking the renew link from the Overdues tab of the expired patron's OPAC account generates a 500 error. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 0

[Bug 39009] New: Creating new patron "Preferred Name" is not working
by bugzilla-daemon＠bugs.koha-community.org 04 Feb '25

04 Feb '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39009 Bug ID: 39009 Summary: Creating new patron "Preferred Name" is not working Change sponsored?: --- Product: Koha Version: 24.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: julie(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com In 24.11.01 creating a new patron the "Preferred Name" field is not used in the new patron account. Instead the "First Name" is used. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 7