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

[Bug 11983] Code to select patrons to purge needs to be centralized (use of filter_by)
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11983 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks|20469 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20469 [Bug 20469] Add item status to staff article requests form -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 26020] New: Holds to pull report is broken in sql strict mode
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26020 Bug ID: 26020 Summary: Holds to pull report is broken in sql strict mode Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Hold requests 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 There is no error on the page, but it remains empty, even while holds queue shows you holds. The logs reveal: DBD::mysql::st execute failed: 'koha_kohadev.reserves.reserve_id' isn't in GROUP BY [for Statement "SELECT min(reservedate) as l_reservedate, reserves.reserve_id, reserves.borrowernumber as borrowernumber, GROUP_CONCAT(DISTINCT items.holdingbranch ORDER BY items.itemnumber SEPARATOR '|') l_holdingbranch, reserves.biblionumber, reserves.branchcode as l_branch, reserves.itemnumber, items.holdingbranch, items.homebranch, GROUP_CONCAT(DISTINCT items.itype ORDER BY items.itemnumber SEPARATOR '|') l_item_type, GROUP_CONCAT(DISTINCT items.location ORDER BY items.itemnumber SEPARATOR '|') l_location, GROUP_CONCAT(DISTINCT items.itemcallnumber ORDER BY items.itemnumber SEPARATOR '|') l_itemcallnumber, GROUP_CONCAT(DISTINCT items.enumchron ORDER BY items.itemnumber SEPARATOR '|') l_enumchron, GROUP_CONCAT(DISTINCT items.copynumber ORDER BY items.itemnumber SEPARATOR '|') l_copynumber, biblio.title, biblio.subtitle, biblio.medium, biblio.part_number, biblio.part_name, biblio.author, biblioitems.editionstatement, count(DISTINCT items.itemnumber) as icount, count(DISTINCT reserves.borrowernumber) as rcount, borrowers.firstname, borrowers.surname FROM reserves LEFT JOIN items ON items.biblionumber=reserves.biblionumber LEFT JOIN biblio ON reserves.biblionumber=biblio.biblionumber LEFT JOIN biblioitems ON biblio.biblionumber=biblioitems.biblionumber LEFT JOIN branchtransfers ON items.itemnumber=branchtransfers.itemnumber LEFT JOIN issues ON items.itemnumber=issues.itemnumber LEFT JOIN borrowers ON reserves.borrowernumber=borrowers.borrowernumber LEFT JOIN circulation_rules ON ( items.itype=circulation_rules.itemtype AND rule_name = 'holdallowed' AND circulation_rules.branchcode IS NULL AND circulation_rules.categorycode IS NULL ) WHERE reserves.found IS NULL AND reservedate >= ? AND reservedate <= ? AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber) AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL) AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL) AND issues.itemnumber IS NULL AND reserves.priority <> 0 AND reserves.suspend = 0 AND notforloan = 0 AND itemlost = 0 AND withdrawn = 0 AND ( circulation_rules.rule_value IS NULL OR circulation_rules.rule_value != 0 ) GROUP BY reserves.biblionumber ORDER BY biblio.title " with ParamValues: 0='2020-07-06', 1='2020-07-20'] at /home/vagrant/kohaclone/circ/pendingreserves.pl line 245. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4

[Bug 21067] New: Under plack, 500 errors only show as "Internal Server Error"
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21067 Bug ID: 21067 Summary: Under plack, 500 errors only show as "Internal Server Error" Change sponsored?: --- Product: Koha Version: master 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: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org When plack is not running, 500 errors will show the error message of the perl file where the error occurred, as well as a contact email address, something like this: 500 Internal Server Error Use of uninitialized value within @itemnumber in string ne at /usr/share/koha/intranet/cgi-bin/reserve/modrequest.pl line 70. To report a broken link or any other issue, please contact the Koha Administrator. (I think the text is actually from koha-tmpl/intranet-tmpl/prog/en/modules/errors/errorpage.tt) Under plack, all we see is Internal Server Error This means that a) Errors are less likely to be reported to the server administrator because there's no mailto. b) We can't immediately see the error message when the error is reported. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 20437] New: Force requirement for HTTP::OAI 3.27
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20437 Bug ID: 20437 Summary: Force requirement for HTTP::OAI 3.27 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: mirko(a)abunchofthings.net Until HTTP::OAI is patched so it actually works, and bug 17704 fixes the API change Koha-side, we need to explicitly pull the right version. Otherwise people using Debian 9+ derived distros (Ubuntu 16.04+) are seeing production issues. This implies packaging our custom libhttp-oai-perl distribution in the meantime. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 25

[Bug 25402] New: Put OPAC cart download options into dropdown menu
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25402 Bug ID: 25402 Summary: Put OPAC cart download options into dropdown menu Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org In the staff interface cart the options for downloading have been moved into a menu button. In the OPAC cart the download button still pops up a separate window with download format options. The OPAC cart should be modified to match the staff interface, with an integrated menu button and no pop-up. -- You are receiving this mail because: You are watching all bug changes.

1 22

[Bug 15253] Add Koha::Logger based logging for SIP2
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15253 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook(a)prosentient.com.au -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14698] AtomicUpdater - Keeps track of which updates have been applied to a database
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14698 David Cook <dcook(a)prosentient.com.au> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |dcook(a)prosentient.com.au --- Comment #21 from David Cook <dcook(a)prosentient.com.au> --- I don't see how this would be useful for a production Koha. I could maybe see how it could be useful for a dev/test database, but that's not something that should be in mainline Koha I think. (Although following that logic, then atomic updates in general don't belong in mainline Koha. Awkward.) That said, I do wish that we'd improve our database upgrade methods... -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 25686] New: Catalogue search result doesn't link to Normal display
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25686 Bug ID: 25686 Summary: Catalogue search result doesn't link to Normal display Change sponsored?: --- Product: Koha Version: 19.11 Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: bugs.koha-community.org Assignee: koha-bugs(a)lists.koha-community.org Reporter: iming(a)rosewoodfarm.com.au QA Contact: testopia(a)bugs.koha-community.org Created attachment 105608 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=105608&action=e… Screen shot After you make a search and the search result appears. Click on any title and you get an error message of "The record you requested does not exist ()". Upon close inspection, I noticed that when you mouseover a title on the search result list, the biblionumber for that item is missing from the link URL. For example: https://koha.rosewoodfarm.com.au/cgi-bin/koha/catalogue/detail.pl?biblionum… Once you entered a biblionumber, the normal catalogue record is showing. So looks like biblionumber has dropped out for every catalogue record! I'm running Koha 19.11.06.000 and have never made any setting change. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 30

[Bug 26044] New: frameworkcode fields must be a FK
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26044 Bug ID: 26044 Summary: frameworkcode fields must be a FK 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: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org Blocks: 5334 Foreign key must be added to the following tables: auth_subfield_structure biblio [deletedbiblio] marc_subfield_structure marc_tag_structure auth_subfield_structure And an empty value "" must be added to the biblio_frameworks table. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5334 [Bug 5334] Omnibus: Add explicit foreign key constraints -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 1

[Bug 8371] Add global level issuing rules (number of checkouts over all libraries, etc.)
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '20

23 Jul '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8371 Arthur Suzuki <arthur.suzuki(a)biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |arthur.suzuki(a)biblibre.com Status|NEW |In Discussion --- Comment #1 from Arthur Suzuki <arthur.suzuki(a)biblibre.com> --- Hi Paul, isn't this one a duplicate of 8137? I think the same behaviour could be achieved with this solution! -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 0