November 2015 - Koha-bugs - lists.koha-community.org

[Bug 14830] New: anonymous purchase suggestions are invisible/inaccessible in staff interface
by bugzilla-daemon＠bugs.koha-community.org 24 Nov '15

24 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14830 Bug ID: 14830 Summary: anonymous purchase suggestions are invisible/inaccessible in staff interface 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: mtj(a)kohaaloha.com QA Contact: testopia(a)bugs.koha-community.org this seems to be due to anon. suggestions being created with a NULL branchcode more info to come... -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 12

[Bug 15248] New: Improve FindDuplicate
by bugzilla-daemon＠bugs.koha-community.org 24 Nov '15

24 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15248 Bug ID: 15248 Summary: Improve FindDuplicate Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: paul.poulain(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Currently, FindDuplicate tries to find a duplicate by doing a search, that cannot be tuned by the library. It would be better to have the opportunity to use the matching points system. A "FindDuplicate" matching point entry could be added, set to title/author -current behaviour of FindDuplicate-, that the library can update/change to fit it's needs. -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 15219] New: Load checkouts table incrementally
by bugzilla-daemon＠bugs.koha-community.org 24 Nov '15

24 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15219 Bug ID: 15219 Summary: Load checkouts table incrementally Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Circulation Assignee: julian.maurice(a)biblibre.com Reporter: julian.maurice(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Some libraries have patrons with more than 1000 checkouts. Loading all of them at once can be very long, and sometimes can cause timeout errors. Following patches will prevent that by loading checkouts in the table by batches. -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 15241] New: Allow lowercase letters in spine labels
by bugzilla-daemon＠bugs.koha-community.org 24 Nov '15

24 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15241 Bug ID: 15241 Summary: Allow lowercase letters in spine labels Change sponsored?: --- Product: Koha Version: 3.20 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Label/patron card printing Assignee: cnighswonger(a)foundations.edu Reporter: theod(a)lib.auth.gr QA Contact: testopia(a)bugs.koha-community.org There are cases[*] when one might want to have LOWERCASE letters in a spine label. These include 'a','b','c','d',... and 'z' after the date. Although in the items table, itemcallnumber already allows (and in our system already has) lowercase letters in such cases, when printing the spine label PDF, all these are converted to UPPERCASE. I believe that call numbers should not be converted to uppercase prior to PDF export. [*] For example: PS 3603 .L548 R43 2011a <--- meaning the item is a Photocopy PS 3603 .L548 R43 2011b <--- meaning the second edition or PS 3603 .L548 R43 2011z <--- meaning the year is uncertain (You may find more such cases here: https://sites.smu.edu/cul/cip/docs/CAT/cpm-050-090.htm) -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 15246] New: adding new patron results in branchcode foreign key error
by bugzilla-daemon＠bugs.koha-community.org 24 Nov '15

24 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15246 Bug ID: 15246 Summary: adding new patron results in branchcode foreign key error Change sponsored?: --- Product: Koha Version: 3.18 Hardware: All OS: Linux Status: NEW Severity: enhancement Priority: P5 - low Component: Database Assignee: gmcharlt(a)gmail.com Reporter: lauraerinmann(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org I volunteer at a small library that wants to make available it's rare books. Another volunteer has taken the time to enter our collection. I am tasked with adding our patrons, but unable to do so. For context, our koha installation predates me, so I don't know the history of it. Steps to reproduce: 1. Go to patrons, choose "New Patron", and select "Guest/Casual User" 2. Fill out all required fields in the patron form 3. Submit the form Then I end up on: `/members/moremember.pl?borrowernumber=0` And see this message: "This patron does not exist." Just to double check, when I go back to review the patrons list for the patron I attempted to create, I can't find them. Steps I have taken: 1. updated to the (latest) package in Precise (Ubuntu 12.04) "last" repository (Koha V 3.18.12). I inherited this installation, so I can't say if this function ever worked for our library. Here is a dump of the relevant log entries from `intranet-error.log` ``` [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrowers`, CONSTRAINT `borrowers_ibfk_2` FOREIGN KEY (`branchcode`) REFERENCES `branches` (`branchcode`)) at /usr/share/koha/lib/C4/SQLHelper.pm line 184., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categor… [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categor… [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categor… [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categor… [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_transport_preferences`, CONSTRAINT `borrower_message_transport_preferences_ibfk_1` FOREIGN KEY (`borrower_message_preference_id`) REFERENCES `borrower_message_) at /usr/share/koha/lib/C4/Members/Messaging.pm line 185., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categor… [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categor… [Mon Nov 23 16:38:17 2015] [error] [client 192.168.0.5] [Mon Nov 23 16:38:17 2015] memberentry.pl: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`koha_library`.`borrower_message_preferences`, CONSTRAINT `borrower_message_preferences_ibfk_1` FOREIGN KEY (`borrowernumber`) REFERENCES `borrowers` (`borrowernumber`) ON DELETE CASCADE ON UP) at /usr/share/koha/lib/C4/Members/Messaging.pm line 169., referer: http://192.168.0.19:8080/cgi-bin/koha/members/memberentry.pl?op=add&categor… ``` -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 15245] New: bug
by bugzilla-daemon＠bugs.koha-community.org 23 Nov '15

23 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15245 Bug ID: 15245 Summary: bug Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: About Assignee: nengard(a)gmail.com Reporter: gugeldrusilla(a)yahoo.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 45112 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=45112&action=edit file bug -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 10821] New: label pdf adding in strange breaking
by bugzilla-daemon＠bugs.koha-community.org 23 Nov '15

23 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10821 Bug ID: 10821 Summary: label pdf adding in strange breaking Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Label printing Assignee: cnighswonger(a)foundations.edu Reporter: nengard(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 20781 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=20781&action=edit call number Let's start here - the CSV, XML and Quick label creator do not have this problem - it's purely the PDF. So see the attached images. The call number is 'Script H82 E45' the label is set to print itemcallnumber only and yet with it prints it makes the label look like this (also attached): SCR .I P T H82 E45 It's adding spaces and a dot that don't belong there. I have changed the font size and it still does it. -- You are receiving this mail because: You are watching all bug changes.

1 39

[Bug 9370] New: use Library::CallNumber::LC when splitting LC call numbers for spine labels
by bugzilla-daemon＠bugs.koha-community.org 23 Nov '15

23 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9370 Bug ID: 9370 Summary: use Library::CallNumber::LC when splitting LC call numbers for spine labels Classification: Unclassified 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: gmcharlt(a)gmail.com We should switch to using Library::CallNumber::LC for splitting LC call numbers when generating spine labels for several reasons: [1] Library::CallNumber::LC was written specifically for parsing LC call numbers, while the current code in Koha was developed based on very few examples. [2] The module is currently being used by Evergreen. Any future efforts to improve LC call number parsing by updating Library::CallNumber::LC would benefit both ILS projects. [3] In bug 6281, I'm proposing using this module to improve sorting of LC call numbers. Using the module would reduce redundancy in Koha's code base. [4] And, perhaps most importantly, it solves a problem reported by a library. The immediate motivation for this change is an example call number that one of our customers noted is being split incorrectly. The LC number 'QH541.15.C6 C25 2012' is currently being split like this: QH 541 .15 .C6 C25 2012 It should actually be split as follows: QH 541.15 .C6 C25 2012 The ".15" after "541" is part of the main class number; it isn't a Cutter. To test: [1] Add an item record with the call number QH541.15.C6 C25 2012 and set it classification source to lcc. [2] Generate a spine label and verify that the call number is split like this: QH 541.15 .C6 C25 2012 -- You are receiving this mail because: You are watching all bug changes.

1 24

[Bug 12201] New: Add the ability for the user to supply a callnumber splitting regexp for custom CN systems
by bugzilla-daemon＠bugs.koha-community.org 23 Nov '15

23 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12201 Bug ID: 12201 Summary: Add the ability for the user to supply a callnumber splitting regexp for custom CN systems Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Label printing Assignee: cnighswonger(a)foundations.edu Reporter: cnighswonger(a)foundations.edu QA Contact: testopia(a)bugs.koha-community.org The proposed feature will add a system preference to contain a custom regexp to be used by the label tool for splitting of callnumbers in a custom CN system. -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 5302] New: Replace current call number splitting code with a plug-in system based on classification source
by bugzilla-daemon＠bugs.koha-community.org 23 Nov '15

23 Nov '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5302 Summary: Replace current call number splitting code with a plug-in system based on classification source Change sponsored?: --- Product: Koha Version: HEAD Platform: All OS/Version: All Status: NEW Severity: enhancement Priority: P5 Component: Label printing AssignedTo: cnighswonger(a)foundations.edu ReportedBy: cnighswonger(a)foundations.edu QAContact: koha-bugs(a)lists.koha-community.org Estimated Hours: 0.0 RFC began here: http://wiki.koha-community.org/wiki/Call_Number_Splitting_Plugin_System Please feel free do comment, etc. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the QA contact for the bug.

1 7