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

[Bug 31868] New: Add search options for searchable patron attributes to pull down list
by bugzilla-daemon＠bugs.koha-community.org 11 Aug '23

11 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31868 Bug ID: 31868 Summary: Add search options for searchable patron attributes to pull down list Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com, michaela.sieber(a)kit.edu When a patron attribute is marked as searchable, it can be searched within the Standard search option, but this is not really transparent and sometimes not so helpful when you have multiple YES_NO options for example. It would be nice if any patron attribute marked searchable would automatically show as a search option in the pull down list. We already do this with other additionally configurable fields in serials and acq, so this would also make things more consistent. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 33671] New: Database update 22.06.00.048 breaks when there are borrower_relationships.guarantor_id with NULL
by bugzilla-daemon＠bugs.koha-community.org 11 Aug '23

11 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33671 Bug ID: 33671 Summary: Database update 22.06.00.048 breaks when there are borrower_relationships.guarantor_id with NULL Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Depends on: 30472 We've had 2 reports of this database update breaking the update on bug 30472. The database update altered the table without checking/dealing with existing NULL values: PabloAB: Upgrading to 22.11.02-1 from an updated 22.05 on a Debian 11: Upgrade to 22.06.00.048 [18:33:27]: Bug 30472 - borrower_relationships.guarantor_id NOT NULL ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'guarantor_id': used in a foreign key constraint 'r_guarantor' at /usr/share/koha/lib/C4/Installer.pm line 739 Maybe the same issue as on bug 32399? ------ Mona Panchaud: Hello. While upgrading from 22.05 to 22.11 we are running into the following problem that is related to this change: "Upgrade to 22.06.00.048 [20:19:53]: Bug 30472 - borrower_relationships.guarantor_id NOT NULL ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'guarantor_id': used in a foreign key constraint 'r_guarantor' at /usr/share/koha/lib/C4/Installer.pm line 743" Is there any workaround? What can we do to get the upgrade working? Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30472 [Bug 30472] Field borrower_relationships.guarantor_id should be marked as NOT NULL -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 56

[Bug 7972] GUI for Crons
by bugzilla-daemon＠bugs.koha-community.org 11 Aug '23

11 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7972 Lisette Scheer <lisette.scheer(a)bywatersolutions.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |lisette.scheer@bywatersolut | |ions.com -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12556] SelfCheck machine starts the hold instantly with an email sent out
by bugzilla-daemon＠bugs.koha-community.org 11 Aug '23

11 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12556 Frédéric Demians <frederic(a)tamil.fr> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |frederic(a)tamil.fr --- Comment #70 from Frédéric Demians <frederic(a)tamil.fr> --- It would be nice to have this functionnality with more granularity, not with a global system preference, but with a SIPconfig.xml parameter. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 29333] New: Importing UNIMARC authorities in MARCXML UTF-8 breaks the encoding
by bugzilla-daemon＠bugs.koha-community.org 10 Aug '23

10 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29333 Bug ID: 29333 Summary: Importing UNIMARC authorities in MARCXML UTF-8 breaks the encoding Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: MARC Authority data support Assignee: koha-bugs(a)lists.koha-community.org Reporter: julian.maurice(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Related to bug 17754 MARC::Record and MARC::File::* modules sometimes use the position 09 of the leader to detect encoding. A blank character means 'MARC-8' while an 'a' means 'UTF-8'. In a UNIMARC authority this position is used to store the authority type (see https://www.transition-bibliographique.fr/wp-content/uploads/2021/02/AIntro… [FR]). In this case, 'a' means 'Personal Name'. The result is that the import will succeed for a Personal Name authority, but it will fail for all other authority types. Steps to reproduce: 0. Be sure to have a Koha UNIMARC instance. 1. Download the MARCXML for "Honoré de Balzac" curl -o balzac.marcxml https://www.idref.fr/02670305X.xml 2. Verify that it's encoded in UTF-8 file balzac.marcxml (should output "balzac.marcxml: XML 1.0 document, UTF-8 Unicode text") 3. Go to Tools » Stage MARC for import and import balzac.marcxml with the following settings: Record type: Authority Character encoding: UTF-8 Format: MARCXML Do not touch the other settings 4. Once imported, go to the staged MARC management tool and find your batch. Click on the authority title "Balzac Honoré de 1799-1850" to show the MARC inside a modal window. There should be no encoding issue. 5. Write down the imported record id (the number in column '#') and go to the MARC authority editor. Replace all URL parameters by 'breedingid=THE_ID_YOU_WROTE_DOWN' The URL should look like this: /cgi-bin/koha/authorities/authorities.pl?breedingid=198 You should see no encoding issues. Do not save the record. 6. Import the batch into the catalog. Verify that the authority record has no encoding issue. 7. Now download the MARCXML for "Athènes (Grèce)" curl -o athènes.marcxml https://www.idref.fr/027290530.xml 8. Repeat steps 2 to 6 using athènes.marcxml file. At steps 4 and 5 you should see encoding issues and that the position 9 of the leader was rewritten from 'c' to 'a'. Strangely, importing this batch fix the encoding issue, but we still lose the information in position 09 of the leader -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 34

[Bug 5920] Remove HTML from downloaded reports
by bugzilla-daemon＠bugs.koha-community.org 10 Aug '23

10 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5920 Katie Bliss <kebliss(a)dmpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kebliss(a)dmpl.org -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 6419] Add customizable areas to intranet home pages
by bugzilla-daemon＠bugs.koha-community.org 10 Aug '23

10 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6419 Katie Bliss <kebliss(a)dmpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kebliss(a)dmpl.org -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12709] Send a custom email to some or all patrons
by bugzilla-daemon＠bugs.koha-community.org 10 Aug '23

10 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12709 Cheryl <clackman(a)fargolibrary.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |clackman(a)fargolibrary.org -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 6961] runtime parameter for fund codes
by bugzilla-daemon＠bugs.koha-community.org 10 Aug '23

10 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6961 Katie Bliss <kebliss(a)dmpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kebliss(a)dmpl.org -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 7335] Allow custom parameters for sorting in SQL reports
by bugzilla-daemon＠bugs.koha-community.org 10 Aug '23

10 Aug '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7335 Katie Bliss <kebliss(a)dmpl.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |kebliss(a)dmpl.org -- You are receiving this mail because: You are watching all bug changes.

1 0