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

[Bug 13523] New: AddBiblio fails on mysql with STRICT_TRANS_TABLES
by bugzilla-daemon＠bugs.koha-community.org 12 May '15

12 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13523 Bug ID: 13523 Summary: AddBiblio fails on mysql with STRICT_TRANS_TABLES Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: benjamin.rokseth(a)kul.oslo.kommune.no QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Adding a biblio either via /svc endpoint or via Cataloguing interface fails on mysql versions > 5.3.21 because of a change in the default settings in GLOBAL.sql_mode to add STRICT_TRANS_TABLES. when adding a biblio in Cataloguing or via /svc API: --- Software error: Can't call method "fields" on an undefined value at /usr/share/koha/intranet/cgi-bin/cataloguing/additem.pl line 683. --- Doing this manually in SQL results in: --- ERROR 1364 (HY000): Field 'marcxml' doesn't have a default value --- This is probably a change that will live (Mysql becomes stricter in v5.7) and is purposefully added to better handle syntax checks in the SQL. bugs #10732, #5366 and #10215 all relate to the same but do not propose a fix. This particular bug proposes to fix the particular issue with adding biblios, either by 1) changing the database schema to NOT set field `marcxml` to NOT NULL (field `marc` in the same table is NULLABLE) 2) changing the AddBiblio code in Biblio.pm so it doesn't require multiple INSERT statements -- You are receiving this mail because: You are watching all bug changes.

1 30

[Bug 11356] New: can't order from suggestions not at my branch
by bugzilla-daemon＠bugs.koha-community.org 12 May '15

12 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11356 Bug ID: 11356 Summary: can't order from suggestions not at my branch Change sponsored?: --- Product: Koha Version: master Hardware: All URL: cgi-bin/koha/acqui/newordersuggestion.pl?booksellerid= 6&basketno=77 OS: All Status: NEW Severity: normal Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: nengard(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org When ordering from a suggestion I can't order unless the suggestion is at my library. Many library systems have a central ordering library/system and need to see all the data - at the very least the super librarians should see all suggestions on this page: cgi-bin/koha/acqui/newordersuggestion.pl?booksellerid=6&basketno=77 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 8474] New: Holds done by librarians cause silent errors in koha-error_log
by bugzilla-daemon＠bugs.koha-community.org 11 May '15

11 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8474 Priority: P5 - low Change sponsored?: --- Bug ID: 8474 CC: gmcharlt(a)gmail.com Assignee: koha-bugs(a)lists.koha-community.org Summary: Holds done by librarians cause silent errors in koha-error_log Severity: normal Classification: Unclassified OS: All Reporter: kolpen(a)o2.pl Hardware: All Status: NEW Version: rel_3_6 Component: Hold requests Product: Koha Created attachment 11000 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=11000&action=edit Proposed patches to request.pl and placerequest.pl modules Silent errors occur in koha-error_log when a librarian makes holds for borrowers. The reasons are uninitialized values in modules (intranet/cgi-bin/reserve): - request.pl - placerequest.pl Proposed patches refer to Koha 3.6.4 version as well as 3.6.6 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 12

[Bug 10174] New: Digest is confusing
by bugzilla-daemon＠bugs.koha-community.org 11 May '15

11 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10174 Bug ID: 10174 Summary: Digest is confusing Classification: Unclassified Change sponsored?: --- Product: Koha Version: 3.10 Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: nengard(a)gmail.com At every training I get asked what 'Digest' means in reference to notices. I always explain it and people still aren't sure they get it. If you don't subscribe to a lot of mailing lists you're not really used to that language. The concern is that patrons will also be confused by this. The library I'm at suggested 'Group' instead of 'Digest' - can anyone else think of other language that might work? Or even a reason why we wouldn't want all enhanced messages to be digests? As it is only 2 have the option of being a 'Digest' or not - so not make them all Digests and be done with it? Just starting a discussion here to try and make this the most user-friendly for the patrons. Nicole -- You are receiving this mail because: You are watching all bug changes.

1 23

[Bug 12949] New: changing child to adult doesn't remove link to guarantor
by bugzilla-daemon＠bugs.koha-community.org 11 May '15

