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

[Bug 7879] New: Memoize::Memcached two times slower than it should be
by bugzilla-daemon＠bugs.koha-community.org 13 Jul '15

13 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7879 Priority: P5 - low Change sponsored?: --- Bug ID: 7879 Assignee: gmcharlt(a)gmail.com Summary: Memoize::Memcached two times slower than it should be QA Contact: koha.sekjal(a)gmail.com Severity: enhancement Classification: Unclassified OS: All Reporter: dpavlin(a)rot13.org Hardware: All Status: NEW Version: rel_3_6 Component: Architecture, internals, and plumbing Product: Koha Created attachment 8791 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=8791&action=edit Memoize::Memcached 2x speedup While profiling Koha with memcached turned on I was stunned by NYTProf results: Calls P F Exclus Inclus Subroutine 55 2 1 1.70s 1.70s Memoize::Memcached::EXISTS 55 2 1 1.68s 1.68s Memoize::Memcached::FETCH Code analysts showed that it generates two FETCH requests for each item. Attached patch fixes upstream module and might be beneficial on existing Koha installations which use memcached. It uses shared variable, and it's safe in CGI installations. Having shared variable showed another characteristic of current code: 55 2 1 33.8ms 33.8ms Memoize::Memcached::EXISTS 55 2 1 362µs 362µs Memoize::Memcached::FETCH This is good, but a little bit too fast. Examining hit and miss ratio stored in Koha::Persistant::stats it turns out that we are accessing memcache 106 times, but only 4 times for new values. -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 12919] New: It'd be nice to be able to automate collecting all records added and deleted from the catalogue
by bugzilla-daemon＠bugs.koha-community.org 13 Jul '15

13 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12919 Bug ID: 12919 Summary: It'd be nice to be able to automate collecting all records added and deleted from the catalogue Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: new feature Priority: P5 - low Component: Command-line Utilities Assignee: gmcharlt(a)gmail.com Reporter: chris(a)bigballofwax.co.nz QA Contact: testopia(a)bugs.koha-community.org In NZ almost all libraries participate in the National Union Catalogue, which means that libraries have to update their holdings periodically. So we created a system that runs as a cronjob and will generate a list of records added or updated in the catalogue, and a list of isbn of deleted records. These can be run as cron jobs with the output being emailed to a person or thing. Although this was initially designed to support the needs of NZ libraries, it is general enough that it can be used by anyone. -- You are receiving this mail because: You are watching all bug changes.

1 21

[Bug 14443] New: Man pages need to be updated for koha-mysql
by bugzilla-daemon＠bugs.koha-community.org 12 Jul '15

12 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14443 Bug ID: 14443 Summary: Man pages need to be updated for koha-mysql Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Command-line Utilities Assignee: gmcharlt(a)gmail.com Reporter: barton(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: robin(a)catalyst.net.nz The following bug: Bug 12372 -- "feature request: debian/scripts/koha-mysql should be able to handle arbitrary mysql arguments." Extends the way that koha-mysql may be called. Once that patch is applied, arbitrary mysql arguments may be given after the instance name. The synopsis should change to koha-mysql INSTANCE-NAME [ mysql arguments ] Also, the '-e' option is now available, so the example usage may change to koha-mysql {instancename} -e "Some SQL query" It would also be useful to provide an explicit example of a mysql argument whose functionality was previously entirely unavailable, e.g. koha-mysql {instancename} --skip-column-names 'See Also' should mention mysql. -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 10756] New: Carousel Display of New Titles on OPAC home page
by bugzilla-daemon＠bugs.koha-community.org 11 Jul '15

11 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=10756 Bug ID: 10756 Summary: Carousel Display of New Titles on OPAC home page Change sponsored?: --- Product: Koha Version: master Hardware: All OS: Linux Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: bob(a)calyx.net.au QA Contact: testopia(a)bugs.koha-community.org This feature displays recently added items to your Koha's main OPAC page, using a 'carousel' style display. This feature can be enabled/disabled via a Koha syspref, and requires memcached. This feature can be styled and configured using CSS. A demo of the feature (Koha-3.10) is available at http://demo.calyx.net.au This feature adds to Koha the ContentFlow library by JacksAsylum.eu (MIT license): http://jacksasylum.eu/ContentFlow/index.php Special thanks to Harvest Bible College, Australia for sponsoring this feature. Thanks also to Albany Senior High School,New Zealand and KohaAloha for an earlier prototype. -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 13444] New: OPACFallback has option 'Prog'
by bugzilla-daemon＠bugs.koha-community.org 11 Jul '15

