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

[Bug 35462] New: "savepoint_0 does not exist" when saving patron
by bugzilla-daemon＠bugs.koha-community.org 06 Dec '23

06 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35462 Bug ID: 35462 Summary: "savepoint_0 does not exist" when saving patron Change sponsored?: --- Product: Koha Version: 22.11 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When trying to save a new patron, clicking on "Save" sends me right back to the form for adding the new patron, but some of the information I entered is missing (at least firstname and cardnumber). There is no error message displayed. I see this in the logs: ==> /var/log/koha/konaturvard/plack-error.log <== DBIx::Class::Storage::DBI::mysql::_exec_svp_release(): DBI Exception: DBD::mysql::db do failed: SAVEPOINT savepoint_0 does not exist at /usr/share/koha/lib/Koha/Object.pm line 170 Patron creation failed! - DBIx::Class::Storage::DBI::mysql::_exec_svp_release(): DBI Exception: DBD::mysql::db do failed: SAVEPOINT savepoint_0 does not exist at /usr/share/koha/lib/Koha/Object.pm line 170 The code around /usr/share/koha/lib/Koha/Object.pm line 170 looks like this (in "sub store"): 169 try { 170 return $self->_result()->update_or_insert() ? $self : undef; 171 } The error "Patron creation failed!" comes from members/memberentry.pl: 424 ### Error checks should happen before this line. 425 $nok = $nok || scalar(@errors); 426 if ((!$nok) and $nodouble and ($op eq 'insert' or $op eq 'save')){ 427 my $success; 428 if ($op eq 'insert'){ 429 # we know it's not a duplicate borrowernumber or there would already be an error 430 delete $newdata{password2}; 431 $patron = eval { Koha::Patron->new(\%newdata)->store }; 432 if ( $@ ) { 433 # FIXME Urgent error handling here, we cannot fail without relevant feedback 434 # Lot of code will need to be removed from this script to handle exceptions raised by Koha::Patron->store 435 warn "Patron creation failed! - $@"; # Maybe we must die instead of just warn 436 push @messages, {error => 'error_on_insert_patron'}; 437 $op = "add"; This happens in two different instances on the same server, but not on other servers with similar setups. Koha version: 22.11.10-2 (Debian packages) OS: Ubuntu 18.04.6 LTS DB: 10.3.38-MariaDB-0ubuntu0.20.04.1-log Must be related to bug 26639, I guess. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 8

[Bug 35485] New: Error staging authority MARC record if a match is found
by bugzilla-daemon＠bugs.koha-community.org 06 Dec '23

06 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35485 Bug ID: 35485 Summary: Error staging authority MARC record if a match is found Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: blocker Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: aleisha(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org To reproduce: 1. Set up a record matching rule Match threshold: 100 Record type: authority Matchpoint 1: Search index: local-number Score: 100 Tag: 001 2. Create an authority record 3. Save the authority record in any format (maybe marcxml) 4. Go to Stage MARC for import in Cataloguing Home 5. Upload your downloaded MARC for the authority record. Set the following settings: Record type: authority Record matching rule: Your new 001 matching rule 6. Stage for import. Notice the job FAILS. There appears to be no useful error messages in logs, but the job results say '1 records not staged because of MARC error' -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 5

[Bug 35497] New: Add a view of related import records to the details page
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '23

05 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35497 Bug ID: 35497 Summary: Add a view of related import records to the details page Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff interface Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Sometimes one is viewing a record in the staff interface, and would like to see when it was imported/overlaid - it would be nice to add a tab to view this information. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 5

[Bug 16959] New: E-mail alerts for saved searches
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '23

05 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16959 Bug ID: 16959 Summary: E-mail alerts for saved searches Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org It would be nice if Koha allowed to send e-mails to patrons when a new record is created for a saved search. Examples: - New records are added within a specific call number range - New records where the title contains certain words It should be possible to set this up individually per patron. -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 34850] New: MySQL 8 test suite output is full of warnings regarding mysql_native_password
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '23

05 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34850 Bug ID: 34850 Summary: MySQL 8 test suite output is full of warnings regarding mysql_native_password 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 "Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'" -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 32448] New: Datatable filtering problem whith hidden column
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '23

05 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32448 Bug ID: 32448 Summary: Datatable filtering problem whith hidden column Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org In biblio record details page for items table : When a column is hidden, the column filters seems have problem. Test plan for KTD : 1) Go to /cgi-bin/koha/catalogue/detail.pl?biblionumber=312 2) See that by default in items table columns 'Checkouts' and 'Renewals' (after 'Last seen') are hidden by default 3) Activate filters 4) Search in column 'Date accessioned' with '2', no results 5) Hide column 'Item type' 6) Search in column 'Collection' with 'e', no results Looks like the search is performed on next column. 7) Search in column 'Home library' with 'Reference', no line is filtered! -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 30406] New: Our DT tables not filtering on the correct column if hidden by default
by bugzilla-daemon＠bugs.koha-community.org 05 Dec '23

05 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30406 Bug ID: 30406 Summary: Our DT tables not filtering on the correct column if hidden by default 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: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org To recreate, hide city_state for the cities table, create some cities and notice that using the "Country" column filter will actually filter on the hidden "State" column (the one on the left) Coming from bug 30063 comment 23 (point 5) -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 19

[Bug 35381] New: Add list_borrowers permission for viewing patron data
by bugzilla-daemon＠bugs.koha-community.org 04 Dec '23

04 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35381 Bug ID: 35381 Summary: Add list_borrowers permission for viewing patron data Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: dcook(a)prosentient.com.au QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Currently, we need the "edit_borrowers" to view patron data, but this causes users to need an excessive level of permission to just view data. Let's add a "list_borrowers" subpermission so that a user can view the patron information but not add/update patrons. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4

[Bug 9799] Prompt for due date for specific item types
by bugzilla-daemon＠bugs.koha-community.org 04 Dec '23

04 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9799 Lisette Scheer <lisette.scheer(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lisette.scheer@bywatersolut | |ions.com -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 35480] New: Make it easier to customize dialog messages on opac-suggestions.tt
by bugzilla-daemon＠bugs.koha-community.org 04 Dec '23

04 Dec '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35480 Bug ID: 35480 Summary: Make it easier to customize dialog messages on opac-suggestions.tt Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: lucas(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Some librarians would like to customize the dialog messages that can appear: -A similar document already exists: {title} Click on "Confirm your suggestion" to ignore this message. -The manager you selected does not have sufficient permissions -The suggestion has not been added. A suggestion with this title already exists {title} If these strings were wrapped in a HTML id/class it would make this much easier. -- You are receiving this mail because: You are watching all bug changes.

1 0