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

[Bug 5985] Check amount allocated to child funds when editing amount on parent fund
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5985 mathieu saby <mathsabypro(a)gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |mathsabypro(a)gmail.com -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 34047] New: Add the number of orders in the table in acqui-home.pl
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34047 Bug ID: 34047 Summary: Add the number of orders in the table in acqui-home.pl 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: mathsabypro(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org In acqui/acqui-home.pl the table displays Amount, Order, Spent and Total Available for each fund. It could be useful to add the number of orders in the Amount, Order, Spent columns, so that the librarian could immediately get this info. For example instead of "1 400,00", it would be "1 400,00 (45 orders)" -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 0

[Bug 30948] New: search problem
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30948 Bug ID: 30948 Summary: search problem Change sponsored?: --- Product: Project Infrastructure Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Bugzilla Assignee: jonathan.druart+koha(a)gmail.com Reporter: mohammadabid.555(a)gmail.com hi, when i search for any word in koha (opac and staff), the result of this search is all the records i entered to koha and it does not show a specific results that contain the word that i search for it, any idea please about how can i solve this problem. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 30906] New: Show waiting ILL requests in patron account on checkouts tab
by bugzilla-daemon＠bugs.koha-community.org 18 Jun '23

18 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30906 Bug ID: 30906 Summary: Show waiting ILL requests in patron account on checkouts tab Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: ILL Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de When a ILL request is ready for pickup, we should show it in the patron account like we do for hold available for pickup. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[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