May 2022 - 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 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 30729] New: Template toolkit comments are caught in the translatable strings
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30729 Bug ID: 30729 Summary: Template toolkit comments are caught in the translatable strings Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: victor(a)tuxayo.net QA Contact: testopia(a)bugs.koha-community.org CC: frederic(a)tamil.fr I was checking the untranslated strings for 22.05 and noticed template toolkit comments are caught in the translatable strings. For example this string: %%] [%%# - category:␠ https://translate.koha-community.org/fr/22.05/translate/fr-FR-staff-prog.po… It comes from koha-tmpl/intranet-tmpl/prog/en/includes/patron-search.inc [%# Display a complex patron search form %] [%# - Search: <input> %] [%# You can then pass a list of filters %] [%# - branch: <select library list> %] [%# - category: <select patron category list> %] [%# - search_field: <select patron field list> %] [%# - search_type: <select "contain" or "start with"> %] -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 3

[Bug 30757] New: The last two skips on Jenkins for Koha_ExternalContent_RecordedBooks.t
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30757 Bug ID: 30757 Summary: The last two skips on Jenkins for Koha_ExternalContent_RecordedBooks.t Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 30672] New: Special characters entered into circulation and fine rules causes errors
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '23

17 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30672 Bug ID: 30672 Summary: Special characters entered into circulation and fine rules causes errors Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: kelly(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Currently, Koha allows for special characters such as $ in the circulation and fine rule matrix. This causes errrors if a circulation rule has a $ in the fines/fees column. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 3

[Bug 30665] New: Make order of emails in "first_valid_email_address" configurable
by bugzilla-daemon＠bugs.koha-community.org 17 Jun '23

17 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30665 Bug ID: 30665 Summary: Make order of emails in "first_valid_email_address" configurable 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: dcook(a)prosentient.com.au QA Contact: testopia(a)bugs.koha-community.org At the moment Koha::Patron->first_valid_email_address mandates a precedence of "email", then "emailpro", then "B_email". However, when "emailpro" was "Work email", a lot of people preferred to use it instead of "email" which was "Home email". The change of "email" to "Primary email" and "emailpro" to "Secondary email" was biased towards public and academic libraries, which left a lot of special libraries in the lurch. At the moment, I hard-code a change to first_valid_email_address to prefer emailpro, but it would be good if this was just straight-up configurable in core Koha. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 5