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

[Bug 37903] New: Timezone ignored when passing rfc3339 formatted date (POST, PUT, PATCH)
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37903 Bug ID: 37903 Summary: Timezone ignored when passing rfc3339 formatted date (POST,PUT,PATCH) Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: REST API Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: tomascohen(a)gmail.com When requesting the REST API we are getting datetimes in the RFC3339 format, for instance: 2024-09-04T06:03:34-03:00 This is retrieving the value that is stored DB, and using the timezone defined in the $KOHA_CONF file. However this format is not correctly into account when we search or, more importantly, when we create/update objects. Examples (Using the Buenos Aires timezome, which is UTC-3 "America/Argentina/Buenos_Aires"): 1. POST /api/v1/patrons with "due_date": "2024-09-09T23:59:00-00:00", And you will get "due_date": "2024-09-09T23:59:00-03:00", in DB: date_due: 2024-09-09 23:59:00 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 10

[Bug 37952] New: Store datetime DB columns in UTC
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37952 Bug ID: 37952 Summary: Store datetime DB columns in UTC Change sponsored?: --- Product: Koha Version: unspecified 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: jonathan.druart(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org We need to store the datetime in UTC in DB and apply the timezone on display only. It will be more flexible and easier to maintain. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 12

[Bug 38216] New: Objects.t failing on D10 and U20
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38216 Bug ID: 38216 Summary: Objects.t failing on D10 and U20 Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: jonathan.druart(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org t/db_dependent/Koha/REST/Plugin/Objects.t .. 18/18 # Failed test 'No tests run for subtest "date handling"' # at t/db_dependent/Koha/REST/Plugin/Objects.t line 1041. Can't locate object method "rfc3339" via package "DateTime" at t/db_dependent/Koha/REST/Plugin/Objects.t line 1024. # Looks like your test exited with 255 just after 18. t/db_dependent/Koha/REST/Plugin/Objects.t .. Dubious, test returned 255 (wstat 65280, 0xff00) -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 37902] New: Timezone ignored when passing rfc3339 formatted date (search 'q')
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37902 Bug ID: 37902 Summary: Timezone ignored when passing rfc3339 formatted date (search 'q') Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: REST API Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: tomascohen(a)gmail.com 2. GET /api/v1/jobs?q={"enqueued_on":{">":"2024-09-04T09:26:52-03:00"}} is generating the following query SELECT `me`.`id`, `me`.`status`, `me`.`progress`, `me`.`size`, `me`.`borrowernumber`, `me`.`type`, `me`.`queue`, `me`.`data`, `me`.`context`, `me`.`enqueued_on`, `me`.`started_on`, `me`.`ended_on` FROM `background_jobs` `me` WHERE `enqueued_on` > '2024-09-04T09:26:52-03:00' But when you run it manually, you get a warning: | Warning | 1292 | Truncated incorrect datetime value: '2024-09-04T09:26:52-03:00' | -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 58

[Bug 38129] New: Add note regarding permissions in suggestion manager search pop-up modal
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38129 Bug ID: 38129 Summary: Add note regarding permissions in suggestion manager search pop-up modal Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: caroline.cyr-la-rose(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org There used to be a note in the patron search pop-up for suggestion manager selection that "Only staff with superlibrarian or suggestions_manage permissions are returned in the search results". This note is no longer there. To get there: 1. In the staff interface, go to More > Suggestions > New purchase suggestion 2. Click 'Select manager' --> Note that there is no note regarding the necessary permissions in the popup 3. Search for 'alford' (for example) --> There are no results because Jordan Alford doesn't have the necessary permissions For comparison: 1. In the staff interface, go to Acquisitions 2. Click 'Search' next to the vendor search box 3. Click 'My Basket' 4. Click 'Add user' --> Note that there is a note "Only staff with superlibrarian or acquisitions permissions (or order_manage permission if granular permissions are enabled) are returned in the search results" -- You are receiving this mail because: You are watching all bug changes.

1 13

[Bug 38197] New: OPAC and staff interface Bootstrap files are out of sync
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38197 Bug ID: 38197 Summary: OPAC and staff interface Bootstrap files are out of sync Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 35402 Probably as a consequence of the delay between my work on the Bootstrap upgrade and the OPAC and the staff interface, the version of Bootstrap in the OPAC is behind the version in the staff interface. These should be the same. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35402 [Bug 35402] Update the OPAC and staff interface to Bootstrap 5 -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 38608] New: Improve style of permissions filter form
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38608 Bug ID: 38608 Summary: Improve style of permissions filter form Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 35402 Created attachment 175084 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=175084&action=e… Screenshot showing the form field Following the Bootstrap upgrade the filter form on the user permissions page looks a little off. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35402 [Bug 35402] Update the OPAC and staff interface to Bootstrap 5 -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 37980] New: Login screen for the install is not styled correctly
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37980 Bug ID: 37980 Summary: Login screen for the install is not styled correctly Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Staff interface Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Depends on: 35402 Guess it's coming from the Bootstrap5 update: the login screen is not centered. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35402 [Bug 35402] Update the OPAC and staff interface to Bootstrap 5 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 15

[Bug 38057] New: Fix checkmarks in Change framework menu in Advanced editor after Bootstrap5 update
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38057 Bug ID: 38057 Summary: Fix checkmarks in Change framework menu in Advanced editor after Bootstrap5 update Change sponsored?: --- Product: Koha Version: Main Hardware: All OS: All Status: NEW Severity: normal Priority: P1 - high Component: Cataloging Assignee: phil(a)chetcolibrary.org Reporter: phil(a)chetcolibrary.org QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Depends on: 35402 The advanced editor apparently thought it could get away with using the class hidden from bootstrap.min.css to hide and show the checkmarks in the Settings menu next to framework names as you switch to a different framework. Boy did the Bootstrap5 upgrade show it that it was wrong, by just getting rid of bootstrap.min.css. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35402 [Bug 35402] Update the OPAC and staff interface to Bootstrap 5 -- You are receiving this mail because: You are watching all bug changes.

1 21

[Bug 38191] New: Suggestions filters do not expand
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '24

05 Dec '24

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38191 Bug ID: 38191 Summary: Suggestions filters do not expand Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Staff interface Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Depends on: 35402, 38190 The collapse/expand has been broken by bug 35402 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35402 [Bug 35402] Update the OPAC and staff interface to Bootstrap 5 https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38190 [Bug 38190] JS error on suggestion page -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 14