August 2013 - Koha-bugs - lists.koha-community.org

[Bug 9227] New: items in transit can be checked out without warning
by bugzilla-daemon＠bugs.koha-community.org 31 Mar '15

31 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9227 Bug ID: 9227 Summary: items in transit can be checked out without warning Classification: Unclassified Change sponsored?: --- Product: Koha Version: 3.8 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: nengard(a)gmail.com CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When you try to check out items with different statuses (on hold for example) you get a warning, but if you try to check out an item that's in transit you don't get that warning and should. See here: http://screencast.com/t/wu3iJMdU -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 10606] New: query in GetUpcomingDueIssues
by bugzilla-daemon＠bugs.koha-community.org 30 Mar '15

30 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10606 Bug ID: 10606 Summary: query in GetUpcomingDueIssues Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: gmcharlt(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org The patch for bug 9362 (which I did accept into master) introduces a MySQLism: Using HAVING without GROUP BY is a MySQLism, so at some point the query will have to become: SELECT issues.*, items.itype as itemtype, items.homebranch, TO_DAYS( date_due )-TO_DAYS( NOW() ) as days_until_due, branches.branchemail FROM issues LEFT JOIN items USING (itemnumber) LEFT OUTER JOIN branches USING (branchcode) WHERE returndate is NULL AND (TO_DAYS( date_due )-TO_DAYS( NOW() )) > 0 AND (TO_DAYS( date_due )-TO_DAYS( NOW() )) < ?; This is a pity, as it would be nice to be able to use "days_until_due" as an alias to make the query more readable, but it simply isn't portable. -- You are receiving this mail because: You are watching all bug changes.

1 27

[Bug 10263] New: Add ability to limit which branch can edit a bibliographic record
by bugzilla-daemon＠bugs.koha-community.org 30 Mar '15

30 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10263 Bug ID: 10263 Summary: Add ability to limit which branch can edit a bibliographic record Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: kyle.m.hall(a)gmail.com CC: m.de.rooy(a)rijksmuseum.nl Right now, it's possible to limit who can edit items by using IndependantBranches. However, Koha has no method of limiting who can edit bibliographic records, as they have no defined owner. -- You are receiving this mail because: You are watching all bug changes.

1 31

[Bug 7650] New: total not always right on checkout summary
by bugzilla-daemon＠bugs.koha-community.org 30 Mar '15

30 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7650 Priority: P5 - low Change sponsored?: --- Bug ID: 7650 CC: gmcharlt(a)gmail.com Assignee: kyle.m.hall(a)gmail.com Summary: total not always right on checkout summary QA Contact: koha.sekjal(a)gmail.com Severity: normal Classification: Unclassified OS: All Reporter: nengard(a)gmail.com Hardware: All Status: NEW Version: master Component: Circulation Product: Koha Created attachment 8024 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8024&action=edit total not matching the sum of above lines See attached. Every once in a while I'm noticing that the total shown does not add up the items above it - but I can't figure out what's making it not work or where the extra money is coming from. -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 6505] New: purchase order not populating all fields
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '15

27 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6505 Bug #: 6505 Summary: purchase order not populating all fields Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Acquisitions AssignedTo: henridamien(a)koha-fr.org ReportedBy: nengard(a)gmail.com QAContact: koha-bugs(a)lists.koha-community.org The purchase order PDF is not pulling info from the libraries. There are labels for Phone number Fax Billing address Email But they're not printing that info. Also, the library name is coming from the system preference for libraryname and not from the libraries admin area - all the info on the purchase order should comes from the data you enter in admin > libraries -- 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 1

[Bug 6579] New: getalert SQL invalid for KOHA_USER
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '15

27 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6579 Bug #: 6579 Summary: getalert SQL invalid for KOHA_USER Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_0 Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Notices AssignedTo: henridamien(a)koha-fr.org ReportedBy: ohiocore(a)gmail.com QAContact: koha-bugs(a)lists.koha-community.org The code for getalert in C4::Letters fails to account for one important case. While the POD says "all parameters NON mandatory", the result of NO arguments produces invalid SQL. The errors in the log look like: [error] [client 71.64.0.171] [Mon Jul 11 19:54:12 2011] opac-user.pl: 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 1 at /usr/share/koha/lib/C4/Letters.pm line 197, <DATA> line 522., referer: https://my.koha.edu/cgi-bin/koha/opac-user.pl [error] [client 71.64.0.171] [Mon Jul 11 19:54:12 2011] opac-user.pl: DBD::mysql::st fetchall_arrayref failed: fetch() without execute() at /usr/share/koha/lib/C4/Letters.pm line 198, <DATA> line 522., referer: https://my.koha.edu/cgi-bin/koha/opac-user.pl If you look at the logic, you'll agree that "SELECT * FROM alert WHERE" is not a valid SQL query. Code should assemble bind name/value pairs in a hash instead of appending to the query and pushing onto an array. Then build the WHERE clause at the end only when hash is populated. -- 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 2

[Bug 6614] New: CSV Basket Export gives blank lines
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '15

27 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6614 Bug #: 6614 Summary: CSV Basket Export gives blank lines Classification: Unclassified Change sponsored?: --- Product: Koha Version: rel_3_6 Platform: All OS/Version: All Status: NEW Severity: major Priority: P5 Component: Acquisitions AssignedTo: henridamien(a)koha-fr.org ReportedBy: ian.walls(a)bywatersolutions.com QAContact: koha-bugs(a)lists.koha-community.org If an order note contains "\n", that line will not print in the exported CSV basket, because "\n" is an invalid character to Text::CSV->combine(). -- 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 11

[Bug 6731] New: amounts not changing if budgeted amount changed
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '15

27 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6731 Bug #: 6731 Summary: amounts not changing if budgeted amount changed Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Acquisitions AssignedTo: henridamien(a)koha-fr.org ReportedBy: nengard(a)gmail.com QAContact: koha-bugs(a)lists.koha-community.org If I'm adding an order and I change the budgeted price it does not update the total, but if I change the amount then the total is updated. The total should be updated with any changes to the money fields. -- 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 2

[Bug 6741] New: when receiving orders the filter clears after receiving
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '15

27 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=6741 Bug #: 6741 Summary: when receiving orders the filter clears after receiving Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All URL: /cgi-bin/koha/acqui/parcel.pl?supplierid=2&op=new&invo ice=34567654&datereceived=08%2F17%2F2011 OS/Version: All Status: NEW Severity: normal Priority: P5 Component: Acquisitions AssignedTo: henridamien(a)koha-fr.org ReportedBy: nengard(a)gmail.com QAContact: koha-bugs(a)lists.koha-community.org When you use a filter on the order receiving page and then receive and item your filter is cleared. The filter should remain until the librarian changes or clears it. -- 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 1

[Bug 5617] New: fix-perl-path.pl misses some files
by bugzilla-daemon＠bugs.koha-community.org 27 Mar '15

27 Mar '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5617 Summary: fix-perl-path.pl misses some files Change sponsored?: --- Product: Koha Version: rel_3_2 Platform: All OS/Version: Linux Status: NEW Severity: normal Priority: P5 Component: Installation and upgrade (command-line installer) AssignedTo: gmcharlt(a)gmail.com ReportedBy: jsherman(a)usao.edu QAContact: koha-bugs(a)lists.koha-community.org Estimated Hours: 0.0 When upgrading from 3.0.6 to 3.2.01 (on Ubuntu 8.04), I found that I needed to roll my own perl. Upon running the upgrade, I found that fix-per-path.pl left the system perl shebang line on the following files: /usr/share/koha/intranet/cgi-bin/admin/aqbookfund.pl /usr/share/koha/intranet/cgi-bin/admin/aqbudget.pl /usr/share/koha/intranet/cgi-bin/labels/label-profiles.pl /usr/share/koha/intranet/cgi-bin/labels/label-manager.pl /usr/share/koha/intranet/cgi-bin/labels/pcard-member-search.pl /usr/share/koha/intranet/cgi-bin/labels/label-save-template.pl /usr/share/koha/intranet/cgi-bin/labels/label-templates.pl /usr/share/koha/intranet/cgi-bin/labels/label-create-profile.pl /usr/share/koha/intranet/cgi-bin/labels/label-create-layout.pl /usr/share/koha/intranet/cgi-bin/labels/label-print-pdf.pl /usr/share/koha/intranet/cgi-bin/labels/label-print-csv.pl /usr/share/koha/intranet/cgi-bin/labels/label-create-template.pl /usr/share/koha/intranet/cgi-bin/catalogue/recentacquisitions.pl /usr/share/koha/intranet/cgi-bin/serials/subscription-history.pl /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase30.pl /usr/share/koha/intranet/cgi-bin/suggestion/acceptorreject.pl /usr/share/koha/intranet/cgi-bin/reports/itemtypes.plugin /usr/share/koha/intranet/cgi-bin/reports/issues_by_borrower_category.plugin /usr/share/koha/intranet/cgi-bin/svc/bib /usr/share/koha/intranet/cgi-bin/svc/new_bib /usr/share/koha/intranet/cgi-bin/svc/bib_profile /usr/share/koha/intranet/cgi-bin/svc/config/systempreferences /usr/share/koha/intranet/cgi-bin/svc/authentication /usr/share/koha/intranet/cgi-bin/tools/runreport.pl /usr/share/koha/intranet/cgi-bin/tools/scheduler.pl.bak /usr/share/koha/intranet/cgi-bin/acqui/spent.pl /usr/share/koha/intranet/cgi-bin/acqui/bookfund.pl /usr/share/koha/intranet/cgi-bin/acqui/pdfformat/layout2pages.pm /usr/share/koha/intranet/cgi-bin/acqui/pdfformat/layout3pages.pm /usr/share/koha/misc/translator/translate /usr/share/koha/misc/translator/install.pl /usr/share/koha/misc/translator/install-code.pl /usr/share/koha/bin/cronjobs/runreport.pl.bak -w /usr/share/koha/opac/cgi-bin/opac/unapi /usr/share/koha/opac/cgi-bin/opac/opac-logout.pl /usr/share/koha/opac/cgi-bin/opac/sco/abort.pl /usr/share/koha/opac/cgi-bin/opac/sco/sco-circ.pl /usr/share/koha/opac/cgi-bin/opac/sco/printer.pl /usr/share/koha/opac/cgi-bin/opac/opac-recentacquisitions.pl /usr/share/koha/opac/cgi-bin/opac/opac-detailprint.pl -- 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 9