11 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12949 Bug ID: 12949 Summary: changing child to adult doesn't remove link to guarantor Change sponsored?: --- Product: Koha Version: 3.16 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: nengard(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com To recreate: 1. create an adult 2. add a child to said adult 3. edit child and change them to adult 4. see that link to guarantor is gone on child 5. search for guarantor (original adult) 6. see that there is still a guarantee there even though he/she is an adult now -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 10941] New: MARC21 documentation links while adding an authority
by bugzilla-daemon＠bugs.koha-community.org 11 May '15

11 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10941 Bug ID: 10941 Summary: MARC21 documentation links while adding an authority Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Authority data support Assignee: tomascohen(a)gmail.com Reporter: pablo.bianchi(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org While adding authorities (authorities.pl), we don't have the "?" now available on cataloging frameworks. A similar strategy might be used. Related bugs: #10940, #5546. -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 10113] New: Currency and cost calculation problem in acquisition
by bugzilla-daemon＠bugs.koha-community.org 11 May '15

11 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10113 Bug ID: 10113 Summary: Currency and cost calculation problem in acquisition Classification: Unclassified Change sponsored?: --- Product: Koha Version: 3.10 Hardware: PC OS: Windows Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: shalomchong(a)segi.edu.my Created attachment 17667 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=17667&action=edit Set active currency in order page, total become "NaN" I have "NaN" value in my replacement cost, budgeted cost and total when I change the currency in order page to my active currency. I've set the same active currency for admin/currency & exchange rate and vendor, the basket page also displayed the active currency. but the default currency in my order page was other currency, the calculation is correct for this non-active currency, but the value for replacement cost, budgeted cost and total become "NaN" when I change the currency to my active currency. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 11939] New: Sample of currencies with a working active value
by bugzilla-daemon＠bugs.koha-community.org 11 May '15

11 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11939 Bug ID: 11939 Summary: Sample of currencies with a working active value Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: z.tajoli(a)cineca.it QA Contact: testopia(a)bugs.koha-community.org In default english setup currencies are in mysql/en/optional/parameters.sql file. The default is set to USA dollar because its value is '1' but now this setup is not enough. Now is better to add also values in 'active' column. I insert 'active' (value '1') for USA dollar, 'not active' (value '0') for others. The description in mysql/en/optional/parameters.txt file is no more correct, so I correct it. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 24

[Bug 13135] New: cancel_expired_holds.pl/CancelExpiredReserves() logging improvements to catch evasive bugs in production.
by bugzilla-daemon＠bugs.koha-community.org 09 May '15

09 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13135 Bug ID: 13135 Summary: cancel_expired_holds.pl/CancelExpiredReserves() logging improvements to catch evasive bugs in production. Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: olli-antti.kivilahti(a)jns.fi QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com We have issues with the Calendar giving bad expiration dates for waiting holds. So far unable to isolate the bug, which appears to appear only in prodcution. This logging improvement gives a lot more information about the cronjob internals in varying levels. (L1) Logs expired holds which have expirationdate overdue. (L1) Logs holds waiting too long, those that did get cancelled and (L2) those that didn't. (L3) Logs the used Calendar-objects content ** * * * ** * TEST PLAN * ** * * * ** 0a. Set the ReservesMaxPickUpDelay-syspref to 6 days. 0b. Create reservations, with expirydate in the past, and in the future, and now. Catch some of those to a borrower. 0c. Create reservations without an expirationdate and catch them to borrowers. In the DB, set the waitingdate 2 days to the past for some of them, 4 days to the past for a portion, 6 days to past for some and 8 days past for the rest. 1. Run the cancel_expired_holds.pl-script with --verbose 3 Observe log entries of all the handled reservations and of all the used Calendars (not all Calendars, simply those that were needed). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 6

[Bug 13532] New: Unit test for Bug 12361
by bugzilla-daemon＠bugs.koha-community.org 09 May '15

09 May '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13532 Bug ID: 13532 Summary: Unit test for Bug 12361 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: SIP2 Assignee: koha-bugs(a)lists.koha-community.org Reporter: olli-antti.kivilahti(a)jns.fi QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com This patch adds a unit test to check against timeout of: checking in an Item from a debarred borrower (a borrower whose koha.borrowers.debarred-column has year 9999) timeouts the SIP-server. This is because creating a new DateTime for year 9999 takes forever. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 16