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

[Bug 23452] New: Multi-check options in system preferences are not translatable
by bugzilla-daemon＠bugs.koha-community.org 26 Nov '19

26 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23452 Bug ID: 23452 Summary: Multi-check options in system preferences are not translatable Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: caroline.cyr-la-rose(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org CC: frederic(a)tamil.fr The options in the pull-downs for system preferences that allow multiple choices are not translatable. See: - ArticleRequestsMandatoryFields - ArticleRequestsMandatoryFieldsItemOnly - ArticleRequestMandatoryFieldsRecordOnly - AutoShareWithMana - CoceProviders - decreaseLoanHighHoldsIgnoreStatuses - MarkLostItemsAsReturned - OpacAdvSearchMoreOptions - OpacAdvSearchOptions - OpacExportOptions -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 17

[Bug 23256] New: fr-CA OPAC_REG_VERIFY has hard-coded http://
by bugzilla-daemon＠bugs.koha-community.org 26 Nov '19

26 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23256 Bug ID: 23256 Summary: fr-CA OPAC_REG_VERIFY has hard-coded http:// Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: mtompset(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org Should be an easy fix to remove the http://, since the OPACBaseUrl is supposed to have the protocol in it. Need to create an atomic update (fix during upgrade) AND fix installer/data/mysql/fr-CA/obligatoire/sample_notices.sql (fix on fresh install) TEST PLAN ---------- 1) install fresh for fr-CA language 2) OPAC_REG_VERIFY letter should have http:// in it. 3) apply patch 4) restart all 5) run database upgrade 6) OPAC_REG_VERIFY letter should not have http:// in it. 7) reset all 8) OPAC_REG_VERIFY letter should not have http:// in it. 9) run qa test tools -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 8

[Bug 21574] New: Local use system preferences page doesn't have the system preferences menu
by bugzilla-daemon＠bugs.koha-community.org 26 Nov '19

26 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21574 Bug ID: 21574 Summary: Local use system preferences page doesn't have the system preferences menu Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: caroline.cyr-la-rose(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com When looking through system preferences, you have a menu of all the sysprefs categories on the left. However, if you click on "Local use", the left side menu is the administration menu. To reproduce: 1) Go to Administration > Global system preferences 2) Click on categories on the left-hand side of the screen (for example, "Circulation" or "Staff client", the left-hand side menu stays the same 3) Click on the "Local use" category 4) Notice the left-hand side menu is the administration menu and not the sysprefs categories -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 16

[Bug 23624] New: Count rows in report without (potentially) consuming all memory
by bugzilla-daemon＠bugs.koha-community.org 26 Nov '19

26 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23624 Bug ID: 23624 Summary: Count rows in report without (potentially) consuming all 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 Created attachment 92841 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=92841&action=ed… Count total number of rows 1,000 at a time C4::Reports::Guided::nb_rows (called by get_prepped_report in reports/guided_reports.pl) uses DBI::fetchall_arrayref to retrieve all rows at once; counts them; and then discards the rows and returns the count. This has the potential, if the number of rows is very large, to exhaust all available memory. (Other code in guided_reports.pl has the same potential effect, but because the solution to that is much less straightforward it will be addressed in a separate bug report.) This patch uses the second ($max_rows) parameter to DBI::fetchall_arrayref to retrieve a smaller number (1,000) of rows at a time, looping until all results have been retrieved. This will only use as much memory as the maximum amount used by a single call to DBI::fetchall_arrayref. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 48

[Bug 23006] New: Can't use inventory tool with barcodes that contain regex relevant characters ($, ...)
by bugzilla-daemon＠bugs.koha-community.org 26 Nov '19

26 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23006 Bug ID: 23006 Summary: Can't use inventory tool with barcodes that contain regex relevant characters ($,...) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Tools Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org Target Milestone: --- If your barcodes contain characters like $ (and possible others), it's not possible to use the inventory tool with a barcode file as they will report as 'not scanned', while the datelastseen is still updated. We have a library system that uses barcodes with the following schema: LOCATION_CODE$DIGITS When uploading a file with such barcodes in the inventory tool, they all report as missing. Exceptions are items that are on the wrong place on the shelf, they report correctly. The datelastseen is updated for all items anyway. To test: 1) Create an item with the following barcode: LOC$00001 2) Create a file with the same barcode on the first line. 3) Go to the inventory tool 4) Upload barcode file Check "Compare barcodes list to results" Check "Do not check in items scanned during inventory" Check "Skip items on loan" You might want to pick additional limits for a smaller result set depending on your sample db size, make sure it matches the item catalogued 5) Verify the scanned item is in the list, but the status reads "Missing (not scanned)". I found this regex in the perl code: if( !$barcode ) { $item->{problems}->{no_barcode} = 1; } elsif ( grep /^$barcode$/, @scanned_barcodes ) { next; } else { $item->{problems}->{not_scanned} = 1; } I assume that grep /^$barcode$/ fails because of the unescaped $. Is there a good way to make sure all problematic characters are escaped? Is the grep really necessary here? Later on we make the comparisons differently which is why the "wrongplace" still appears correctly and probably also why the datelastseen is updated as well. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 22

