December 2016 - Koha-bugs - lists.koha-community.org

[Bug 16865] New: marking branchcode unwanted breaks self registration
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16865 Bug ID: 16865 Summary: marking branchcode unwanted breaks self registration Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: nengard(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com If you add branchcode to PatronSelfRegistrationBorrowerUnwantedField then self registration fails silently. The library and the user have no idea what happened. We should have an error and/or not let branchcode be added to that preference. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 14

[Bug 17364] New: branchcode should not be allowed in BorrowerUnwantedField , PatronSelfRegistrationBorrowerUnwantedField
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '23

10 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17364 Bug ID: 17364 Summary: branchcode should not be allowed in BorrowerUnwantedField, PatronSelfRegistrationBorrowerUnwantedField 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: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com If branchcode is among the fields in BorrowerUnwantedField, saving the borrower record in members/memberentry.pl will generate an Internal Server Error because there is a foreign key constraint on borrowers.branchcode. To replicate the issue: 1/ Set the syspref BorrowerUnwantedField so that it contains branchcode 2/ Create a patron on members/memberentry.pl 3/ Save the patron, you will get "Internal Server Error". It follows that PatronSelfRegistrationBorrowerUnwantedField should not contain branchcode either -- it's necessary to create a record in the borrowers table, so we shouldn't be able to exclude it. Details for those who like that sort of thing: If you're watching the plack error logs,you'll see something like this: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_salinas`.`borrowers`, CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)) [for Statement "INSERT INTO `borrowers` ( `address`, `address2`, `borrowernotes`, `cardnumber`, `categorycode`, `city`, `contactnote`, `country`, `dateenrolled`, `dateexpiry`, `dateofbirth`, `debarred`, `email`, `emailpro`, `fax`, `firstname`, `initials`, `mobile`, `opacnote`, `othernames`, `password`, `phone`, `phonepro`, `privacy`, `sex`, `sort1`, `sort2`, `state`, `surname`, `title`, `userid`, `zipcode`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0="1234 MAIN ST", 1="", 2="", 3="TESTYTESTERSON", 4="STAFF", 5="Bradley, CA", 6="", 7="", 8='2016-09-27', 9='2024-12-27', 10=undef, 11=undef, 12="", 13="", 14="", 15="TESTY", 16="", 17="", 18="", 19="", 20='!', 21="555 555 1212", 22="", 23=1, 24="", 25="C", 26="", 27="", 28="TESTERSON", 29="", 30='testy.testerson', 31="93426"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832. DBIx::Class::Storage::DBI::_dbh_execute(): Cannot add or update a child row: a foreign key constraint fails (`koha_salinas`.`borrowers`, CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)) at /usr/share/koha/lib/C4/Members.pm line 769 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 44

[Bug 17620] New: Fix format of date/data-times in Swagger definition
by bugzilla-daemon＠bugs.koha-community.org 04 Jul '23

04 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17620 Bug ID: 17620 Summary: Fix format of date/data-times in Swagger definition Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: hector.hecaxmmx(a)gmail.com, jonathan.druart(a)bugs.koha-community.org, lari.taskula(a)jns.fi, martin.renvoize(a)ptfs-europe.com, tomascohen(a)gmail.com Depends on: 16276, 17607 Bug #17607 highlighted the lack of a defined format for date and date-time fields in our api responses. We should settle on a response form and validate it to ensure it's consistently given across the codebase. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16276 [Bug 16276] When automatically deleting expired borrowers, make sure they didn't log in recently https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17607 [Bug 17607] Fix patron definition in Swagger -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 8

[Bug 17596] New: Simplify accounting UI in staff client
by bugzilla-daemon＠bugs.koha-community.org 03 Jul '23

03 Jul '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17596 Bug ID: 17596 Summary: Simplify accounting UI in staff client Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: josef.moravec(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com This bug is omnibus for our effort on simplifying accounting UI and workflow. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 33

[Bug 16665] New: Add a staffadmin bar to the opac interface in order to edit the previewing record (MARC)
by bugzilla-daemon＠bugs.koha-community.org 30 Jun '23

30 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16665 Bug ID: 16665 Summary: Add a staffadmin bar to the opac interface in order to edit the previewing record (MARC) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: new feature Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: dimantonak(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Currently when a librarian previewing a record in the opac interface and wants to edit that record, has to go to the staff interface, search again for that record and edit it. It would be useful to add a staffadmin bar (IF a librarian is logged in) linking to the staff interface (cgi-bin/koha/catalogue/detail.pl?biblionumber=#) in order to edit the MARC record directly. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 17723] New: Using MySQL on external server - lack of documentation giving example
by bugzilla-daemon＠bugs.koha-community.org 30 Jun '23

30 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17723 Bug ID: 17723 Summary: Using MySQL on external server - lack of documentation giving example Change sponsored?: --- Product: Project Infrastructure Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Project website Assignee: wizzyrea(a)gmail.com Reporter: fooquency(a)gmail.com I am trying to create a Koha instance using MySQL on a remote server. https://wiki.koha-community.org/wiki/Debian#Create_a_Koha_instance states: "create a new file in its place containing the connection information for the server, in the form of a my.cnf file." but no example is given. I would assume this somehow allows specification of all of hostname, username and password, but it is entirely unclear currently how to do this. Could someone kindly add an example or give more details of what format exactly "the connection information" should be in? http://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html has no mention of a password configuration for instance. -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 17311] New: koha-common service should be restarted on upgrade
by bugzilla-daemon＠bugs.koha-community.org 27 Jun '23

27 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17311 Bug ID: 17311 Summary: koha-common service should be restarted on upgrade Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: tomascohen(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: mirko(a)abunchofthings.net The upgrade process should restart the koha-common service. This is needed so Plack processes are restarted too and Koha version is reloaded (otherwise end users keep getting upgrade messages on the UI. Any other patched file will be reloaded (apache, zebra, etc). -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 19

[Bug 17730] New: Uniform mapping for biblio.biblionumber (Unimarc)
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17730 Bug ID: 17730 Summary: Uniform mapping for biblio.biblionumber (Unimarc) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Bibliographic data support Assignee: gmcharlt(a)gmail.com Reporter: dubyk(a)library.lviv.ua QA Contact: testopia(a)bugs.koha-community.org Created attachment 57999 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=57999&action=ed… Screenshot I try to deal with empty links to record details in the search. I found that this occurs when used mapping 090$9<>biblio.biblionumber (in uk-UA Unimarc tables) and typical use UNIMARCslim2intranetResults.xsl. In Koha mapping of biblio.biblionumber and MARC-fields mentioned in many files: etc / zebradb / marc_defs / unimarc / biblios / record.abs 25 melm 001 Local-number,Local-number:n 26 # Local-number (biblionumber can be either in 090$9 or, on some setup, on 001) 28 melm 090$9 Local-number,Local-number:n etc / zebradb / marc_defs / unimarc / biblios / biblio-koha-indexdefs.xml 9 <index_control_field tag="001"> 10 <target_index>Local-number:n</target_index> 11 </index_control_field> 20 <index_subfields tag="090" subfields="9"> 21 <target_index>Local-number:w</target_index> 22 <target_index>Local-number:n</target_index> 23 </index_subfields> etc / zebradb / marc_defs / unimarc / biblios / biblio-zebra-indexdefs.xsl 47 <xslo:template match="marc:controlfield[@tag='001']"> 48 <z:index name="Local-number:w"> 49 <xslo:value-of select="."/> 50 </z:index> 51 <z:index name="Local-number:n"> 52 <xslo:value-of select="."/> 53 </z:index> 54 </xslo:template> 63 <xslo:template mode="index_subfields" match="marc:datafield[@tag='090']"> 64 <xslo:for-each select="marc:subfield"> 65 <xslo:if test="contains('9', @code)"> 66 <z:index name="Local-number:w Local-number:n"> 67 <xslo:value-of select="."/> 68 </z:index> 69 </xslo:if> 70 </xslo:for-each> 71 </xslo:template> koha-tmpl / opac-tmpl / bootstrap / en / xslt / UNIMARCslim2OPACDetail.xsl 21 <xsl:variable name="biblionumber" select="marc:datafield[@tag=090]/marc:subfield[@code='a']"/> koha-tmpl / intranet-tmpl / prog / en / xslt / UNIMARCslim2intranetDetail.xsl 22 <xsl:variable name="biblionumber" select="marc:datafield[@tag=090]/marc:subfield[@code='a']"/> koha-tmpl / opac-tmpl / bootstrap / en / xslt / UNIMARCslim2OPACResults.xsl 25 <xsl:variable name="biblionumber" 26 select="marc:datafield[@tag=090]/marc:subfield[@code='a']"/> koha-tmpl / intranet-tmpl / prog / en / xslt / UNIMARCslim2intranetResults.xsl 25 <xsl:variable name="biblionumber" select="marc:controlfield[@tag=001]"/> t / db_dependent / Biblio.t 84 'biblio.biblionumber' => { tagfield => '999', tagsubfield => 'c' }, biblio.biblionumber in UNIMARC-tables: ru-RU 090^9 es-ES 001^@ en 001^@ fr-FR 001^@ pl-PL 999^9 it-IT 001^@ uk-UA 090^9 That is, in the context of biblio.biblionumber mentioned next subfields: 090^9 001^@ 999^9 090^a 999^c Probably for greater uniformity is better to use one subfield for biblio.biblionumber. Maybe 001^@? -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 17718] New: Allow usage of Smartform API (Czech only)
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17718 Bug ID: 17718 Summary: Allow usage of Smartform API (Czech only) 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: rbit(a)rbit.cz QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Enable to use Smartform API to simplify petron registration process namely address entering. This service allows address autocompletion for any address in the Czech Republic including street names and numbers. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 22

[Bug 17706] New: MARC staging fails with "Upload status: Denied" when memcached is enabled
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17706 Bug ID: 17706 Summary: MARC staging fails with "Upload status: Denied" when memcached is enabled Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: mirko(a)abunchofthings.net QA Contact: testopia(a)bugs.koha-community.org In 16.11.00 with memcached enabled, staging MARC records fails with "Upload status: Denied". It works after disabling memcached. -- You are receiving this mail because: You are watching all bug changes.

1 6