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

[Bug 11945] New: Cronjob delete_expired_opac_registrations.pl fails with error in SQL syntax
by bugzilla-daemon＠bugs.koha-community.org 16 Mar '15

16 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11945 Bug ID: 11945 Summary: Cronjob delete_expired_opac_registrations.pl fails with error in SQL syntax Change sponsored?: --- Product: Koha Version: 3.14 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: larry(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When running the cronjob, delete_expired_opac_registrations.pl on a 3.14 site, I get the following error message: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 6 at /usr/share/koha/bin/cronjobs/delete_expired_opac_registrations.pl line 76. Checking the script, I find this SQL code: my $query = " SELECT borrowernumber FROM borrowers WHERE categorycode = ? AND DATEDIFF( DATE( NOW() ), DATE(dateenrolled) ) = ? ) If I run that SQL statement in the database manually, I get the same error message, e.g.: mysql> select borrowernumber from borrowers where categorycode='SELF' AND DATEDIFF( DATE( NOW() ), DATE(dateenrolled) ) = 7 ); ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 It would appear there's some problem with the DATEDIFF piece of the SELECT statement. - Larry -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 13

[Bug 13350] New: Untranslatable strings in aqbudgetperiods.tt
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '15

13 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13350 Bug ID: 13350 Summary: Untranslatable strings in aqbudgetperiods.tt Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: hector.hecaxmmx(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: bgkriegel(a)gmail.com, frederic(a)tamil.fr, tomascohen(a)gmail.com A few strings in aqbudgetperiods.tt are untranslatable like Duplicate budget:245, closed:257, and Budgets administration:262. If you review the po file for staff, you will notice that these strings aren't include. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 24

[Bug 13351] New: Untranslatable javascript in members.tt
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '15

13 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13351 Bug ID: 13351 Summary: Untranslatable javascript in members.tt Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: hector.hecaxmmx(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: bgkriegel(a)gmail.com, frederic(a)tamil.fr, tomascohen(a)gmail.com Untranslatable javascript in /koha-tmpl/intranet-tmpl/prog/en/members/members.tt line 243 "for patron", and line 225 "on " and "fields " -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 13

[Bug 13330] New: All overdue items with fines returned via checkouts table will have fines forgiven!
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '15

13 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13330 Bug ID: 13330 Summary: All overdue items with fines returned via checkouts table will have fines forgiven! Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: blocker Priority: P5 - low Component: Circulation 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 Due to a disconnect between how booleans are handled in Perl vs JSON, all checkins done from the checkouts table will have fines forgiven! This is because the parameters sent to svc/checkin are coded in JSON and the JSON false is treated in Perl as the string 'false' which evaluates to true! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 11

[Bug 10461] New: tax not taken in to account in the acq budget summaries
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '15

13 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10461 Bug ID: 10461 Summary: tax not taken in to account in the acq budget summaries Classification: Unclassified Change sponsored?: --- Product: Koha Version: 3.10 Hardware: All URL: acqui-home.pl OS: All Status: NEW Severity: major Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: nengard(a)gmail.com On acqui-home.pl the budget summary is not taking in to account tax rate at all. The code looks something like this: SELECT SUM( COALESCE(unitprice, ecost) * quantity ) AS sum FROM aqorders WHERE budget_id = ? AND quantityreceived > 0 AND datecancellationprinted IS NULL Plus SELECT SUM(shipmentcost) AS sum FROM aqinvoices WHERE shipmentcost_budgetid = ? AND closedate IS NOT NULL Tax rate should be included in this to give an accurate count of what has been spent/ordered. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 44

[Bug 11821] New: Staff client catalog: delete menu items greyed out without explanation
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '15

13 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11821 Bug ID: 11821 Summary: Staff client catalog: delete menu items greyed out without explanation Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org If you view a title in the staff client which has items attached the edit menu item "Delete record" will be greyed out. Like the fix in Bug 2310 a tooltip should be added explaining why. Similarly, menu items which relate to operations on items should be disabled (with explanation) if the record has no items. -- You are receiving this mail because: You are watching all bug changes.

1 12

[Bug 12732] New: Sort late orders by basket creation or closing date
by bugzilla-daemon＠bugs.koha-community.org 12 Mar '15

12 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12732 Bug ID: 12732 Summary: Sort late orders by basket creation or closing date Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: simith.doliveira(a)inlibro.com QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 24

[Bug 9848] New: SIP tests : fix in 10renew_all.t (additionnal checkin)
by bugzilla-daemon＠bugs.koha-community.org 12 Mar '15

12 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9848 Bug ID: 9848 Summary: SIP tests : fix in 10renew_all.t (additionnal checkin) Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: minor Priority: P5 - low Component: SIP2 Assignee: adrien.saurat(a)biblibre.com Reporter: adrien.saurat(a)biblibre.com CC: colin.campbell(a)ptfs-europe.com [MT10401] An error occurs while trying the "renew all" SIP test, 10renew_all.t: # Failed test 'match leader Renew All: prep: check out 1783B to 1X981' # at /home/asaurat/workspace/versions/community/C4/SIP/t/SIPtest.pm line 204. # Response '121YNY20130319 153138AOVIL|AA1X981|AB1783B|AJL ANGOISSE DU ROI SALOMON|AH20130521 235900|AFItem already checked out to you: renewing item.|AY3AZD551' doesn't match pattern '(?-xism:^121NNY\d{8} {4}\d{6})' Koha sent: 121YNY The test expects: 121NNY 12 = code for "Checkout Response" message 1 = Operation succeeded The three following characters mean: - renewal ok - magnetic data - desensitize We have a difference on the "Renewal ok" field. I found the reason behind this: it happens when you run all the tests at once ("make test"). In this case, this "renew all" test starts with an item already checked out during a former test. The "renew all" test begins with a checkout operation, but as the item is already out, this results in a renewal when it's not expected yet. The solution I can see : adding a "checkin" operation at the very beginning of the test. But to let the test work even when launched alone, we must allow this checkin to be unsuccessfull, it's just part of the preparation before the actual renewal tests. -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 11430] New: Search history: Delete selected lines
by bugzilla-daemon＠bugs.koha-community.org 11 Mar '15

11 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11430 Bug ID: 11430 Summary: Search history: Delete selected lines Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching Assignee: gmcharlt(a)gmail.com Reporter: jonathan.druart(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Bug 10807 adds a search history for authorities and bug 10862 adds the search history on the staff interface. This one allows the user to select the search history lines he wants to delete. -- You are receiving this mail because: You are watching all bug changes.

1 98

[Bug 12594] New: Get rid of z3950random
by bugzilla-daemon＠bugs.koha-community.org 11 Mar '15

11 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12594 Bug ID: 12594 Summary: Get rid of z3950random Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Z39.50 / SRU / OpenSearch Servers Assignee: gmcharlt(a)gmail.com Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl This field is of no use (since longer time already) and I would like to remove it from Koha. -- You are receiving this mail because: You are watching all bug changes.

1 4