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

[Bug 33960] New: Add ability to retrieve deleted biblios
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '24

11 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33960 Bug ID: 33960 Summary: Add ability to retrieve deleted biblios Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: REST API Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com CC: tomascohen(a)gmail.com To add ability for discovery services to use the REST api to keep up to date, we need a way to retrieve information on deleted biblios. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 76

[Bug 37389] New: ILL requests table hangs when searching
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '24

11 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37389 Bug ID: 37389 Summary: ILL requests table hangs when searching Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: ILL Assignee: pedro.amorim(a)ptfs-europe.com Reporter: pedro.amorim(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: liz(a)bywatersolutions.com, martin.renvoize(a)ptfs-europe.com, pedro.amorim(a)ptfs-europe.com, tomascohen(a)gmail.com Depends on: 30645 (In reply to Tomás Cohen Arazi from comment #38) > I'm not sure if this is a problem with the ILL requests DT only, but I have: > > > SELECT COUNT(*) FROM illrequests; > 54 > > SELECT COUNT(*) FROM illrequestattributes; > 754 > > That'd be -roughly- around 13/14 different attributes per request. > > Using the DT filter box for searching "fra" is generating this query: > > ```sql > SELECT COUNT( * ) FROM (SELECT `me`.`illrequest_id` FROM `illrequests` `me` > LEFT JOIN `illrequestattributes` `extended_attributes` ON > `extended_attributes`.`illrequest_id` = `me`.`illrequest_id` LEFT JOIN > `illrequestattributes` `extended_attributes_2` ON > `extended_attributes_2`.`illrequest_id` = > `me`.`illrequest_id` LEFT JOIN `illrequestattributes` > `extended_attributes_3` ON `extended_attributes_3`.`illrequest_id` = > `me`.`illrequest_id` LEFT JOIN `illrequestattributes` > `extended_attributes_4` ON `extended_attributes_4`.`illrequest_id` = > `me`.`illrequest_id` LEFT JOIN `illrequestattributes` > `extended_attributes_5` ON `extended_attributes_5`.`illrequest_id` = > `me`.`illrequest_id` LEFT JOIN `illrequestattributes` > `extended_attributes_6` ON `extended_attributes_6`.`illrequest_id` = > `me`.`illrequest_id` LEFT JOIN `illrequestattributes` > `extended_attributes_7` ON `extended_attributes_7`.`illrequest_id` = > `me`.`illrequest_id` LEFT JOIN `illrequestattributes` > `extended_attributes_8` ON `extended_attributes_8`.`illrequest_id` = > `me`.`illrequest_id` LEFT JOIN `illbatches` `ill_batch` ON > `ill_batch`.`ill_batch_id` = `me`.`batch_id` JOIN `branches` `library` ON > `library`.`branchcode` = `me`.`branchcode` LEFT JOIN `borrowers` `patron` ON > `patron`.`borrowernumber` = `me`.`borrowernumber` WHERE ( ( ( `me`.`cost` > LIKE '%fra%' OR `me`.`placed` LIKE '%fra%' OR `me`.`status` LIKE '%fra%' OR > `me`.`backend` LIKE '%fra%' OR `me`.`orderid` LIKE '%fra%' OR `me`.`replied` > LIKE '%fra%' OR `me`.`updated` LIKE '%fra%' OR `me`.`accessurl` LIKE '%fra%' > OR `me`.`biblio_id` LIKE '%fra%' OR `me`.`completed` LIKE '%fra%' OR > `me`.`notesopac` LIKE '%fra%' OR `me`.`notesstaff` LIKE '%fra%' OR > `me`.`price_paid` LIKE '%fra%' OR `ill_batch`.`name` LIKE '%fra%' OR > `me`.`illrequest_id` LIKE '%fra%' OR `library`.`branchname` LIKE '%fra%' OR > ( `extended_attributes_8`.`type` = 'type' AND > `extended_attributes_8`.`value` LIKE '%fra%' ) OR ( > `extended_attributes_6`.`type` = 'year' AND `extended_attributes_6`.`value` > LIKE '%fra%' ) OR ( `extended_attributes_4`.`type` = 'issue' AND > `extended_attributes_4`.`value` LIKE '%fra%' ) OR ( > `extended_attributes_7`.`type` = 'pages' AND `extended_attributes_7`.`value` > LIKE '%fra%' ) OR ( `extended_attributes_2`.`type` = 'title' AND > `extended_attributes_2`.`value` LIKE '%fra%' ) OR ( > `extended_attributes`.`type` = 'author' AND `extended_attributes`.`value` > LIKE '%fra%' ) OR ( `extended_attributes_5`.`type` = 'volume' AND > `extended_attributes_5`.`value` LIKE '%fra%' ) OR ( > `extended_attributes_3`.`type` = 'article_title' AND > `extended_attributes_3`.`value` LIKE '%fra%' ) OR `patron`.`surname` LIKE > '%fra%' OR `patron`.`firstname` LIKE '%fra%' OR `patron`.`cardnumber` LIKE > '%fra%' ) AND `status` NOT IN ( 'COMP' ) AND ( `status_alias` NOT IN ( > 'COMP' ) OR `status_alias` IS NULL ) ) ) GROUP BY `me`.`illrequest_id`) `me`; > ``` > > which kills MariaDB \o/ I can reproduce. It's bad. Taking a look. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30645 [Bug 30645] Generated DBIC query incorrect for API searches across joined extended attributes when several terms are passed -- You are receiving this mail because: You are watching all bug changes.

1 71

[Bug 37082] New: Content warning repeating in staff client search results
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '24

11 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37082 Bug ID: 37082 Summary: Content warning repeating in staff client search results Change sponsored?: --- Product: Koha Version: 23.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff interface Assignee: koha-bugs(a)lists.koha-community.org Reporter: wainuiwitikapark(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com To replicate the issue: - Set syspref "ContentWarningField" to "590" - Administration > MARC bibliographic frameworks - Default framework > Actions > MARC structure - Search for 590 - Tag 590 > Actions > View subfields - Subfield a > Edit > Advanced constraints > Visibility > Make sure "Staff interface", and "Editor" boxes are checked - Save changes - Do a catalogue search - Click on a result - Edit > Edit record - Settings > Choose Default - Go to tab 5 > field 590 - Add something to 590 local note field - Observe details page of record - content warning looks correct - Observe search results page of record - content warning repeats itself - it is displayed twice -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 7

[Bug 17600] New: Standardize the EXPORT
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '24

11 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17600 Bug ID: 17600 Summary: Standardize the EXPORT Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org On bug 17591 we discovered that there was something weird going on with the way we export and use subroutines/modules. I tried to standardize our EXPORT to use EXPORT_OK only. -- You are receiving this mail because: You are watching all bug changes.

1 215

[Bug 34136] New: Add ability to render a report using a notice template
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '24

11 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34136 Bug ID: 34136 Summary: Add ability to render a report using a notice template Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Sometimes it is useful to display the results of a report in a non-table format. We should be able to create notice templates to render reports. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 36

[Bug 30965] New: Add patron autocomplete search to curbside pickups
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '24

11 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30965 Bug ID: 30965 Summary: Add patron autocomplete search to curbside pickups Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Circulation Assignee: jonathan.druart+koha(a)gmail.com Reporter: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Depends on: 30578, 30650 So far it's only possible to search for patrons by cardnumber. We should add the regular patron autocomplete search to allow search by surname and firstname. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30578 [Bug 30578] We should drop circ/ysearch.pl in preference to using the REST API's https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30650 [Bug 30650] Convert the Curbside Pickup plugin to Koha core -- You are receiving this mail because: You are watching all bug changes.

1 25

[Bug 37525] New: [SCO] Regression in 32256: "Return this item" doesn't show up despite SCOAllowCheckin being allowed
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '24

11 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37525 Bug ID: 37525 Summary: [SCO] Regression in 32256: "Return this item" doesn't show up despite SCOAllowCheckin being allowed Change sponsored?: --- Product: Koha Version: 24.05 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Self checkout Assignee: koha-bugs(a)lists.koha-community.org Reporter: oliver.behnke(a)aei.mpg.de QA Contact: testopia(a)bugs.koha-community.org Created attachment 169856 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=169856&action=e… Patch to fix the regression There's a regression in bug 32256 and commit bb059abe respectively: https://gitlab.com/koha-community/Koha/-/commit/bb059abe90#a22dc682a84c4167… The refactoring of "renew" -> "c.renew" missed this line (at least), so the condition is never met. The attached patch should do. Thanks -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 35

[Bug 36487] New: Add an option to add new conditions for processing failure_code on members/notices.pl
by bugzilla-daemon＠bugs.koha-community.org 11 Dec '24

11 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36487 Bug ID: 36487 Summary: Add an option to add new conditions for processing failure_code on members/notices.pl Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: anni.rajala(a)turku.fi QA Contact: testopia(a)bugs.koha-community.org At the moment on borrowers notices.pl page there is a column "Delivery note" that displays the reason the delivery has failed. The reason is displayed based on the following conditions: [% IF ( QUEUED_MESSAGE.failure_code ) %] [% IF ( QUEUED_MESSAGE.failure_code == "INVALID_BORNUMBER" ) %]Invalid borrowernumber [% borrowernumber | html %] [% ELSIF ( QUEUED_MESSAGE.failure_code == 'NO_EMAIL' ) %]Unable to find an email address for this borrower [% ELSIF (matches = QUEUED_MESSAGE.failure_code.match('INVALID_EMAIL:(\w+)') ) %]Invalid [% matches.0 | html %] email address found [% borrowernumber | html %] [% ELSIF ( QUEUED_MESSAGE.failure_code == 'NO_FROM' ) %]Missing from email address [% ELSIF ( QUEUED_MESSAGE.failure_code == 'MISSING_SMS' ) %]Missing SMS number [% ELSIF ( QUEUED_MESSAGE.failure_code == 'DUPLICATE_MESSAGE' ) %]Message is duplicate [% ELSIF ( QUEUED_MESSAGE.failure_code == 'NO_NOTES' ) %]No notes from SMS driver [% ELSIF ( QUEUED_MESSAGE.failure_code == 'SENDMAIL' ) %]Unhandled email failure, check the logs for further details [% ELSIF ( QUEUED_MESSAGE.failure_code == "UNKNOWN_ERROR" ) %]Unknown error [% ELSE %]Error occurred while sending email. [% END %] [% END %] Sms providers might send back failure_codes outside that list. In those cases "Delivery note" -colum displays the text "Error occurred while sending email" which doesn't give the proper info for the librarian. If it would be possible to add your own ELSIF conditions, we could provide accurate information for the librarians dealing with the failed messages. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 16694] New: Limit SIP2 auth by patron attribute
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '24

10 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16694 Bug ID: 16694 Summary: Limit SIP2 auth by patron attribute Change sponsored?: Sponsored Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Authentication Assignee: magnus(a)libriotech.no Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org CC: dpavlin(a)rot13.org In Scandinavia "more open" (Swedish: "Meröppet", Norwegian: "Meråpent") is a hot issue at the moment. What this means is that patrons can use their card and password/PIN to lock themselves into the library even when staff is not around. Typically, this means that patrons can get access to the library building from 7 am to 11 pm, even if the library is only staffed from 8 am to 5 pm. Typically, SIP2 is used to communnicate between the "more open"-system and the ILS, specifically to authenticate the user with a username and password/PIN. Also, you want the ability to turn "more open" access on and off for patrons. An extended patron attribute with possible values of NULL/empty, 0 or 1 should serve well for this. SIP2 does not have a field for saying "this is a moreopen login", so we need a way to identify a SIP2 user as a moreopen user. My plan is to add another attribute to the login element in SIPConfig.xml to achieve this: <login id="koha" password="koha" delimiter="|" error-detect="enabled" institution="kohalibrary" patron-attribute="MEROPPET" /> "MEROPPET" is then the name of an extended patron attribute which can be set to NULL or 0 (patron should not have access to moreopen) or 1 (patron should have access). This should be flexible enough to allow other, similar schemes to use some other patron attribute. -- You are receiving this mail because: You are watching all bug changes.

1 43

[Bug 33909] New: Improve translation of title tags: Administration
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '24

10 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33909 Bug ID: 33909 Summary: Improve translation of title tags: Administration Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: testopia(a)bugs.koha-community.org Blocks: 33906 This patch will modify administration templates so that translatable strings in the <title> tag are wrapped in the correct translation function, e.g. [% t('Translate me') %] Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33906 [Bug 33906] [OMNIBUS] Improve translation of title tags -- You are receiving this mail because: You are watching all bug changes.

1 29