11 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13444 Bug ID: 13444 Summary: OPACFallback has option 'Prog' Change sponsored?: --- Product: Koha Version: 3.18 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: System Administration Assignee: koha-bugs(a)lists.koha-community.org Reporter: mirko(a)abunchofthings.net QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com In 3.18 I see 'Prog' as an option for OPACFallback. Prog has been removed, so that option does not make much sense. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 13263] New: Printing Callnumber in Koha 3.16.04.000.
by bugzilla-daemon＠bugs.koha-community.org 11 Jul '15

11 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13263 Bug ID: 13263 Summary: Printing Callnumber in Koha 3.16.04.000. Change sponsored?: --- Product: Koha Version: 3.16 Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: os.jerwynfernandez(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 33610 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=33610&action=edit Wrong Callnumber Format Check the callnumber, whenever it is exported as a PDF file. Koha doesn't follow the format the way you want to print it. Character doesn't split normally and all letters are in caps. Please see attached file for reference. Thanks! -- You are receiving this mail because: You are watching all bug changes.

1 8

[Bug 5533] New: marking item lost diff in two places
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '15

10 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5533 Summary: marking item lost diff in two places Change sponsored?: --- Product: Koha Version: HEAD Platform: All OS/Version: All Status: NEW Severity: critical Priority: P5 Component: Cataloging AssignedTo: gmcharlt(a)gmail.com ReportedBy: nengard(a)gmail.com QAContact: koha-bugs(a)lists.koha-community.org CC: ian.walls(a)bywatersolutions.com Estimated Hours: 0.0 Please see this screencast for details: http://screencast.com/t/6CJlMGQn2r42 Basically if you mark an item lost via edit items there is one behavior and if you mark it lost via the items tab there is another behavior. I think that the behavior that happens on the items tab is what we want (marking the item lost charges the patron the replacement fee). -- 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 49

[Bug 12903] New: UseQueryParse, Staff client search incatalog, Duplicated records massage when adding a record.
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '15

10 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12903 Bug ID: 12903 Summary: UseQueryParse, Staff client search incatalog, Duplicated records massage when adding a record. Change sponsored?: --- Product: Koha Version: 3.16 Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Cataloging Assignee: gmcharlt(a)gmail.com Reporter: ayousef(a)kwareict.com QA Contact: testopia(a)bugs.koha-community.org CC: m.de.rooy(a)rijksmuseum.nl Hello, We have tested search in catalog using (Search the catalog) tab located at the header of staff client more and more times, but the result always gets No results found No results match your search for 'science #'. Although searching the opac gets results correctly, and advanced search in intranet staff client also gets results correctly here: http://library.domain/cgi-bin/koha/opac-search.pl?q=science (opac gets results) and here: http://library.domain:8080/cgi-bin/koha/catalogue/search.pl?q=science (intranet doesn't get any result) also we have instances of koha 3.2 and koha 3.14.x and this type of search is working good. We noticed that activating System preference ( UseQueryParse ) was the reason that has stopped intranet staff client catalog search when we stopped it the search has been worked correctly. But stopping this system preference affected on adding new catalog records negatively specially Arabic records, Always the message of (duplicated record) appears. Here's the reason: the reason is because (isbn) number in many Arabic records is not necessary in old records, I mean it has the value of (NULL) in koha DB and when checking isbn numbers it considers the NULL values are for the same record, so it always asking if that record is identical to another one in database or not if we entered the record without (isbn) number, so i think the following snippet of code in (search.pm -->koha v3.16.01) doesn't exclude NULL values when checking record duplication by isbn numbers # search duplicate on ISBN, easy and fast.. # ... normalize first if ( $result->{isbn} ) { $result->{isbn} =~ s/\(.*$//; $result->{isbn} =~ s/\s+$//; $query = "isbn:$result->{isbn}"; } I'm asking if that is a bug??? thanks -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 13048] New: Serial Error when NULL date encountered
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '15

10 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13048 Bug ID: 13048 Summary: Serial Error when NULL date encountered Change sponsored?: --- Product: Koha Version: 3.14 Hardware: All OS: All Status: NEW Severity: blocker Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: joy(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com We have a number of libraries experiencing the following error: Date::Calc::Add_Delta_YM(): not a valid date at /home/koha/kohaclone/C4/Serials.pm line 2626, <DATA> line 522. When we investigate it appears that there is no serial.planneddate value. It is either NULL or there is no entry in the serial table for the subscriptionid. It appears that Koha is not handling 'bad data' well in the serials module in this case. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 14428] New: use dbh directly, not C4::Context->prepare
by bugzilla-daemon＠bugs.koha-community.org 10 Jul '15

10 Jul '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14428 Bug ID: 14428 Summary: use dbh directly, not C4::Context->prepare Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: mtompset(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org C4/Input.pm was tweaked to not use dbh directly. This gives us something kind of ugly autoload mess. Fix it. It is a partial revert of 'git show a1fe32d2'. -- You are receiving this mail because: You are watching all bug changes.

1 15