June 2023 - Koha-bugs - lists.koha-community.org

[Bug 28328] New: Editing a record can cause an ISE if data too long for column
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28328 Bug ID: 28328 Summary: Editing a record can cause an ISE if data too long for column Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Like bug 26518, but for ModBiblio To recreate: 1 - Edit a record in the staff client 2 - In MARC21 edit the 010a/LCCN field wih: ThisisgoingtobetoomanycharactersfortheLCCNfield 3 - Save the record 4 - ISE: C4::Biblio::_koha_modify_biblioitem_nonmarc(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'lccn' at row 1 [for Statement "UPDATE biblioitems SET biblionumber = ?, volume = ?, number = ?, itemtype = ?, isbn = ?, issn = ?, publicationyear = ?, publishercode = ?, volumedate = ?, volumedesc = ?, collectiontitle = ?, collectionissn = ?, collectionvolume= ?, editionstatement= ?, editionresponsibility = ?, illus = ?, pages = ?, notes = ?, size = ?, place = ?, lccn = ?, url = ?, cn_source = ?, cn_class = ?, cn_item = ?, cn_suffix = ?, cn_sort = ?, totalissues = ?, ean = ?, agerestriction = ? where biblioitemnumber = ? " with ParamValues: 0="4239", 1=undef, 2=undef, 3="BK", 4="0887080189", 5=undef, 6=undef, 7="Neugebauer Press USA ; | Distributed by Alphabet Press,", 8=undef, 9=undef, 10=undef, 11=undef, 12=undef, 13=undef, 14=undef, 15="col. ill. ;", 16="[30] p. :", 17=undef, 18="30 cm.", 19="[S.l.] : | Natick, MA :", 20="83181009sdhgaethq45y245y24thsadhgahq", 21=undef, 22="ddc", 23=undef, 24=undef, 25=undef, 26='', 27=undef, 28=undef, 29=undef, 30='4239'] at /kohadevbox/koha/C4/Biblio.pm line 384 at /usr/share/perl5/DBIx/Class/Exception.pm line 77 This also kills the linker script if a bib with too long lccn is encountered -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 26

[Bug 30896] New: Running misc/batchRebuildBiblioTables.pl -c fails with error "Running Data too long for column 'lccn'"
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30896 Bug ID: 30896 Summary: Running misc/batchRebuildBiblioTables.pl -c fails with error "Running Data too long for column 'lccn'" Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: david(a)davidnind.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com The command line script misc/batchRebuildBiblioTables.plcommand is used after updating Koha to MARC mappings (Administration > Catalog > Koha to MARC mappings). Running misc/batchRebuildBiblioTables.pl -c from the command line (to rebuild the Koha to MARC mappings) with the sample data in koha-testing-data generates this error message: C4::Biblio::_koha_modify_biblioitem_nonmarc(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'lccn' at row 1 at misc/batchRebuildBiblioTables.pl line 71 To replicate (when using koha-testing-docker and the sample data): 1. From the command line run ./misc/batchRebuildBiblioTables.pl -c 2. Error occurs: C4::Biblio::_koha_modify_biblioitem_nonmarc(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'lccn' at row 1 at misc/batchRebuildBiblioTables.pl line 71 I identified this when testing bug 30850 (I worked around the issue by using Tools > Batch item modification to delete the LCCN data in 010: created report to list all the record numbers, added MARC modification templates to delete fields 010 $8 $a $b $z, ran batch record modification). I'm not sure whether this is a problem with the table structure, or whether in real life you would have to identify and fix the problematic data for 010. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 12

[Bug 30851] New: Improve performance of request.pl
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30851 Bug ID: 30851 Summary: Improve performance of request.pl 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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 3

[Bug 30835] New: Failure 'floor' in t/lib/Mocks/Zebra.pm
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30835 Bug ID: 30835 Summary: Failure 'floor' in t/lib/Mocks/Zebra.pm 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: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Test suite is failing with : Undefined subroutine &t::lib::Mocks::Zebra::floor called at /kohadevbox/koha/t/lib/Mocks/Zebra.pm line 195. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 30832] New: bulkmarcimport.pl don´t find .mrc file uploaded
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30832 Bug ID: 30832 Summary: bulkmarcimport.pl don´t find .mrc file uploaded Change sponsored?: --- Product: Koha Version: 21.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: paliotti(a)mdp.edu.ar QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 30818] New: REST API: Why does a wrong column name still cause a general 500 while validating exhaustively?
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30818 Bug ID: 30818 Summary: REST API: Why does a wrong column name still cause a general 500 while validating exhaustively? Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: REST API Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl CC: tomascohen(a)gmail.com This might just be a dumb question: While testing 30790 and tweaking the test a bit, I found this: my $api_filter = encode_json({'isbn' => '123', 'xx1' => 'a2' }); $t->get_ok("//$userid:$password@/api/v1/biblios?q=$api_filter"); I am sending xx1 to Koha/REST/V1/Biblios, sub list. To my surprise, this doesnt trigger an error that says xx1 is not a valid biblio column. It appears that this query is just sent to DBIx. It crashes and the Exceptions module returns 500 Something went wrong. How is that possible? I stumble over all kinds of validation, extracting and merging parameters etc. etc. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 7

[Bug 30804] New: Optionally show information on existing items in order form
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30804 Bug ID: 30804 Summary: Optionally show information on existing items in order form Change sponsored?: --- Product: Koha Version: 20.11 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Some libraries would like to see information about existing items when creating an order line for an existing record. This would be especially helpful for multi-branch libraries that would like to coordinate their acquisitions. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 30983] New: Uneeded use of C4::Auth in Koha::REST::V1::Checkouts
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30983 Bug ID: 30983 Summary: Uneeded use of C4::Auth in Koha::REST::V1::Checkouts Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Depends on: 17003 Koha::REST::V1::Checkouts use C4::Auth but don't need it Since commit 0404ecec4b619ebe14ac262332870004bb88878c Bug 17003: Adapt to OpenAPI Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17003 [Bug 17003] Add API route to get checkout's renewability -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 1

[Bug 31008] New: Long-terms support version of Koha
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31008 Bug ID: 31008 Summary: Long-terms support version of Koha Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: new feature Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: david(a)davidnind.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Adding a "long-term support" release of Koha supported by the Koha Community. This would be in addition to current 18-months to two-year release support (stable, old stable, and old old stable). -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 10

[Bug 31010] New: BatchRevert does not deal with indexation correctly
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31010 Bug ID: 31010 Summary: BatchRevert does not deal with indexation correctly 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: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org This bug came up during QA of bug 30822, we're not yet properly handling the batchRevert indexing jobs. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3