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

[Bug 9505] New: acqui/invoices.pl contains an unnecessary loop
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '13

19 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9505 Bug ID: 9505 Summary: acqui/invoices.pl contains an unnecessary loop Classification: Unclassified 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: colin.campbell(a)ptfs-europe.com Script retrieves a list of invoices it loops through the list to produce a new bu identical list. While the execution time wasted is trivial it obscures the purpose of the code -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 16

[Bug 10635] New: can't query for create in action_logs
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '13

19 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10635 Bug ID: 10635 Summary: can't query for create in action_logs Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: gmcharlt(a)gmail.com Reporter: nengard(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 19888 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=19888&action=edit error I wrote this report: SELECT p.cardnumber, p.surname, p.firstname, p.streetnumber, p.address, p.address2, p.city, p.state, p.zipcode, p.email, p.phone, p.dateenrolled, p.smsalertnumber, l.action, l.timestamp as 'action taken' FROM borrowers p left join action_logs l on (p.borrowernumber=l.object) where l.module='MEMBERS' and date(l.timestamp) between date_sub(curdate(), interval 1 week) and curdate() and l.action in ('MODIFY','CREATE') And get the attached error which says I can't use the word 'CREATE' but that's the word in the table ... so maybe we need to remove this restriction or change the wording in the table so that it can be queried. -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 9258] New: Debian packages should not depend on CHI
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '13

19 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9258 Bug ID: 9258 Summary: Debian packages should not depend on CHI Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Packaging Assignee: koha-bugs(a)lists.koha-community.org Reporter: jcamins(a)cpbibliography.com CC: robin(a)catalyst.net.nz Given the problems that installing CHI has been giving people, and the fact that CHI is entirely optional, I would suggest that the Debian packages should not depend on CHI, but merely suggest it. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 7448] New: Files created by koha-dump have different owners/permissions
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '13

19 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7448 Bug #: 7448 Summary: Files created by koha-dump have different owners/permissions Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: normal Priority: P5 - low Component: Packaging AssignedTo: robin(a)catalyst.net.nz ReportedBy: magnus(a)enger.priv.no QAContact: ian.walls(a)bywatersolutions.com Here is a sample, for an instanace called "esme": -rw-r----- 1 root esme-koha 147K Jan 11 12:27 esme-2012-01-11.sql.gz -rw------- 1 root root 153K Jan 11 12:27 esme-2012-01-11.tar.gz The database file gets this treatment: chown "root:$name-koha" "$dbdump" chmod g+r "$dbdump" while the other file does not get anything similar. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.

1 5

[Bug 10268] New: add missing perl packages for Koha on wheezy (perl5.14)
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '13

19 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10268 Bug ID: 10268 Summary: add missing perl packages for Koha on wheezy (perl5.14) Classification: Unclassified 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: mtj(a)kohaaloha.com CC: robin(a)catalyst.net.nz i just upgraded my squeeze box to wheezy, and got some errors about some missing perl modules a quick cpanm fixed the errors... # cpanm LWP/UserAgent.pm Try/Tiny.pm URI/Escape.pm this bug will attempt to fix this problem -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 9362] New: Wrong query in GetUpcomingDueIssues (Circulation.pm)
by bugzilla-daemon＠bugs.koha-community.org 18 Nov '13

18 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9362 Bug ID: 9362 Summary: Wrong query in GetUpcomingDueIssues (Circulation.pm) Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: minor Priority: P5 - low Component: Circulation Assignee: adrien.saurat(a)biblibre.com Reporter: adrien.saurat(a)biblibre.com CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com C4:Circulation:GetUpcomingDueIssues is used in the advance_notices.pl script. This script waits for a "maxdays" parameter, which is used in the following request. We have in GetUpcomingDueIssues the following query: 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( NOW() )-TO_DAYS( date_due ) ) < ? Shouldn't the last line be replaced by "AND TO_DAYS( date_due )-TO_DAYS( NOW() ) < ?" like what we see in the select clause? The date_due is supposed to be "bigger" (farther) than the NOW date. -- Also, this request gives the upcoming due issues, but also the overdues. Is it supposed to be so? If not, the last line should in fact be: AND ( TO_DAYS( NOW() )-TO_DAYS( date_due ) ) BETWEEN 0 AND ? -- I'm not sure about the last point, so for now I'll make a patch including only the first change. -- You are receiving this mail because: You are watching all bug changes.

1 27

[Bug 7674] New: tabs my holdings and others holdings. Buttons "Remove items Selected", "Modify items Selected"
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '13

15 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7674 Priority: P5 - low Change sponsored?: --- Bug ID: 7674 Assignee: gmcharlt(a)gmail.com Summary: tabs my holdings and others holdings. Buttons "Remove items Selected", "Modify items Selected" QA Contact: koha.sekjal(a)gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: stephane.delaye(a)biblibre.com Hardware: All Status: NEW Version: rel_3_8 Component: Cataloging Product: Koha >From screen ../cgi-bin/koha/catalogue/detail.pl?biblionumber= Different lists(tabs) for my holdings(items with branch connexion) and other items(item with branch different of branch connexion). Add filter at the top right of the item list. Filter that points to the enumchron 4 / Add a column "Selection" check at the table of results 5/At the bottom add two buttons: "Remove items Selected" and "Modify items Selected" Buttons that copy / paste barcodes on the screens: batchMod.pl or batchMod.pl? Del = 1 6/Buttons activating a pop up screen avoiding leaving detail.pl >From items page, reach in 1 click the "batch del item" (usefull when you trash a year of a daily serial) Notes : new permissions associated with these functions see ticket 7673 -- You are receiving this mail because: You are watching all bug changes.

1 83

[Bug 10671] New: Koha 3.14 Help Files Update
by bugzilla-daemon＠bugs.koha-community.org 15 Nov '13

15 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10671 Bug ID: 10671 Summary: Koha 3.14 Help Files Update Change sponsored?: --- Product: Koha Version: 3.14 Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Documentation Assignee: nengard(a)gmail.com Reporter: nengard(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org This is the running bug for the 3.14 help files. -- You are receiving this mail because: You are watching all bug changes.

1 129

[Bug 7764] New: INSTALL.ubuntu needs updating
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '13

13 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7764 Priority: P5 - low Change sponsored?: --- Bug ID: 7764 Assignee: gmcharlt(a)gmail.com Summary: INSTALL.ubuntu needs updating QA Contact: koha.sekjal(a)gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: srdjan(a)catalyst.net.nz Hardware: All Status: NEW Version: master Component: Installation and upgrade (command-line installer) Product: Koha * install_misc/ubuntu.packages: liblocale-currency-format-perl needs to be added * INSTALL.ubuntu: section 1.6 from INSTALL.ubuntu needs removing -- You are receiving this mail because: You are watching all bug changes.

1 26

[Bug 10948] New: Some strings in the authority result list turned out untranslatable
by bugzilla-daemon＠bugs.koha-community.org 13 Nov '13

13 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10948 Bug ID: 10948 Summary: Some strings in the authority result list turned out untranslatable Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: frederic(a)tamil.fr Created attachment 21449 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=21449&action=edit Authority search result list The see from and see also texts in the authority result list are not picked up by the translation scripts. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 15