October 2019 - Koha-bugs - lists.koha-community.org

[Bug 22919] New: Authorities MARC Structure
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '19

20 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22919 Bug ID: 22919 Summary: Authorities MARC Structure Change sponsored?: --- Product: Koha Version: 18.11 Hardware: PC OS: Linux Status: NEW Keywords: additional_work_needed Severity: trivial Priority: P3 Component: MARC Authority data support Assignee: koha-bugs(a)lists.koha-community.org Reporter: lovenabila(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: lovenabila(a)gmail.com Target Milestone: 18.11 Created attachment 89813 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=89813&action=ed… Screen shown when Adding new Authority I am logged in as SuperLibrarian with all rights. When I Select Home - Authorities - New Authority - MARC Structure : It does not load the MARC form at all and the screen is blank but will show Save, Z39.50 Search, Cancel button. I tried the following: 1) Tried selecting different MARC Template (Chronological Term, Default, Personal Name, etc.) 2) If I click Save button (even the form is not showing) then it will save the record as blank (not showing any field at this point also; only blank screen saying Authority #1 - Koha will also allow me to Download Record as MARCXML - When I open MARCXML it will show me the default tags ---------------- MARCXML File <record xsi:schemaLocation="http://www.loc.gov/MARC21/slim http://www.loc.gov/standards/marcxml/schema/MARC21slim.xsd"><leader>00190 a2200097 4500</leader><controlfield tag="001">1</controlfield><controlfield tag="003">OSt</controlfield><controlfield tag="005">20190516105224.0</controlfield><controlfield tag="008">190516|| aca||aabn | a|a d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">OSt</subfield><subfield code="c">OSt</subfield></datafield><datafield tag="942" ind1=" " ind2=" "><subfield code="a">PERSO_NAME</subfield></datafield></record> ---------------------- 3) From created report If I run report listing all authorities, then it will show me records but without any main_heading. 4) I can edit the MARC Structure from Koha Administration - Authority Type 5) I tried by creating new Authority Template 6) I have multiple instances created and it works fine in all of it. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 35

[Bug 23239] New: install.pl: DBD::mysql::st execute failed: Incorrect integer value
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '19

20 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23239 Bug ID: 23239 Summary: install.pl: DBD::mysql::st execute failed: Incorrect integer value Change sponsored?: --- Product: Koha Version: 19.05 Hardware: PC OS: Linux Status: NEW Severity: minor Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs(a)lists.koha-community.org Reporter: ashwinloyal(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com I'm using Koha 19.0500000 from Koha official PPA. The DB server that I use is latest Maria BD 10.4 from their official PPA. During MARC 21 setup, I get this error: [Mon Jul 1 07:12:57 2019] install.pl: DBD::mysql::st execute failed: Incorrect integer value: '' for column `koha_library`.`auth_subfield_structure`.`linkid` at row 148 at /usr/share/perl5/DBIx/RunSQL.pm line 273. But, installation completes successfully. Is this a serious error? How can I prevent it? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 23318] New: False error about missing budget on neworderbiblio.pl
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '19

20 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23318 Bug ID: 23318 Summary: False error about missing budget on neworderbiblio.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org To recreate: 1 - Have some budgets and funds in your system or create them 2 - Make a new superlibrarian 3 - Go to acquisitions 4 - Find/create a vendor 5 - Create/open a basket 6 - Add items to basket - from an existing biblio - enter a term with results 7 - Scroll to bottom of page - note error about budgets The current check calls GetBudgetHierarchy with a borrower - this returns only budgets owned by that user (or with no owner) On basket.pl we call the check with no borrower, but then check if the user can use any of the budgets. This is probably the better model -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 23769] New: SearchWithISBNVariations not implemented in Elasticsearch
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '19

20 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23769 Bug ID: 23769 Summary: SearchWithISBNVariations not implemented in Elasticsearch Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 23394] New: Circulation.t fails when RentalFeesCheckoutConfirmation is set
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '19

20 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23394 Bug ID: 23394 Summary: Circulation.t fails when RentalFeesCheckoutConfirmation is set Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Also, tests die when SearchEngine is Elasticsearch -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 2

[Bug 23365] New: Data migration from old to new version
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '19

