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

[Bug 27707] New: Renewing doesn't work when renewal notices are enabled
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27707 Bug ID: 27707 Summary: Renewing doesn't work when renewal notices are enabled Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: joonas.kylmala(a)helsinki.fi QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Depends on: 26639 Renewing loans doesn't work for patrons who have enabled renewal notices to be sent to them. To reproduce: 1) Enable RenewalSendNotice 2) Add some email address to patron and select the email box from the message preference "Item checkout and renewal" in order to receive renewal emails. 3) Checkout 4 items to the patron (maybe 1 is enough not quite sure) 4) Try to renew the loans in intranet and notice the progress icon circles forever and in the plack-error.log you have following error: > DBIx::Class::Storage::DBI::mysql::_exec_svp_release(): DBI Exception: DBD::mysql::db do failed: SAVEPOINT savepoint_0 does not exist [for Statement "RELEASE SAVEPOINT savepoint_0"] at /usr/share/koha/lib/C4/Circulation.pm line 3590 This bug seems to have started happening after bug 26639 was merged, i.e. AUTO SAVEPOINT was enabled. I have found a workaround and possibly it is also a reasonable solution: In C4/Circulation.pm function SendCirculationAlert there is this comment: > # LOCK TABLES is not transaction-safe and implicitly commits any active > transaction before attempting to lock the tables. So basically if that comment is true (I have not verified) then it means that the transaction that has been put around the "LOCK TABLE message_queue READ" stuff is doing nothing. And here based on the error message we got in plack-error.log the problem is that we are trying to commit a non-existent transaction because as per the comment in the code calling LOCK TABLE already commited the transaction so there is no transaction left for us to commit manually in the end. To summarise we need to remove the two lines I think: $schema->storage->txn_begin; $schema->storage->txn_commit; Also why I think the above solution is reasonable is because otherwise we need to rethought the design here totally on how the digest messages are sent and maybe add a new is_digest db column and do the logic in the message sending script instead of "merging db rows". For more background on why the table locking was introduced see bug 15854. PS. I think this bug might affect check-in and checkouts, not totally sure. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26639 [Bug 26639] Turn auto_savepoint ON -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 24

[Bug 20757] New: Capture a screenshot on selenium errors
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20757 Bug ID: 20757 Summary: Capture a screenshot on selenium errors Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Test Suite Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org It can be a real pain to debug selenium errors, especially when it is not reproducible locally. It would be great to capture a screenshot when an element is not found on the page for instance. -- You are receiving this mail because: You are watching all bug changes.

1 18

[Bug 25811] New: authentication.t is failing randomly
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25811 Bug ID: 25811 Summary: authentication.t is failing randomly Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: victor(a)tuxayo.net QA Contact: testopia(a)bugs.koha-community.org Two recent failures in the CI https://jenkins.koha-community.org/view/19.05/job/Koha_19.05_D8/244/console… https://jenkins.koha-community.org/view/19.05/job/Koha_19.05_U18/239/consol… And I could reproduce locally in Debian 10 on master. -- You are receiving this mail because: You are watching all bug changes.

1 37

[Bug 26033] New: framapic is closing
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26033 Bug ID: 26033 Summary: framapic is closing Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Test Suite Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org We use it to upload screenshot of our selenium failures. -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 18731] New: Orders table slow to load for vendors with many orders
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18731 Bug ID: 18731 Summary: Orders table slow to load for vendors with many orders Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Some libraries may have hundreds of open orders for a vendor, depending on acqisitions workflow. At that number of open orders, the tables on parcel.pl take 10 to 20 seconds to load. To speed up the loading of this page and the data, we should convert the order tables from pre-loading all order data to ajax tables that load order data on an as needed basis. That way we are only pulling the data for the orders that are currently visible. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 111

[Bug 18755] New: Allow empty password fields in Patron Info requests
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18755 Bug ID: 18755 Summary: Allow empty password fields in Patron Info requests Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: colin.campbell(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com Bug 16610 changed the behaviour of patron info requests and responses - previously if the password field was empty in the request, we returned password ok. Many sip clients assume that passing an empty pwd field means "I'm not validating a password - I just want to know patron is valid" and are failing because of the change in behaviour. As both scenarios are valid I suggest adding a parameter to the sip config to allow empty password fields to be treated as previously. To my knowledge this is only an issue in the patron info response. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 23

[Bug 14239] Bibframe support in Koha
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14239 Henry Bolshaw <bolshawh(a)parliament.uk> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |bolshawh(a)parliament.uk --- Comment #5 from Henry Bolshaw <bolshawh(a)parliament.uk> --- It sounds like BIBFRAME might be making some slow progress again: "The Library of Congress is planning for 2021 to be an expansion year for its BIBFRAME cataloging operation as a large project involves bringing all the cataloging staff into BIBFRAME. This means that interchange using both BIBFRAME and MARC will also expand, as will the potential for new developments for systems based on either format. This Update will hear about plans of Ex Libris for Linked Data -- How bridging the BIBFRAME and MARC workflows might work in the Folio development -- And an OCLC intent to be able to “adroitly” consume and export BIBFRAME data." https://www.loc.gov/bibframe/news/bibframe-update-mw2021.html -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14723] Additional delivery notes to messages
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14723 Emmi Takkinen <emmi.takkinen(a)koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Signed Off |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14723] Additional delivery notes to messages
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14723 --- Comment #43 from Emmi Takkinen <emmi.takkinen(a)koha-suomi.fi> --- Created attachment 120252 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=120252&action=e… Bug 14723: Add error codes and replace strings with them in template This patch adds error codes for delivery notes and replaces English strings with them in template. To test confirm that everything works according to the first test plan. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12017] Move language description out of database
by bugzilla-daemon＠bugs.koha-community.org 28 Apr '21

28 Apr '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12017 --- Comment #103 from David Cook <dcook(a)prosentient.com.au> --- (In reply to David Cook from comment #102) > Note that Chinese sorts using radical and stroke count. So English, French, > and Chinese would be sorted as '中文','法文','英文' (Chinese, French, English > respectively). > > That doesn't correspond to the more western-centric language codes. Then again maybe it is just doing a byte order sort... 中 = e4b8ad 法 = e6b395 英 = e88bb1 So I guess that theory is out the window. I think users without alphabets just suffer with Koha? -- You are receiving this mail because: You are watching all bug changes.

1 0