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

[Bug 27026] New: New circulation rule "Days mode" values are not explained anywhere
by bugzilla-daemon＠bugs.koha-community.org 18 Dec '20

18 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27026 Bug ID: 27026 Summary: New circulation rule "Days mode" values are not explained anywhere Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com It appears that the new Days mode value in the circulation conditions is not explained and the values are rather cryptic - especially if you are supposed to translate them: Calendar DateDue Days DayWeek Default There are references in the code, but I don't see where they show up visibly. And the DaysMode system preference doesn't use the codes so you can't make the connection there easily. Might be missing something, but glad to be told! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 30

[Bug 17320] New: MySQL 5.7 doesn't work well with SQL using '0000-00-00'
by bugzilla-daemon＠bugs.koha-community.org 18 Dec '20

18 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17320 Bug ID: 17320 Summary: MySQL 5.7 doesn't work well with SQL using '0000-00-00' Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: mtompset(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Several SQL statements in updatedatabase.pl have '0000-00-00'. A simple substitution to 0 will prevent a default MySQL 5.7 on Ubuntu from barfing. This patch will touch as far back as 3.0.6, but given the magnitude of other errors while upgrading, finding no 0000-00-00 barfs after the patch up to 3.9 and then finding no 0000-00-00 barfs from 3.14.x upwards seems sufficient to check. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 22

[Bug 25097] New: Add option to message_queue to allow for only specific sending notices
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '20

17 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25097 Bug ID: 25097 Summary: Add option to message_queue to allow for only specific sending notices Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: joy(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The message_queue.pl currently will send all the messages queued up. It would be nice to have some control over which messages are to be sent. Example: We have libraries who only wanted to send 'hold notices' but not overdue, advance notice, etc during the covid-19 quarantine. And some that were the opposite - turn off hold notices, but send other generated notices. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 17

[Bug 25583] New: When ClaimReturnedLostValue is not set, the claim returned tab doesn't appear
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '20

17 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25583 Bug ID: 25583 Summary: When ClaimReturnedLostValue is not set, the claim returned tab doesn't appear Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When you add a 'claimed returned' to an item, but ClaimReturnedLostValue is not set, the "Claims" tab won't display and cause some confusion. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 22

[Bug 26946] New: Limit size of cash register's name on the UI
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '20

17 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26946 Bug ID: 26946 Summary: Limit size of cash register's name on the UI Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Staff Client Assignee: martin.renvoize(a)ptfs-europe.com Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Depends on: 23321 If you create a new cash register with a "long" (not that long actually) name, the submit form fails with: 2020/11/06 09:56:19] [WARN] DBD::mysql::st execute failed: Data too long for column 'name' at row 1 [for Statement "INSERT INTO `cash_registers` ( `branch`, `description`, `name`, `starting_float`) VALUES ( ?, ?, ?, ? )" with ParamValues: 0="CPL", 1="<script>alert("â¤");</script>", 2="<script>alert("â¤");</script>", 3="0.00"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1836. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23321 [Bug 23321] Add 'cash registers' to the accounts system -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 16067] New: Koha::Cache, fastmmap caching system is broken
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '20

17 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16067 Bug ID: 16067 Summary: Koha::Cache, fastmmap caching system is broken Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: abl(a)biblos.pk.edu.pl QA Contact: testopia(a)bugs.koha-community.org After Bug 11998, fastmmap caching system implementation in Koha::Cache ceased to work properly. If fastmmap is enabled (= environment variable CACHING_SYSTEM is set to 'fastmmap'), any CGI script call causes the following error: Use of uninitialized value $db_name in concatenation (.) or string at /home/koha/devkohaclone/Koha/Database.pm line 73. Use of uninitialized value $db_host in concatenation (.) or string at /home/koha/devkohaclone/Koha/Database.pm line 73. DBI connect('database=;host=;port=','',...) failed: Access denied for user 'koha'@'localhost' (using password: NO) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1249 DBIx::Class::Storage::DBI::dbh(): DBI Connection failed: Access denied for user 'koha'@'localhost' (using password: NO) at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1253. at /home/koha/devkohaclone/Koha/Database.pm line 90 To reproduce on command line: 0) ensure that you have fastmmap perl module installed (libcache-fastmmap-perl in debian) 1) export CACHING_SYSTEM=fastmmap 2) export GATEWAY_INTERFACE=1 3) try to run this simple script: #!/usr/bin/perl use Modern::Perl; use C4::Biblio; GetMarcStructure(); -- You are receiving this mail because: You are watching all bug changes.

1 25

[Bug 26336] New: Cannot import items if items ignored when staging
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '20

17 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26336 Bug ID: 26336 Summary: Cannot import items if items ignored when staging Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal 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 When staging marc records you have the option to process or ignore items. If you choose to ignore you can change the option after staging, however, items are not processed unless they are parsed in initial staging To test: 0 - Check the count of import_items SELECT COUNT(*) FROM import_items; 1 - Import a marc file with items , process the items 2 - Check the count of import items, it has increased 3 - Stage the file again, do not process items 4 - Count of import_items has not increased 5 - Manage the stage batch, process items and reapply 6 - Check the count of import_items, no change 7 - Import the file, no items are processed -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 17

[Bug 26976] New: When reservesallowed is empty the UI is not correct
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '20

17 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26976 Bug ID: 26976 Summary: When reservesallowed is empty the UI is not correct Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com On the checkout list I am seeing """ 4 Not renewable (0 of renewals remaining) """ https://snipboard.io/rzOta6.jpg -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 15

[Bug 27079] New: UpdateFine adds refunds for fines paid off before return
by bugzilla-daemon＠bugs.koha-community.org 17 Dec '20

17 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27079 Bug ID: 27079 Summary: UpdateFine adds refunds for fines paid off before return Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Fines and fees Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The issue seems to be that the amount passed in to UpdateFine fails the comparison to $accountline->amount - one is $1.80 and the other is $1.80000 and comparison fails: 576 if ( $accountline ) { 577 if ( $accountline->amount != $amount ) { To recreate: 1 - Set a circ rule to have a .15 per day fine 2 - Issue an item of this type to a borrower 3 - Make it 12 days overdue either at checkout or in the db: UPDATE issues SET date_due = DATE_SUB(CURDATE(),INTERVAL 12 DAY); 4 - Run the fines job or just put a fine in place: INSERT INTO accountlines (issue_id,borrowernumber,itemnumber,amount,debit_type_code,status,amountoutstanding) SELECT issue_id,5,itemnumber,1.80,'OVERDUE','UNRETURNED',1.80 FROM issues WHERE borrowernumber=5; 5 - Pay the fine for the patron 6 - Check in the item 7 - Note that the patron has an 'Overpayment refund' of $0.00 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 32

[Bug 27092] New: Remove note about "synced mirror" from the README.md
by bugzilla-daemon＠bugs.koha-community.org 16 Dec '20

16 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=27092 Bug ID: 27092 Summary: Remove note about "synced mirror" from the README.md Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: trivial Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org Now it's displayed on our git.k-c.org by gitea, we should remove **Note:** This is a synced mirror of the official Koha repo. -- You are receiving this mail because: You are watching all bug changes.

1 8