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

[Bug 9988] New: Unneeded timeouts when saving authorities (Can we merge smarter?)
by bugzilla-daemon＠bugs.koha-community.org 15 Apr '15

15 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9988 Bug ID: 9988 Summary: Unneeded timeouts when saving authorities (Can we merge smarter?) Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: MARC Authority data support Assignee: gmcharlt(a)gmail.com Reporter: m.de.rooy(a)rijksmuseum.nl When saving an authority used in many biblios, Koha may have a timeout due to updating all those bib records. But in case I just update e.g. a 551 tag for the auth record, there is no need at all to update all those bib records. We should have a smarter merge function in C4/AuthoritiesMarc.pm. Note that you could use the pref to move updating all biblios to a cron job. Wouldn't it be nicer if we could do something in between? If we really need to update a handful of records, do it rightaway. If we really (!!) need to update 2000 records (in my example Koha is updating 2000 records for nothing), we could perhaps leave that to a cron job. -- You are receiving this mail because: You are watching all bug changes.

1 2

[Bug 13189] New: Patron card creator patron search browse by last name broken by extended attributes
by bugzilla-daemon＠bugs.koha-community.org 15 Apr '15

15 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13189 Bug ID: 13189 Summary: Patron card creator patron search browse by last name broken by extended attributes Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org The browse by last name letters on the patron search for the patron card creator doesn't work quite right. If extended patron attributes are disabled, it works fine, but if they are enabled, they are searched even when using the browse last name. Thus, if a searchable attribute has a "D" in it, and one clicks the "D" link for the last name browser, that patron will show even if he or she has no "D" in his or her hame! -- You are receiving this mail because: You are watching all bug changes.

1 25

[Bug 13479] New: Add option to add/remove biblios from list of books with forced item holds
by bugzilla-daemon＠bugs.koha-community.org 15 Apr '15

15 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13479 Bug ID: 13479 Summary: Add option to add/remove biblios from list of books with forced item holds Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com This report is a follow-up for bug 13478. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 12

[Bug 13478] New: Force item holds only for specific biblios
by bugzilla-daemon＠bugs.koha-community.org 15 Apr '15

15 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13478 Bug ID: 13478 Summary: Force item holds only for specific biblios Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 33

[Bug 12609] New: Replace use of DBI in C4::Ratings with DBIx::Class
by bugzilla-daemon＠bugs.koha-community.org 15 Apr '15

15 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12609 Bug ID: 12609 Summary: Replace use of DBI in C4::Ratings with DBIx::Class 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: kyle(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org We should replace the use of DBI in C4::Ratings with DBIC instead. -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 10169] New: Software error if one of multiple titles selected for hold in the OPAC has no items
by bugzilla-daemon＠bugs.koha-community.org 15 Apr '15

15 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10169 Bug ID: 10169 Summary: Software error if one of multiple titles selected for hold in the OPAC has no items Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: oleonard(a)myacpl.org CC: gmcharlt(a)gmail.com If you select multiple titles to place on hold in the OPAC and at least one of them has no items you will get a nasty error: Can't call method "field" on an undefined value at C4/Items.pm line 1398. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 11874] New: Add a "Call number fields" column to the Z39.50 search results.
by bugzilla-daemon＠bugs.koha-community.org 14 Apr '15

14 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11874 Bug ID: 11874 Summary: Add a "Call number fields" column to the Z39.50 search results. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Z39.50 / SRU / OpenSearch Servers Assignee: gmcharlt(a)gmail.com Reporter: fcapovilla(a)live.ca QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Created attachment 25736 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=25736&action=edit Add the "Call number fields" column to the Z39.50 search results. This patch adds a "Call number fields" columns to the Z39.50 biblio search results page. Since we only use MARC21 record on our instances, other types of records are not supported in this patch. Could someone with UNIMARC and NORMARC knowledge improve this patch to support all types of records? Sponsored-by: CCSR ( http://www.ccsr.qc.ca ) -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 10234] New: MySQL error when adding entry to z39.50servers
by bugzilla-daemon＠bugs.koha-community.org 14 Apr '15

14 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10234 Bug ID: 10234 Summary: MySQL error when adding entry to z39.50servers Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Database Assignee: gmcharlt(a)gmail.com Reporter: dcook(a)prosentient.com.au Recently, someone reported getting an error when trying to add an entry into z39.50servers (http://irc.koha-community.org/koha/2013-05-09#i_1250075) Here is a snippet of their log: log: "z3950servers.pl: DBD::mysql::st execute failed: Field 'description' doesn't have a default value at /usr/share/koha/intranet/cgi-bin/admin/z3950servers.pl line 133" I believe the problem is the result of using a strict SQL mode: Strict mode controls how MySQL handles input values that are invalid or missing. A value can be invalid for several reasons. For example, it might have the wrong data type for the column, or it might be out of range. A value is missing when a new row to be inserted does not contain a value for a non-NULL column that has no explicit DEFAULT clause in its definition. (For a NULL column, NULL is inserted if the value is missing.) (http://dev.mysql.com/doc/refman/5.5/en/server-sql-mode.html [You can check different versions, they all seem to have the same behaviour from what I can tell.]) * In this case, the field 'description' has no default value but is also NOT NULL field. If your SQL mode isn't strict, you'll get a warning but the insert will succeed (using a blank value rather than a null value). However, it if it strict, you'll get an error and a rolled back/failed insert. * If we observe other fields in kohastructure.sql that are NOT NULL and don't have a "real" default value, we typically use a default of ''. This will stop the warnings and the errors. Admittedly, the field "description" is documented as not being used, so perhaps the best thing to do is remove the field or perhaps make it NULL, but...using a default of '', will be the least potentially hazardous as it won't really change anything. It'll just enforce what we know as a default behaviour of using '' when the default value is missing. -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 10252] New: File Print of Checkout History Truncates Results
by bugzilla-daemon＠bugs.koha-community.org 14 Apr '15

14 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10252 Bug ID: 10252 Summary: File Print of Checkout History Truncates Results Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: bugs.koha-community.org Assignee: koha-bugs(a)lists.koha-community.org Reporter: thatcher.rea(a)bywatersolutions.com We're observing that printing of the checkout history is truncating some of the results. To replicate: Find a patron with more than 8 checkouts. Do a File-> Print of the page, and spool to PDF. The printout will drop results after 8 items. This seems to be affected in both 3.10.5 as well as master. Printing to hard copy is also affected. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 13399] New: Select a department: empty field if no description set in authorized value
by bugzilla-daemon＠bugs.koha-community.org 14 Apr '15

14 Apr '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13399 Bug ID: 13399 Summary: Select a department: empty field if no description set in authorized value Change sponsored?: --- Product: Koha Version: 3.18 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Course reserves Assignee: koha-bugs(a)lists.koha-community.org Reporter: mirko(a)abunchofthings.net QA Contact: testopia(a)bugs.koha-community.org When you set up an authorized value in the DEPARTMENT category without descriptions, the pull down menu in course creation shows an empty value. It should instead fall back to the name of the authorized value. 1. Set up an authorized value in the DEPARTMENT category. Leave description fields empty. 2. Go to Course reserves, Create course. 3. Open the »Select a department« pull down menu, observe that there is no description Expected: display the name of the authorized value if no description is given. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 21