January 2022 - Koha-bugs - lists.koha-community.org

[Bug 28483] New: Warnings from Search.t must be removed
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '25

23 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28483 Bug ID: 28483 Summary: Warnings from Search.t must be removed 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: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Depends on: 21260 Blocks: 25515 The syspref Reference_NFL_Statuses was requested but I don't know what to say; this indicates that the test requires updating at t/db_dependent/Search.t line 197. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21260 [Bug 21260] Improve the Availability line of OPAC XSLT search results https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25515 [Bug 25515] Remove warnings and errors from tests output -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 26186] New: Remove "subroutine redefined" warnings from tests
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '25

23 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26186 Bug ID: 26186 Summary: Remove "subroutine redefined" warnings from tests Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org kohadev-koha@kohadevbox:/kohadevbox/koha$ prove t/db_dependent/cronjobs/advance_notices_digest.t t/db_dependent/cronjobs/advance_notices_digest.t .. No circulation PREDUEDGST letter transported by phone at /kohadevbox/koha/C4/Letters.pm line 605. Use of uninitialized value in concatenation (.) or string at (eval 1565) line 587. no letter of type '' found for borrowernumber 58. Please see sample_notices.sql at (eval 1565) line 587. t/db_dependent/cronjobs/advance_notices_digest.t .. 1/2 Subroutine parse_letter redefined at (eval 1572) line 444. Subroutine get_branch_info redefined at (eval 1572) line 481. Subroutine send_digests redefined at (eval 1572) line 532. No circulation PREDUEDGST letter transported by phone at /kohadevbox/koha/C4/Letters.pm line 605. Use of uninitialized value in concatenation (.) or string at (eval 1572) line 587. no letter of type '' found for borrowernumber 59. Please see sample_notices.sql at (eval 1572) line 587. No circulation PREDUEDGST letter transported by phone at /kohadevbox/koha/C4/Letters.pm line 605. Use of uninitialized value in concatenation (.) or string at (eval 1572) line 587. no letter of type '' found for borrowernumber 59. Please see sample_notices.sql at (eval 1572) line 587. t/db_dependent/cronjobs/advance_notices_digest.t .. ok All tests successful. Files=1, Tests=2, 5 wallclock secs ( 0.02 usr 0.01 sys + 3.34 cusr 1.38 csys = 4.75 CPU) Result: PASS kohadev-koha@kohadevbox:/kohadevbox/koha$ prove t/db_dependent/Auth_with_ldap.t t/db_dependent/Auth_with_ldap.t .. 1/4 Subroutine ldapserver_error redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 48. Subroutine description redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 80. Subroutine search_method redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 87. Subroutine checkpw_ldap redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 111. Subroutine ldap_entry_2_hash redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 261. Subroutine exists_local redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 312. Subroutine _do_changepassword redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 338. Subroutine update_local redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 369. Subroutine ldapserver_error redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 48. Subroutine description redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 80. Subroutine search_method redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 87. Subroutine checkpw_ldap redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 111. Subroutine ldap_entry_2_hash redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 261. Subroutine exists_local redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 312. Subroutine _do_changepassword redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 338. Subroutine update_local redefined at /kohadevbox/koha/C4/Auth_with_ldap.pm line 369. -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 26157] New: Redirect expected DBI warnings
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '25

23 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26157 Bug ID: 26157 Summary: Redirect expected DBI warnings Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org We should not display DBI warnings from tests when they are expected. -- You are receiving this mail because: You are watching all bug changes.

1 18

[Bug 26892] New: Remove warnings from t/db_dependent/Koha/Patrons.t
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '25

23 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26892 Bug ID: 26892 Summary: Remove warnings from t/db_dependent/Koha/Patrons.t Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: minor Priority: P5 - low Component: Test Suite Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org Blocks: 25515 Those tests generate a lot of warnings "item-level_itypes set but no itemtype set for item" Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25515 [Bug 25515] Remove warnings and errors from tests output -- You are receiving this mail because: You are watching all bug changes.

1 11

[Bug 26417] New: Remove warn in Koha::Patron is_valid_age
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '25

23 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26417 Bug ID: 26417 Summary: Remove warn in Koha::Patron is_valid_age Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: fridolin.somers(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com In Koha::Patron is_valid_age the is a compare : $age < $low But $low may be undef. It generates a warn : Use of uninitialized value $low in numeric lt (<) Needs a test like for $high. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 23

[Bug 29315] New: Remove warnings from Search.t
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '25

23 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29315 Bug ID: 29315 Summary: Remove warnings from Search.t Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: minor Priority: P5 - low Component: Test Suite Assignee: jonathan.druart+koha(a)gmail.com Reporter: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Blocks: 25515 """ The syspref SearchLimitLibrary was requested but I don't know what to say; this indicates that the test requires updating at t/db_dependent/Search.t line 198. The syspref FacetOrder was requested but I don't know what to say; this indicates that the test requires updating at t/db_dependent/Search.t line 198. The syspref OPACResultsUnavailableGroupingBy was requested but I don't know what to say; this indicates that the test requires updating at t/db_dependent/Search.t line 198. """ Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25515 [Bug 25515] Remove warnings and errors from tests output -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 29273] New: Warning not caught in tests for plugins
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '25

