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

[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 11264] New: Add German seasons to serials
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '13

19 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11264 Bug ID: 11264 Summary: Add German seasons to serials Change sponsored?: --- Product: Koha Version: 3.14 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com Currently the seasons are hardcoded in Serials.pm. i will add the German season names, so seasonal patterns can be used, until bug 11262 is fixed. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 12

[Bug 3445] action_logs table needs some thought
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '13

19 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3445 --- Comment #3 from Fridolyn SOMERS <fridolyn.somers(a)biblibre.com> --- This is important because without db indexes, using log viewer may block the database for a moment. In some cases, action_logs table has more than a million rows. Also this may be a bug more than an enhancement. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 3445] action_logs table needs some thought
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '13

19 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3445 Fridolyn SOMERS <fridolyn.somers(a)biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Patch complexity|--- |Small patch -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 3445] action_logs table needs some thought
by bugzilla-daemon＠bugs.koha-community.org 19 Nov '13

19 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=3445 Fridolyn SOMERS <fridolyn.somers(a)biblibre.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |Needs Signoff CC| |fridolyn.somers(a)biblibre.co | |m Assignee|gmcharlt(a)gmail.com |fridolyn.somers(a)biblibre.co | |m --- Comment #2 from Fridolyn SOMERS <fridolyn.somers(a)biblibre.com> --- Created attachment 23024 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=23024&action=edit Bug 3445 - action_logs table needs indexes [2] patch adding indexes to action_logs -- You are receiving this mail because: You are watching all bug changes.

1 0

[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 11012] New: Update dependencies to account for new crypt lib
by bugzilla-daemon＠bugs.koha-community.org 18 Nov '13

18 Nov '13

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11012 Bug ID: 11012 Summary: Update dependencies to account for new crypt lib 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: robin(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz Bug 9611 has a new dependency that the packages need to refer to. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 7

Z39.50 search results: DATE blank - add PUBLISHER
by Andrea Furin 18 Nov '13

18 Nov '13

1. If you have the field DATE blank when you make a Z39.50 search you have to modify the file: /usr/share/koha/lib/C4/Breeding.pm at line 394: $row_data{date} = $oldbiblio->{copyrightdate}; in $row_data{date} = $oldbiblio->{publicationyear}; (Make a copy of your modification becaurse probably ad update will change that file). 2. If you want to see the publisher's name in Z39.50 results you have to add a line in: /usr/share/koha/lib/C4/Breeding.pm at line 394: $row_data{server} = $servername[$k]; $row_data{isbn} = $oldbiblio->{isbn}; $row_data{lccn} = $oldbiblio->{lccn}; $row_data{title} = $oldbiblio->{title}; $row_data{author} = $oldbiblio->{author}; $row_data{date} = $oldbiblio->{publicationyear}; **** $row_data{publisher} = $oldbiblio->{publishercode}; $row_data{edition} = $oldbiblio->{editionstatement}; and in: /usr/share/koha/intranet/htdocs/intranet-tmpl/prog/en/modules/cataloguing/z3950_search.tt (change ../prog/LANGUAGE/modules/.. if not english) at line 155 the search results mask: <th>Server</th> <th>Title</th> <th>Author</th> <th>Date</th> **** <th>Publisher</th> <th>Edition</th> <th>ISBN</th> <th>LCCN</th> [Below the correspondet modified lines:] <td>[% breeding_loo.server %] <div class="linktools"><a href="/cgi-bin/koha/catalogue/showmarc.pl?importid=[% breeding_loo.bree$ <td>[% breeding_loo.title |html %]</td> <td>[% breeding_loo.author %]</td> <td>[% breeding_loo.date %]</td> **** <td>[% breeding_loo.publisher %]</td> <td>[% breeding_loo.edition %]</td> <td>[% breeding_loo.isbn %]</td> <td>[% breeding_loo.lccn %]</td>

1 0