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

[Bug 28699] New: Noisy warns in checkauth when patron has no firstname
by bugzilla-daemon＠bugs.koha-community.org 16 Jul '21

16 Jul '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28699 Bug ID: 28699 Summary: Noisy warns in checkauth when patron has no firstname Change sponsored?: --- Product: Koha Version: master 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: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Firstname field is not required, however, we try to log it in checkauth: 888 Koha::Logger->get->debug(sprintf "AUTH_SESSION: (%s)\t%s %s - %s", map { $session->param($_) || "" } qw(cardnumber firstname surname branch)); This causes a warn in the logs: [2021/07/09 13:22:54] [WARN] Use of uninitialized value in sprintf at /kohadevbox/koha/C4/Auth.pm line 888. To recreate: 1 - Remove first name from a patron 2 - tail -f /var/log/koha/kohadev/plack-opac-error.log 3 - Login as that patron on the opac -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 11

[Bug 11879] Add a new field to patron record: main contact method
by bugzilla-daemon＠bugs.koha-community.org 16 Jul '21

16 Jul '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11879 Kyle M Hall <kyle(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|Pushed to master |RESOLVED --- Comment #209 from Kyle M Hall <kyle(a)bywatersolutions.com> --- Enhancement not backported for 21.05 -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14237] Allow bibs to be added to course without items
by bugzilla-daemon＠bugs.koha-community.org 16 Jul '21

16 Jul '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14237 Kyle M Hall <kyle(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |FIXED Status|Pushed to master |RESOLVED --- Comment #55 from Kyle M Hall <kyle(a)bywatersolutions.com> --- Enhancement not backported for 21.05.x -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 23571] New: fines.pl may block server
by bugzilla-daemon＠bugs.koha-community.org 16 Jul '21

16 Jul '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23571 Bug ID: 23571 Summary: fines.pl may block server Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: hagud(a)orex.es QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Under certain circunstances fines.pl may block a server. 1. if syspref calculate on return 2. If koha site has a big number of overdue items 3. there are puntual high number of checkin under this circunstances koha launches several fines.pl,each for every koha checkin, that overload cpu and make koha unresponsive This actions should be desiderable 1. fines.pl on return just calculate the user account, not all users Another option is possible, block fines.pl if there is another process running.. but perhaps option 1 is faster? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 56

[Bug 7021] patron category in the statistics table
by bugzilla-daemon＠bugs.koha-community.org 16 Jul '21

16 Jul '21

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

1 0

[Bug 7021] patron category in the statistics table
by bugzilla-daemon＠bugs.koha-community.org 16 Jul '21

16 Jul '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7021 Emmi Takkinen <emmi.takkinen(a)koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #29508|0 |1 is obsolete| | --- Comment #30 from Emmi Takkinen <emmi.takkinen(a)koha-suomi.fi> --- Created attachment 122883 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=122883&action=e… Bug 7021: patron category in the statistics table This patch populates the koha.statistics.usercode with borrowers.categorycode where it is easily available. Currently for statistics.type 'issue' OR 'localuse' OR 'renew'. Supplied a script to UPDATE the old statistics records. Have fun! To test: 1. Add loan for patron. 2. Check statistics table => 'usercode' column for this issue should now contain patrons categorycode To test add_statistics_borrowers_categorycode.pl: 1. Run add_statistics_borrowers_categorycode.pl 2. Check statistics table => all statistics which are type 'issue' OR 'localuse' OR 'renew' should now contain patrons categorycode in 'usercode' column Also prove that tests in t/db_dependent/Circulation.t still pass. Rebased-by: Emmi Takkinen <emmi.takkinen(a)koha-suomi.fi> -- You are receiving this mail because: You are watching all bug changes. You are the QA Contact for the bug.

1 0

[Bug 7021] patron category in the statistics table
by bugzilla-daemon＠bugs.koha-community.org 16 Jul '21

16 Jul '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7021 --- Comment #29 from Emmi Takkinen <emmi.takkinen(a)koha-suomi.fi> --- Created attachment 122882 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=122882&action=e… DO NOT PUSH! Schema changes -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.

1 0

[Bug 7021] patron category in the statistics table
by bugzilla-daemon＠bugs.koha-community.org 16 Jul '21

16 Jul '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7021 Emmi Takkinen <emmi.takkinen(a)koha-suomi.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |emmi.takkinen(a)koha-suomi.fi Assignee|mathsabypro(a)gmail.com |emmi.takkinen(a)koha-suomi.fi --- Comment #28 from Emmi Takkinen <emmi.takkinen(a)koha-suomi.fi> --- Created attachment 122881 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=122881&action=e… Bug 7021: Reintroduce usercode column This patch reintroduces usercode column to statistics table. To test: 1. Apply patch and update database 2. Confirm there's column usercode in statistics table Sponsored-by: Koha-Suomi Oy -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.

1 0

[Bug 25664] New: login_attempts for imported borrowers can be set to NULL
by bugzilla-daemon＠bugs.koha-community.org 15 Jul '21

15 Jul '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25664 Bug ID: 25664 Summary: login_attempts for imported borrowers can be set to NULL Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org On bug 24379 there has been some conversation about login_attempts being set to null. While it doesn't seem to happen at creation it does during an import To recreate: 1 - Check your DB select distinct login_attempts from borrowers; 2 - All should be 0 (if you have some nulls already, thats ok) 3 - Run a report and download as CSV (you may need to set the delimiter syspref to comma) select surname, cardnumber, categorycode, branchcode FROM borrowers 4 - Tools -> Import borrowers 5 - Set to match on cardnumber and overwrite patrons 6 - Check the DB after import select distinct login_attempts from borrowers; 7 - All login_attempts are NULL -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 28643] New: On import, if login_attempts is not specified, it throws an error
by bugzilla-daemon＠bugs.koha-community.org 15 Jul '21

15 Jul '21

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28643 Bug ID: 28643 Summary: On import, if login_attempts is not specified, it throws an error Change sponsored?: --- Product: Koha Version: 19.11 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 importing borrowers in the staff client, it requires you to specify a borrowers.login_attempts value of '0'. DBD::mysql::st execute failed: Column 'login_attempts' cannot be null [for Statement "INSERT INTO `borrowers` File has branchcode, cardnumber, categorycode, surname, firstname, sort1. Work around: add login_attempts with '0' value. Import works. Might be related to bug 25664? -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 1