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

[Bug 23813] New: DB error on upgrade from 18.12 to 19.05.04
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '19

15 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23813 Bug ID: 23813 Summary: DB error on upgrade from 18.12 to 19.05.04 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org I just copied the DB from a gitified install running 18.1200014 to a standard Debian install of 19.05.04. When I ran "sudo koha-upgrade-schema <instance> I got this error: DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha_alingsas`.`circulation_rules`, CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement " INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) SELECT IF(categorycode='*', NULL, categorycode), IF(branchcode='*', NULL, branchcode), IF(itemtype='*', NULL, itemtype), 'maxissueqty', COALESCE( maxissueqty, '' ) FROM issuingrules "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 17545. DBD::mysql::db do failed: Cannot add or update a child row: a foreign key constraint fails (`koha_alingsas`.`circulation_rules`, CONSTRAINT `circ_rules_ibfk_3` FOREIGN KEY (`itemtype`) REFERENCES `itemtypes` (`itemtype`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement " INSERT INTO circulation_rules ( categorycode, branchcode, itemtype, rule_name, rule_value ) SELECT IF(categorycode='*', NULL, categorycode), IF(branchcode='*', NULL, branchcode), IF(itemtype='*', NULL, itemtype), 'maxonsiteissueqty', COALESCE( maxonsiteissueqty, '' ) FROM issuingrules "] at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 17554. Upgrade to 18.12.00.020 done (Bug 18925 - Move maxissueqty and maxonsiteissueqty to circulation_rules) I have not looked further into this yet, just thought I'd report it sooner rather than later. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 17

[Bug 19507] New: Add a sample CSV profile for exporting lost items
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '19

15 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19507 Bug ID: 19507 Summary: Add a sample CSV profile for exporting lost items Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) 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 Bug 9573 adds the possibility to export lost items using CSV profiles. It would be nice to have the example added to the web installer files: Title=biblio.title |Author=biblio.author |Lost status=items.itemlost |Lost on=items.itemlost_on |Barcode=items.barcode |Call number=items.itemcallnumber |Date last seen=items.datelastseen |Price=items.price |Rep. price=items.replacementprice |Library=items.homebranch |item type=items.itype |Current location=items.holdingbranch |Location=items.location |Not for loan status=items.notforloan |Notes=items.itemnotes -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 23868] New: PayPal payment button is never enabled
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '19

15 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23868 Bug ID: 23868 Summary: PayPal payment button is never enabled Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: andrew.isherwood(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org Enabling and configuring "EnablePayPalOpacPayments PayPalSandboxMode" works fine. But when it comes to paying a fine in the OPAC, the "Make payment" button is never enabled. It is disabled initially, but is supposed to be enabled if at least one fine is selected to be paid. This it the line that is supposed to enable it (now commented out): https://github.com/PTFS-Europe/koha/blob/master/koha-tmpl/opac-tmpl/bootstr… it was commented out as part of Bug 23213 - is this an oversight or is this functionality now superseded? -- You are receiving this mail because: You are watching all bug changes.

1 16

[Bug 23484] New: Holds to pull (pendingreserves.pl) uses removed default_branch_item_rules table
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '19

15 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23484 Bug ID: 23484 Summary: Holds to pull (pendingreserves.pl) uses removed default_branch_item_rules table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Hold requests 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 The report is broken -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 30

[Bug 23589] New: Discharge notice does not show non-latin characters
by bugzilla-daemon＠bugs.koha-community.org 14 Nov '19

14 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23589 Bug ID: 23589 Summary: Discharge notice does not show non-latin characters Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: theod(a)lib.auth.gr QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com The discharge notice skips any non latin characters, whether in notice body or in patron details. You can verify this by either: a) modifying the default discharge notice slip and entering a non latin string [ie. "Δοκιμή" (which means testing in Greek)] b) modifying a user firstname/lastname, etc and printing <<borrowers.firstname>> <<borrowers.surname>> in discharge notice slip In current master (Sep. 2019), in both cases, the non-latin strings will be skipped in the pdf output. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 24

[Bug 21180] New: Allow Talking Tech outbound script to limit based on patron home library branchcode
by bugzilla-daemon＠bugs.koha-community.org 14 Nov '19

14 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21180 Bug ID: 21180 Summary: Allow Talking Tech outbound script to limit based on patron home library branchcode Change sponsored?: --- Product: Koha Version: unspecified 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: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org A library system has requested the ability to limit which patrons are sent to Itivia for phone notices. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 16

[Bug 21985] New: Test t/db_dependent/Circulation.t fails if SearchEngine is set to elasticsearch
by bugzilla-daemon＠bugs.koha-community.org 14 Nov '19

14 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21985 Bug ID: 21985 Summary: Test t/db_dependent/Circulation.t fails if SearchEngine is set to elasticsearch 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: josef.moravec(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org The test t/db_dependent/Circulation.t fails with: not ok 106 - No tests run for subtest "CanBookBeIssued & AllowReturnToBranch" # Failed test 'No tests run for subtest "CanBookBeIssued & AllowReturnToBranch"' # at t/db_dependent/Circulation.t line 1302. Can't call method "leader" on an undefined value at /home/vagrant/kohaclone/Koha/SearchEngine/Elasticsearch.pm line 419. # Looks like your test exited with 255 just after 106. -- You are receiving this mail because: You are watching all bug changes.

1 28

[Bug 23101] New: Contracts permissions for staff patron
by bugzilla-daemon＠bugs.koha-community.org 14 Nov '19

14 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23101 Bug ID: 23101 Summary: Contracts permissions for staff patron Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: mbarham(a)birzeit.edu QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- Created attachment 90527 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=90527&action=ed… vendor page Dears, Koha 19.00 I have created a staff Patron with no Contracts permissions only ( Manage basket and order lines,Receive orders and manage shipments ) In the vendor page, the patron can view contracts and actions button are available (delete, edit), if he click one of those actions, will redirected to the login page. so, my recommendation, to remove those action bottoms at all if the user dont have the permission. Regards -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 21

[Bug 23688] New: System preference uppercasesurnames broken by typo
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23688 Bug ID: 23688 Summary: System preference uppercasesurnames broken by typo Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com In the process of moving this feature from memberentry.pl to Patron.pm, the 's' on uppercasesurnames was dropped, breaking the feature. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 15

[Bug 22804] New: OPAC Overdrive JavaScript contains untranslatable strings
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '19

13 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22804 Bug ID: 22804 Summary: OPAC Overdrive JavaScript contains untranslatable strings Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- There are several English strings in overdrive.js. These should be moved into the template so they can be translated. -- You are receiving this mail because: You are watching all bug changes.

1 12