[Bug 23672] New: Dependency graph colours missing
by bugzilla-daemon＠bugs.koha-community.org 25 Nov '19

25 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23672 Bug ID: 23672 Summary: Dependency graph colours missing Change sponsored?: --- Product: Project Infrastructure Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Bugzilla Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: martin.renvoize(a)ptfs-europe.com I may be imagining it, but didn't the 'Show dependency graph' feature used to give us more colours? It now appears to only show green or grey.. I'm sure we had reds and oranges before to denote bug status at a glance. -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 22252] New: Status messages returned by Mana are not translatable
by bugzilla-daemon＠bugs.koha-community.org 25 Nov '19

25 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22252 Bug ID: 22252 Summary: Status messages returned by Mana are not translatable Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org Depends on: 17047 Target Milestone: --- Some Mana messages which are shown in Koha are being passed directly from Mana as English strings: lib/Mana/Resource.pm: return { msg => "The $resource already exists on Mana, thanks for your contribution!", id => $id, statuscode => 208 }; These strings are not translatable in Koha. If each message is being sent with a unique statuscode we should put the messages strings in a template and use the statuscodes to control their display. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17047 [Bug 17047] Mana Knowledge Base : share data -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 5

[Bug 21071] New: Search results not sorting in staff client advanced search when only AdvancedSearchTypes checkboxes are used
by bugzilla-daemon＠bugs.koha-community.org 24 Nov '19

24 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21071 Bug ID: 21071 Summary: Search results not sorting in staff client advanced search when only AdvancedSearchTypes checkboxes are used Change sponsored?: --- Product: Koha Version: 17.11 Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Searching Assignee: koha-bugs(a)lists.koha-community.org Reporter: lucy.vaux-harvey(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org Sorting of search results in the staff client advanced search does not work if you run a search using ONLY the Item types/Shelving locations/Collections checkbox limiters. Reported on 17.11.05. Tested and works correctly at 17.05. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 7

[Bug 22797] New: ILS-DI: GetRecords doesn't work with documented parameter id_type
by bugzilla-daemon＠bugs.koha-community.org 24 Nov '19

24 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22797 Bug ID: 22797 Summary: ILS-DI: GetRecords doesn't work with documented parameter id_type Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: alex.arnaud(a)biblibre.com, julian.maurice(a)biblibre.com Target Milestone: --- I've tried GetRecords from ILS-DI and noticed that the id_type parameter listed doesn't work, although it's listed in documentation. <GetRecords><code>IllegalParameter</code><message>The parameter id_type is illegal.</message></GetRecords> -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 5

[Bug 22720] New: Including branchcode in PatronSelfModificationBorrowerUnwantedField causes internal server error on self registration page
by bugzilla-daemon＠bugs.koha-community.org 24 Nov '19

24 Nov '19

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=22720 Bug ID: 22720 Summary: Including branchcode in PatronSelfModificationBorrowerUnwantedField causes internal server error on self registration page Change sponsored?: --- Product: Koha Version: 18.05 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 Target Milestone: --- If the system preference PatronSelfModificationBorrowerUnwantedField contains branchcode, the branch drop-down isn't populated on the self reigistration page (koha/opac-memberentry.pl). This causes a foreign key constraint violation when the new borrower is added to the borrowers table: [Tue Apr 16 13:56:02.588293 2019] [cgi:error] [pid 12231] [client 10.208.131.107:37284] AH01215: [Tue Apr 16 13:56:02 2019] opac-memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`load08`.`borrowers`, CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)) [for Statement "INSERT INTO `borrowers` ( `address`, `borrowernumber`, `categorycode`, `city`, `dateenrolled`, `dateexpiry`, `dateofbirth`, `email`, `firstname`, `password`, `privacy`, `state`, `surname`, `userid`, `zipcode`) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )" with ParamValues: 0="foo", 1=undef, 2='OBR', 3="foo", 4='2019-04-16T13:56:02', 5='2019-05-16T13:56:02', 6='1970-01-01', 7="foo(a)example.com", 8="foo", 9='foo', 10=1, 11="CA", 12="foo", 13='foo.foo', 14="99999"] at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1832., referer: https://foo.bywatersolutions.com/cgi-bin/koha/opac-memberentry.pl To re-create 1) add branchcode to the field list in PatronSelfModificationBorrowerUnwantedField 2) Click 'Register here' link on the front page of the opac 3) Fill out patron data and click 'Submit' => internal server error. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 7