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

[Bug 25726] New: Holds to Pull made empty by pathological holds
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '20

10 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25726 Bug ID: 25726 Summary: Holds to Pull made empty by pathological holds Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com After upgrading to 19.11, we're seeing libraries where pendingreserves.pl comes up empty when it shouldn't be. After some digging, we found it was because the library had some bad holds in their reserves table -- lines where reserves.itemnumber is null but reserves.found is not null. That runs into an issue on this line of the Holds to Pull query: AND items.itemnumber NOT IN (select itemnumber FROM reserves where found IS NOT NULL) I don't know exactly what changed between 19.05 and 19.11 to change how Koha thinks about this. I also don't know how libraries have ended up with these pathological holds. But that's a separate bug. To recreate: 1- place 2 bib-level holds on available items 2- confirm they both show on Holds to Pull 3- edit one hold from the database to set found='T' 4- reload Holds to Pull, confirm it is now empty -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 22

[Bug 25313] New: Add optional skip_merge parameter to ModAuthority
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '20

10 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25313 Bug ID: 25313 Summary: Add optional skip_merge parameter to ModAuthority Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Authority data support Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org Just like in DelAuthority. Allows you to skip merge in batch transactions where you know that the merge is useless because the reporting tag did not change. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 22

[Bug 26337] New: Remove unused authorities script should skip merge
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '20

10 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26337 Bug ID: 26337 Summary: Remove unused authorities script should skip merge Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz Remove unused authorities checks if an authority is used If not it calls DelAuthority DelAuthority checks if the authority is used and removes it from records if it is. We should pass 'skip_merge' when calling form this script as we have already checked the usage here -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 14

[Bug 26516] New: Importing records with unexpected format of copyrightdate fails
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '20

10 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26516 Bug ID: 26516 Summary: Importing records with unexpected format of copyrightdate fails 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 Bug 11046 attempted to improve the parsing of publicationyear/copyrightdate from marc records. Unfortunately copyrightdate is strictly an integer field, so now adds/imports fail if invalid data is passed To recreate: 1 - Add a new record to Koha making sure data is valid except 260$c: 198- 2 - Save the record 3 - It fails DBD::mysql::st execute failed: Data truncated for column 'copyrightdate' at row 1 [for Statement "INSERT INTO biblio SET frameworkcode = ?, author = ?, title = ?, subtitle = ?, medium = ?, part_number = ?, part_name = ?, unititle =?, notes = ?, serial = ?, seriestitle = ?, copyrightdate = ?, datecreated=NOW(), abstract = ? " with ParamValues: 0='', 1=undef, 2="This record", 3=undef, 4=undef, 5=undef, 6=undef, 7=undef, 8=undef, 9=0, 10=undef, 11="198-", 12=undef] at /kohadevbox/koha/C4/Biblio.pm line 2745. ERROR in _koha_add_biblio INSERT INTO biblio -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 16

[Bug 16391] New: In 'Tools', the link 'Tool plugins' has '?method=tool' in its link, which does not show all installed plugins
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '20

10 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16391 Bug ID: 16391 Summary: In 'Tools', the link 'Tool plugins' has '?method=tool' in its link, which does not show all installed plugins Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: arslanone(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org The link for plugins page in 'Tools' labeled as 'Tool plugins' takes us to cgi-bin/koha/plugins/plugins-home.pl?method=tool, see: http://i.imgur.com/ak2T1lE.png But not all installed plugins gets listed that way, see: http://i.imgur.com/ujPNiOZ.png If I manually remove ?method=tool from the address bar, and enter, then I can see all plugins, see: http://i.imgur.com/gH7kB8f.png -- You are receiving this mail because: You are watching all bug changes.

1 11

[Bug 26595] New: Add SMTP server column to libraries table
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '20

10 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26595 Bug ID: 26595 Summary: Add SMTP server column to libraries table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 30

[Bug 26290] New: Allow setting default SMTP parameters in koha-conf.xml
by bugzilla-daemon＠bugs.koha-community.org 10 Dec '20

10 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26290 Bug ID: 26290 Summary: Allow setting default SMTP parameters in koha-conf.xml 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: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org This way people installing Koha can set their SMTP on deployment. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 24

[Bug 18267] New: Update price and tax fields in EDI to reflect DB changes
by bugzilla-daemon＠bugs.koha-community.org 09 Dec '20

09 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18267 Bug ID: 18267 Summary: Update price and tax fields in EDI to reflect DB changes Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: colin.campbell(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org The aqorders price and tax fields were renamed/ added to in bug 13321 but the changes were not propagated to EDI.pm which is still creating orders with the prices in the old fields. Update the fields used and check the correct Edifact elements are being assigned -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 58

[Bug 25471] New: Add DataTables to MARC subfield structure admin page
by bugzilla-daemon＠bugs.koha-community.org 09 Dec '20

09 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25471 Bug ID: 25471 Summary: Add DataTables to MARC subfield structure admin page Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org I think it would be useful to have table filtering and sorting on the table of MARC subfields (marc_subfields_structure.tt). -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 22158] New: Add keyboard shortcuts in advanced editor to move current line up or down within record
by bugzilla-daemon＠bugs.koha-community.org 08 Dec '20

08 Dec '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22158 Bug ID: 22158 Summary: Add keyboard shortcuts in advanced editor to move current line up or down within record Change sponsored?: --- Product: Koha Version: 18.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: andrew(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Target Milestone: --- It'd be handy to have keyboard shortcuts to easily reorder lines in the advanced cataloging editor, as it's easy to get one's MARC fields out of numerical order. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 6