November 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 14226] LC help in professional cataloging interface
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '19

15 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14226 Cori Lynn Arnold <carnold(a)dgiinc.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |carnold(a)dgiinc.com Resolution|--- |WORKSFORME Status|NEW |RESOLVED --- Comment #1 from Cori Lynn Arnold <carnold(a)dgiinc.com> --- Links to the LC documentation appear at the bottom of the browser page. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 13246] Item edit doesn't respect cn_source if not defined
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '19

15 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13246 Cori Lynn Arnold <carnold(a)dgiinc.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |carnold(a)dgiinc.com --- Comment #1 from Cori Lynn Arnold <carnold(a)dgiinc.com> --- Confirmed this is the behavior in 19.05. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11985] Auto insert MARC 005 (Date and Time of Latest Transaction) detail when saving new catalog record
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '19

15 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11985 Cori Lynn Arnold <carnold(a)dgiinc.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |carnold(a)dgiinc.com Resolution|--- |WORKSFORME Status|NEW |RESOLVED --- Comment #2 from Cori Lynn Arnold <carnold(a)dgiinc.com> --- Tested in Basic and Advanced Editor. Both interfaces automatically update the 005 with the current time upon hitting save. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 11447] Hide existing item(s) that is/are linked to the bibliographic record when adding a new item
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '19

15 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11447 Cori Lynn Arnold <carnold(a)dgiinc.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |carnold(a)dgiinc.com --- Comment #2 from Cori Lynn Arnold <carnold(a)dgiinc.com> --- Confirmed this is still the behavior in 19.05. Can we not just move this information to the bottom of the page below the interface for adding an item? -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 6529] Cataloging search issues - withdrawn, lost, on-order counts not displayed consistently
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '19

15 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6529 Cori Lynn Arnold <carnold(a)dgiinc.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution|--- |WORKSFORME CC| |carnold(a)dgiinc.com --- Comment #2 from Cori Lynn Arnold <carnold(a)dgiinc.com> --- This appears to be working in 19.05. https://paste.pics/5051b7c195f7ae3ebe320a781e3b9644 Although, a book that is "Lost and Paid for" only shows up as "Lost" in the Cataloging search. -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.

1 0

[Bug 9589] Authorities to authorities linker
by bugzilla-daemon＠bugs.koha-community.org 14 Nov '19

14 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9589 Marjorie Barry-Vila <marjorie.barry-vila(a)collecto.ca> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |marjorie.barry-vila@collect | |o.ca -- You are receiving this mail because: You are watching all bug changes.

1 0