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

[Bug 34548] New: Upgrade failed on conversion of publishercode from varchar to text on biblioitems and deletedbiblioitems due to existing indexes
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34548 Bug ID: 34548 Summary: Upgrade failed on conversion of publishercode from varchar to text on biblioitems and deletedbiblioitems due to existing indexes Change sponsored?: --- Product: Koha Version: 23.05 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Database Assignee: koha-bugs(a)lists.koha-community.org Reporter: mjnkml(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Changes in: /usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs/230501003.pl to convert publishercode to text on both tables resulted in an upgrade error. Manually deleted the indexes from the tables allowed the [Try again] to proceed without incident. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 7

[Bug 35180] New: Fix typo in deletedbiblioitems.publishercode comment in kohastructure.sql
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35180 Bug ID: 35180 Summary: Fix typo in deletedbiblioitems.publishercode comment in kohastructure.sql Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: trivial Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: katrin.fischer(a)bsz-bw.de Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Depends on: 34029 >From bug 34029: (In reply to Fridolin Somers from comment #25) > There is a small typo in kohastructure.sql : > `publishercode` text DEFAULT NULL COMMENT 'publisher (MARC21 260$b and > 246$b)', > > 246$b => 264$b > > Maybe just fix in master Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34029 [Bug 34029] Import breaks when data exceeds size of mapped database columns -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 34029] New: Import breaks on too long publishercode
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34029 Bug ID: 34029 Summary: Import breaks on too long publishercode Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Cataloging Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'publishercode' at row 1 at /usr/share/koha/Koha/Object.pm line 170 DBIx::Class::Storage::DBI::_dbh_execute(): DBI Exception: DBD::mysql::st execute failed: Data too long for column 'publishercode' at row 1 at /usr/share/koha/Koha/Object.pm line 170 Use of uninitialized value $record_number in concatenation (.) or string at /usr/share/koha/C4/Biblio.pm line 2431. C4::Biblio::ModZebra(): DBI Exception: DBD::mysql::st execute failed: Column 'biblio_auth_number' cannot be null at /usr/share/koha/Koha/SearchEngine/Zebra/Indexer.pm line 61 ModZebra( $record_number, $op, $server ); Whats happening here? Two records have a too long publishercode. Two undef's (from AddBiblio) are pushed to array @biblio_ids. Indexing crashes after the import. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 44

[Bug 34516] New: Upgrade database fails for 22.11.07.003, points to web installer
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34516 Bug ID: 34516 Summary: Upgrade database fails for 22.11.07.003, points to web installer Change sponsored?: --- Product: Koha Version: 22.11 Hardware: PC OS: Linux Status: NEW Severity: blocker Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: dcowens76(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Following an upgrade to 22.11.07.003 on Ubuntu 22.04, the upgrade fails and the staff interface goes to the web installer. Following advice on the community list, I ran the following commands to try to resolve the issue, with the output following: $ sudo service memcached restart $ sudo koha-upgrade-schema [instance name] Upgrading database schema for [instance name] Upgrade to 22.11.07.003 [14:01:47]: Bug 34029 - Extend datatypes in biblioitems and deletedbiblioitems tables to avoid import errors Updated biblioitems.place to text Updated deletedbiblioitems.place to text ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: BLOB/TEXT column 'publishercode' used in key specification without a key length at /usr/share/koha/lib/C4/Installer.pm line 741 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 38

[Bug 35015] New: Regression: Charges table no longer filters on paid transactions
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35015 Bug ID: 35015 Summary: Regression: Charges table no longer filters on paid transactions Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Fines and fees Assignee: koha-bugs(a)lists.koha-community.org Reporter: matt.blenkinsop(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org Bug 32431 has introduced a blank column to help with responsiveness but this has broken the filtering as it is column index based. The column index needs adjusting to account for this. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 18

[Bug 34730] New: Tables on opac-user.pl can display oddly on certain screen sizes.
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34730 Bug ID: 34730 Summary: Tables on opac-user.pl can display oddly on certain screen sizes. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: lucas(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 155279 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=155279&action=e… Example of problem at 605px To recreate: 1. Log in to the OPAC as a user with some checkouts, some holds, and some overdues. 2. Starting with a larger screensize ( 1385px or greater ) load the "Summary" page. ( opac-user.pl ) 3. Using your browser's mobile mode shrink the size of the screen to down to where columns start disappearing. As the disappear notice they are replaced with a button that has an '+' symbol. 4. Shrink the screen to 605px or less. 5. Notice the odd placement of the '+' button. 6. Reload the page with a screen size of 605px or less. There is no '+' the content is already expanded. -- You are receiving this mail because: You are watching all bug changes.

1 21

[Bug 32341] New: OPAC - Mobile - Items table columns are too thin
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32341 Bug ID: 32341 Summary: OPAC - Mobile - Items table columns are too thin Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: hammat.wele(a)inlibro.com Reporter: hammat.wele(a)inlibro.com QA Contact: hammat.wele(a)inlibro.com The bibliographic display of a record in the OPAC on mobile is not correct This patch fix this problem by making the table responsive To test: 1- Go to the OPAC 2- Open mobile mode 3- Go to a bibliographic record detail page in the OPAC (opac-detail.pl?biblionumber=X) 4- Check the Holdings table --> the information is not presented in a table as it is when viewing on a laptop or PC browser screen. --> we see very narrow columns --> unreadable text 5- Apply the patch and perform previous step (1-4). 6- Confirm that the table are displayed correctly and is now responsive -- You are receiving this mail because: You are watching all bug changes.

1 76

[Bug 30002] New: Remove unused xt/perltidyrc
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30002 Bug ID: 30002 Summary: Remove unused xt/perltidyrc 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: victor(a)tuxayo.net QA Contact: testopia(a)bugs.koha-community.org It doesn't influence the tests at all. After emptying it or removing or setting the max line length to 40 char no error pops. So it was proposed for removal in last dev meeting: http://irc.koha-community.org/koha/2022-01-19#i_2400452 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 74

[Bug 31108] New: add missing shebang line to ./t/00-check-atomic-updates.pl
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31108 Bug ID: 31108 Summary: add missing shebang line to ./t/00-check-atomic-updates.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: mtj(a)kohaaloha.com QA Contact: testopia(a)bugs.koha-community.org small patch to add missing shebang line to ./t/00-check-atomic-updates.pl to test... 1/ run prove, test is not run :( prove ./t | grep 00-check-atomic-updates.pl | wc -l 0 2/ apply patch 3/ run prove, test is run :) prove ./t | grep 00-check-atomic-updates.pl | wc -l 2 -- You are receiving this mail because: You are watching all bug changes.

1 28

[Bug 19169] New: Add a test to detect unneeded 'atomicupdate' files
by bugzilla-daemon＠bugs.koha-community.org 23 Jun '25

23 Jun '25

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19169 Bug ID: 19169 Summary: Add a test to detect unneeded 'atomicupdate' files 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: mtj(a)kohaaloha.com QA Contact: testopia(a)bugs.koha-community.org Add a test to detect unneeded 'atomicupdate' files -- You are receiving this mail because: You are watching all bug changes.

1 25