23 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29273 Bug ID: 29273 Summary: Warning not caught in tests for plugins Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Test Suite Assignee: jonathan.druart+koha(a)gmail.com Reporter: jonathan.druart+koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 23

[Bug 23685] New: Exporting report may consume unlimited memory
by bugzilla-daemon＠bugs.koha-community.org 23 Jul '25

23 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23685 Bug ID: 23685 Summary: Exporting report may consume unlimited memory Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: koha-bugs(a)lists.koha-community.org Reporter: paul(a)flo.org QA Contact: testopia(a)bugs.koha-community.org In guided_reports.pl, when exporting report results ($phase eq 'Export') all rows of data are fetched and then converted to the desired format. This may consume an unlimited amount of memory; when report results are particularly large, it may consume all available memory, leading to timed-out HTTP requests, crashes, and potentially data loss. (We have experienced Zebra index corruption as a result.) In master, reports/guided_reports.pl supports three export types -- tab-delimited, CSV, or *.ods. In each case, all data are loaded into memory and held there before any output is produced: 891 $sql = get_prepped_report( $sql, \@param_names, \@sql_params ); 892 my ($sth, $q_errors) = execute_query($sql); ... 895 if ($format eq 'tab') { 896 $type = 'application/octet-stream'; 897 $content .= join("\t", header_cell_values($sth)) . "\n"; 898 $content = Encode::decode('UTF-8', $content); 899 while (my $row = $sth->fetchrow_arrayref()) { 900 $content .= join("\t", @$row) . "\n"; 901 } 902 } else { 903 my $delimiter = C4::Context->preference('delimiter') || ','; 904 if ( $format eq 'csv' ) { ... 914 while (my $row = $sth->fetchrow_arrayref()) { 915 if ($csv->combine(@$row)) { 916 $content .= $csv->string() . "\n"; 917 } else { 918 push @$q_errors, { combine => $csv->error_diag() } ; 919 } 920 } 921 } 922 elsif ( $format eq 'ods' ) { ... 932 # Other line in Unicode 933 my $sql_rows = $sth->fetchall_arrayref(); 934 foreach my $sql_row ( @$sql_rows ) { 935 my @content_row; 936 foreach my $sql_cell ( @$sql_row ) { 937 push @content_row, Encode::encode( 'UTF8', $sql_cell ); 938 } 939 push @$ods_content, \@content_row; 940 } 941 942 # Process 943 generate_ods($ods_filepath, $ods_content); 944 945 # Output 946 binmode(STDOUT); 947 open $ods_fh, '<', $ods_filepath; 948 $content .= $_ while <$ods_fh>; 949 unlink $ods_filepath; 950 } The *.ods case is particularly problematic, because before any data is sent back to the user's browser, *three* copies of the full results are sitting in memory simultaneously -- @$sql_row, @$ods_content, and $content. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 78

[Bug 28952] New: Item Checkout History fails
by bugzilla-daemon＠bugs.koha-community.org 22 Jul '25

22 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=28952 Bug ID: 28952 Summary: Item Checkout History fails Change sponsored?: --- Product: Koha Version: 21.05 Hardware: PC OS: Linux Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: beardst(a)rlasd.net QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Created attachment 124504 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=124504&action=e… MySQL output We are getting an error whenever trying to view an item's checkout history. This is happening on all items that we have tested /cgi-bin/koha/circ/bookcount.pl?&biblionumber=33518&itm=18222 Results in a 500 error The Plack error log reports CGI::Compile::ROOT::usr_share_koha_intranet_cgi_2dbin_circ_bookcount_2epl::issuessince(): DBI Exception: DBD::mysql::st execute failed: Incorrect TIMESTAMP value: '0' [for Statement "SELECT SUM(count) FROM ( SELECT COUNT(*) AS count FROM issues WHERE itemnumber = ? and timestamp > ? UNION ALL SELECT COUNT(*) AS count FROM old_issues WHERE itemnumber = ? and timestamp > ? ) tmp" with ParamValues: 0="18222", 1=0, 2="18222", 3=0] at /usr/share/koha/intranet/cgi-bin/circ/bookcount.pl line 63 If I run the above sql statement with the variables populated it returns information. Screenshot is attached. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 20472] New: Working title
by bugzilla-daemon＠bugs.koha-community.org 21 Jul '25

21 Jul '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20472 Bug ID: 20472 Summary: Working title Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 90