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

[Bug 29371] New: Built-in offline circulation broken in SQL strict mode
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29371 Bug ID: 29371 Summary: Built-in offline circulation broken in SQL strict mode Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation 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, testopia(a)bugs.koha-community.org Depends on: 29255 If Koha is in strict SQL mode and you try to Synchronize -> Download records in the built in offline circulation interface the process will fail: CGI::Compile::ROOT::kohadevbox_koha_offline_circ_download_2epl::get_data(): DBI Exception: DBD::mysql::st execute failed: 'koha_kohadev.borrowers.cardnumber' isn't in GROUP BY at /kohadevbox/koha/offline_circ/download.pl line 84 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29255 [Bug 29255] Built-in offline circulation broken with SQL error -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 3

[Bug 29357] New: "Results" in the results browser is untranslatable (intranet)
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29357 Bug ID: 29357 Summary: "Results" in the results browser is untranslatable (intranet) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: caroline.cyr-la-rose(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org CC: frederic(a)tamil.fr Hi all! I'm a bit skeptical about this one. I can't find a bug about it, and I can fathom that if it is indeed untranslatable, no one has opened one yet/noticed it ?! I doubt myself... When you are viewing a record from a list of results, a results browser appears above the biblio menu. The "Results" in that browser seems untranslatable. I found it in koha-tmpl/intranet-tmpl/prog/js/browser.js To find it: 1- In the staff interface, make a search for something vague enough that it will give you a couple of results ("cat" is usually good ;) ) 2- Click on the title of one of the results to access the biblio details page 3- On the left hand side, there should be a results browser, with "Results" and a back arrow and forward arrow This is the "Results" that is not translatable. I looked for it in fr-CA-staff-prog, fr-CA-messages and fr-CA-messages-js. Caroline -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 29353] New: Auth API tests can fail
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29353 Bug ID: 29353 Summary: Auth API tests can fail Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org I usually run `qa` with --run-tests as root. Tests are setting SessionStorage=tmp so you end up with root only permissions on the tmp directory: root@kohadevbox:koha(master)$ ls -l /var/lib/koha/kohadev/tmp/ drwxr-xr-x 2 root root 4096 Oct 28 12:02 cgisess_koha_kohadev And some REST API auth tests fail: t/db_dependent/api/v1/auth.t ........................... # Failed test '403 Forbidden' # at t/db_dependent/api/v1/auth.t line 75. # got: '401' # expected: '403' # Failed test 'exact match for JSON Pointer "/error"' # at t/db_dependent/api/v1/auth.t line 75. # got: 'Session has been expired.' # expected: 'Authorization failure. Missing required permission(s).' # Looks like you failed 2 tests of 20. t/db_dependent/api/v1/auth.t ........................... 1/3 # Failed test 'under() tests' # at t/db_dependent/api/v1/auth.t line 108. t/db_dependent/api/v1/auth.t ........................... 3/3 # Looks like you failed 1 test of 3. t/db_dependent/api/v1/auth.t ........................... Dubious, test returned 1 (wstat 256, 0x100) Failed 1/3 subtests t/db_dependent/api/v1/auth_authenticate_api_request.t .. 1/5 # Failed test '200 OK' # at t/db_dependent/api/v1/auth_authenticate_api_request.t line 131. # got: '401' # expected: '200' # Failed test 'The 'koha.user' object is defined in the stash' # at t/db_dependent/api/v1/auth_authenticate_api_request.t line 134. # Failed test 'userenv set correctly' # at t/db_dependent/api/v1/auth_authenticate_api_request.t line 137. # got: undef # expected: '141' # Failed test 'exact match for JSON Pointer ""' # at t/db_dependent/api/v1/auth_authenticate_api_request.t line 154. # Structures begin differing at: # $got->{error} = 'Session has been expired.' # $expected->{error} = 'Authentication failure.' # Looks like you failed 1 test of 3. # Failed test 'logged-out tests' # at t/db_dependent/api/v1/auth_authenticate_api_request.t line 157. # Looks like you planned 8 tests but ran 6. # Looks like you failed 4 tests of 6 run. # Failed test 'cookie-based tests' # at t/db_dependent/api/v1/auth_authenticate_api_request.t line 160. t/db_dependent/api/v1/auth_authenticate_api_request.t .. 4/5 # Looks like you failed 1 test of 5. t/db_dependent/api/v1/auth_authenticate_api_request.t .. Dubious, test returned 1 (wstat 256, 0x100) Failed 1/5 subtests -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 29347] New: Rename authorised_value fields that are actually categories
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29347 Bug ID: 29347 Summary: Rename authorised_value fields that are actually categories 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: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org See bug 29336. auth_subfield_structure.authorised_value auth_tag_structure.authorised_value marc_subfield_structure.authorised_value marc_tag_structure.authorised_value These should be authorised_value_category instead. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 29322] New: Date validation can be sketchy
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '23

24 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29322 Bug ID: 29322 Summary: Date validation can be sketchy 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: martin.renvoize(a)ptfs-europe.com Jonathan found some interesting errors with the date-time validation when writing extra tests for bug 24850. Passing: "due_date": "2021-10-27 23:59", Results in: => "Does not match date-time" But passing: "due_date": "2021-10-27 23:59:00", Results in: => "Missing property Shouldn't they both result in: => "Does not match date-time" -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 10

[Bug 29293] New: Display borrowers.othernames on patron search
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '23

24 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29293 Bug ID: 29293 Summary: Display borrowers.othernames on patron search Change sponsored?: --- Product: Koha Version: 20.05 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: enica(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When doing patron search, while searching for borrowers.othernames work, PatronAutoComplete only shows surname, firstname (cardnumber) <address>. It would be nice to show borrower.othernames, as well. If one searches for Smith, Jane (Jane being othernames), then Smith, Janet "Jane" (cardnumber) <address> would show, as well. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 29267] New: Link from detail view to Quick spine label creator
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '23

24 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29267 Bug ID: 29267 Summary: Link from detail view to Quick spine label creator Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org There could be a shortcut from the standard detail view to the Quick spine label creator, to save some clicks. This could perhaps be in a split button thingy with the "Edit" button on the right side of the items table. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 29256] New: Use LANG authorized values in advanced search
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '23

24 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29256 Bug ID: 29256 Summary: Use LANG authorized values in advanced search Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching Assignee: koha-bugs(a)lists.koha-community.org Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org In biblio records, language is edited using LANG authorized values, so we should also use it in advanced search filter. This will make is way easier to manage possible languages. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 7

[Bug 29235] New: Export/Import for testing
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '23

24 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29235 Bug ID: 29235 Summary: Export/Import for testing Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: cbrannon(a)cdalibrary.org QA Contact: testopia(a)bugs.koha-community.org Would love for there to be an export/import tool that could be used for environment setup and test data. The concept of this is that you could export the basic structure of your production server (not patrons or items, but css, jquery, reports, rules, preferences, etc), and import it quickly into a sandbox so you could test your setup against the master. Then, if you created sample items and patrons, export your setup and test data from the sandbox. That way you could reuse these setups against a sandbox easily without having to start from scratch. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 1

[Bug 29166] New: Browse system logs: add itemnumber to search limit
by bugzilla-daemon＠bugs.koha-community.org 24 Jun '23

24 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29166 Bug ID: 29166 Summary: Browse system logs: add itemnumber to search limit Change sponsored?: --- Product: Koha Version: 20.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: wdeschamps(a)prospertx.gov QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com In the Browse System Logs, "Object" limits search to borrowernumber." It would be great to also have the option to limit the search to itemnumber. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 1