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

[Bug 12786] New: permission to allow everyone in staff client to see all patron lists
by bugzilla-daemon＠bugs.koha-community.org 16 Mar '15

16 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12786 Bug ID: 12786 Summary: permission to allow everyone in staff client to see all patron lists 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: nengard(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Right now only the staff that creates a patron list (this is the Tools > Patron lists list - not the Private lists I'm referring to) can see their list. It would be nice if there was a permission or a way to have all lists of patrons visible to all staff. -- You are receiving this mail because: You are watching all bug changes.

1 1

[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 13770] New: There should be a command in Debian packages to switch to DOM indexing
by bugzilla-daemon＠bugs.koha-community.org 14 Mar '15

14 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13770 Bug ID: 13770 Summary: There should be a command in Debian packages to switch to DOM indexing Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: mirko(a)abunchofthings.net QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz We should offer an easy way to upgrade from GRS1 to DOM indexing. People could use it manually now and it should be part of the upgrade process to 3.20 or legacy (-ish package) installations will break. zebra-biblios-dom.cfg creation could be done with something like sed -e "s/__KOHASITE__/instancename/g" \ -e "s/__ZEBRA_MARC_FORMAT__/marcflavour/g" \ -e "s/__ZEBRA_LANGUAGE__/en/g" \ "/etc/koha/zebra-biblios-dom-site.cfg.in" > "/etc/koha/sites/instancename/zebra-biblios-dom.cfg" maybe for all instances found by koha-list. koha-conf.xml has to be checked for zebra_*_index_mode and use_zebra_facets and they need to be changed or added, the xi: stuff has to be added to the biblioserver section. Zebra restarted and rebuilt afterwards. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[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 13750] New: Holds queue: Always show branch name, not branch code
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '15

13 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13750 Bug ID: 13750 Summary: Holds queue: Always show branch name, not branch code Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org When limiting the holds queue to one branch, on top of the table it displays: X items found for <branchcode> This should show the branch name instead of the code, as the branch name is also shown inside the holds table. -- You are receiving this mail because: You are watching all bug changes.

1 10

[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