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

[Bug 15877] New: C4::Barcodes does not correctly calculate db_max for 'annual' barcodes
by bugzilla-daemon＠bugs.koha-community.org 25 May '16

25 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15877 Bug ID: 15877 Summary: C4::Barcodes does not correctly calculate db_max for 'annual' barcodes Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The SQL query to find the database max value for annual barcodes is: 42 my $query = "SELECT max(substring_index(barcode,'-',-1)) AS chunk,barcode FROM items WHERE barcode LIKE ? GROUP BY barcode"; 43 # FIXME: unreasonably expensive query on large datasets The 'max' in the first column creates confusion and disrupts the normal pairing of the db. To recreate: 1 - Add two 'annual' type barcodes to the system (2016-0003, 2016-0006) 2 - Run the query: SELECT max(substring_index(barcode,'-',-1)) AS chunk,barcode FROM items WHERE barcode LIKE '2016-%' GROUP BY barcode 3 - Note that returned values may not pair up, in my case I got things like: chunk | barcode 0006 | 2016-0003 -- You are receiving this mail because: You are watching all bug changes.

1 24

[Bug 15919] New: Batch checkout should show due date in list of checked-out items
by bugzilla-daemon＠bugs.koha-community.org 16 May '16

16 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15919 Bug ID: 15919 Summary: Batch checkout should show due date in list of checked-out items Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com After you have performed a batch checkout the list of items which you have checked out is displayed. This list should show the due date for each item. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 10

[Bug 15802] New: The system will not allow me to return any books
by bugzilla-daemon＠bugs.koha-community.org 03 May '16

03 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15802 Bug ID: 15802 Summary: The system will not allow me to return any books Change sponsored?: --- Product: Koha Version: unspecified Hardware: PC OS: All Status: NEW Severity: major Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: sashagnb(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org The system is not allowing me to return any books. I`ve tried manually entering the code and also scanning it. Neither works and I get the following message. Message au retour Pas d'exemplaire avec code à barres : 000000LWS07024 This feature was working earlier today. I have tried working in both FireFox and Chrome and get the same error. Thanks, -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 15840] New: Fix 'import borrowers' tool to not die when importing a file with blank 'userid' values
by bugzilla-daemon＠bugs.koha-community.org 03 May '16

03 May '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15840 Bug ID: 15840 Summary: Fix 'import borrowers' tool to not die when importing a file with blank 'userid' values Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: gmcharlt(a)gmail.com Reporter: mtj(a)kohaaloha.com QA Contact: testopia(a)bugs.koha-community.org to replicate the bug 1/ import a borrowers.csv file containing any row with a blank 'userid' value, - use the 'overwrite' option. 2/ repeat step 1/ koha dies with error.. DBIx::Class::Storage::DBI::_dbh_execute(): Duplicate entry '' for key 'userid' at /path/to/yr/koha/C4/Members.pm line 683 bug confirmed on 3.18.9 -> master 43bcc1c -- You are receiving this mail because: You are watching all bug changes.

1 38

[Bug 15863] New: When creating a dictionary for date column, date range selection should be hidden if all dates is selected
by bugzilla-daemon＠bugs.koha-community.org 29 Apr '16

29 Apr '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15863 Bug ID: 15863 Summary: When creating a dictionary for date column, date range selection should be hidden if all dates is selected Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Reports Assignee: gmcharlt(a)gmail.com Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org When creating a dictionary for a date column, there is a "date range" / "all dates" radio buttons and 2 inputs to select the date range. These inputs should be hidden if "all dates" is selected. See bug 2669 comment 10 for the request. -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 15918] New: Obsolete file datatables-strings.inc can be removed
by bugzilla-daemon＠bugs.koha-community.org 29 Apr '16

29 Apr '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15918 Bug ID: 15918 Summary: Obsolete file datatables-strings.inc can be removed 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 The include file datatables-strings.inc is no longer necessary. Its contents are now in datatables.inc. The last few references to it can be removed and the file deleted. -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 15938] New: Use validation plugin when adding or editing classification sources and filing rules
by bugzilla-daemon＠bugs.koha-community.org 29 Apr '16

29 Apr '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15938 Bug ID: 15938 Summary: Use validation plugin when adding or editing classification sources and filing rules Change sponsored?: --- Product: Koha Version: master Hardware: All URL: /cgi-bin/koha/admin/classsources.pl 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 In Administration -> Classification sources there is some embedded JavaScript which checks for empty form values. That kind of task is easily handled by the globally-included validation plugin. -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 15713] New: Restart zebra when rotating logfiles
by bugzilla-daemon＠bugs.koha-community.org 27 Apr '16

27 Apr '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15713 Bug ID: 15713 Summary: Restart zebra when rotating logfiles 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: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 12

[Bug 15722] New: Patron search cannot deal with special characters in fields
by bugzilla-daemon＠bugs.koha-community.org 27 Apr '16

27 Apr '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15722 Bug ID: 15722 Summary: Patron search cannot deal with special characters in fields Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com The patron search for a library was failing to return and was hung on "processing" what I found was that the patron's email address had a tab and a space at the end. When these were outputted in the json template members/tables/members_results.tt my browser ( chrome ) was unable to process the data giving a syntax error. I found this be recreating the query and calling svc/member/search directly from my browser. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 17

[Bug 15838] New: syspref SubscriptionDuplicateDroppedInput does not work for all fields
by bugzilla-daemon＠bugs.koha-community.org 27 Apr '16

27 Apr '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15838 Bug ID: 15838 Summary: syspref SubscriptionDuplicateDroppedInput does not work for all fields Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: alex.arnaud(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com Some fields (especially on second page?) are not reset when duplicating a subscription despite they are in SubscriptionDuplicateDroppedInput system preference. The reason is that these fields have an id different than the name. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 12