20 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23365 Bug ID: 23365 Summary: Data migration from old to new version Change sponsored?: --- Product: Project Infrastructure Version: unspecified Hardware: All OS: Linux Status: NEW Severity: critical Priority: P5 - low Component: Bugzilla Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: sonamsi.singh99(a)gmail.com Created attachment 91764 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=91764&action=ed… Screenshot after data mirgation I was trying to import data from Koha version 17.05 to 18.05 using the application available in tool (for both import and export. It had imported the all bibliographic data but not the holding part, Which rendered in Tag 952. please tell me possible solution for this issue. -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 22812] New: Cannot add new subscription
by bugzilla-daemon＠bugs.koha-community.org 20 Nov '19

20 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22812 Bug ID: 22812 Summary: Cannot add new subscription Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: blocker Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: wizzyrea(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com Target Milestone: --- I can't seem to add a new subscription without filling in every. single. box. As an example, I created a subscription with no vendor, a biblio, no special anything, and I got an error Can't call method "set_additional_fields" on an undefined value at /kohadevbox/koha/serials/subscription-add.pl line 401 there are also sql errors when you don't fill in various boxes: Incorrect integer value: '' for column 'aqbooksellerid' at row 1 if you don't give a vendor Incorrect integer value: '' for column 'innerloop1' at row 1 if you don't use a prediction pattern that fills all boxes x y z My version of sql is 5.5.62 and this was in a docker test setup. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 42

[Bug 19498] New: Translatability: Get rid of [% block_budget.count %] and similar
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '19

19 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19498 Bug ID: 19498 Summary: Translatability: Get rid of [% block_budget.count %] and similar Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: veron(a)veron.ch QA Contact: testopia(a)bugs.koha-community.org CC: frederic(a)tamil.fr Examples: [% block_budget.count %] fund(s) are attached to this budget. [% count %] item(s) are attached to this record -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 20743] New: Update two-column templates with Bootstrap grid: Administration part 7
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '19

19 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20743 Bug ID: 20743 Summary: Update two-column templates with Bootstrap grid: Administration part 7 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: testopia(a)bugs.koha-community.org Depends on: 20668 Blocks: 20654 This patch will convert the last of the administration templates to use the Bootstrap grid: - printers.tt - searchengine/elasticsearch/mappings.tt - smart-rules.tt - sms_providers.tt - sru_modmapping.tt - systempreferences.tt - transport-cost-matrix.tt - usage_statistics.tt Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20654 [Bug 20654] Omnibus: Update two-column templates to use Bootstrap grid https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20668 [Bug 20668] Update two-column templates with Bootstrap grid: Acquisitions part 2 -- You are receiving this mail because: You are watching all bug changes.

1 18

[Bug 19721] New: Tabulation in the description of a patron category breaks the patron search. Cause : tabs must be escaped in JSON
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '19

19 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19721 Bug ID: 19721 Summary: Tabulation in the description of a patron category breaks the patron search. Cause: tabs must be escaped in JSON Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: victor.grousset(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com === Reproduce === 1. Go to staff: /cgi-bin/koha/admin/categories.pl 2. Edit a category with existing patrons 3. Add a tab in the description here is one to copy for convenience: " " 4. Save the category 5. Go to /cgi-bin/koha/members/members-home.pl 6. Filters → Category → select the just edited one 7. Hit search, just below 8. Then you should see "Processing..." As if the request was still running forever === Cause === In the browser dev tools, we can see that the XRH request to "search" actually comes back. The response seems normal. Except that Firefox warns "SyntaxError: JSON.parse: bad control character in string literal at line 23 column 29 of the JSON data" Which points to our tab. Which invalidates the JSON: https://stackoverflow.com/questions/19799006/unable-to-parse-tab-in-json-fi… > The whitespace characters are: character tabulation (U+0009), line feed (U+000A), carriage return (U+000D), and space (U+0020). > Whitespace is not allowed within any token, except that space is allowed in strings. === Workaround === Remove the tab from the description of the category. In /cgi-bin/koha/admin/categories.pl One can use the filter in the table (called search). And search for a tab " " to get the "corrupted" ones. === Fix === It seems that we should escape the tabs (and CRs(\r) and LFs(\n)) Or just get rid of them. Another question is where? - Where the category form is processed? - early in the upper layers? (when the request just comes) - or in the lower layers? (if the category is managed by the ORM) - In the database itself with a trigger? - Other ideas? === Going further === How to find which other bugs like this one might cause hard to diagnose issues? -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2