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

[Bug 15435] New: MARC21: Include subfields n and p in Series volume information
by bugzilla-daemon＠bugs.koha-community.org 29 Dec '15

29 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15435 Bug ID: 15435 Summary: MARC21: Include subfields n and p in Series volume information Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: MARC Bibliographic data support Assignee: gmcharlt(a)gmail.com Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org In the OPAC and staff views only $v is shown for traced series. We should also include the information from $n and $p. -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 9949] New: Tidy up the intranet set up and fix a potential security issue when running from git
by bugzilla-daemon＠bugs.koha-community.org 29 Dec '15

29 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=9949 Bug ID: 9949 Summary: Tidy up the intranet set up and fix a potential security issue when running from git Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: chris(a)bigballofwax.co.nz -- You are receiving this mail because: You are watching all bug changes.

1 16

[Bug 8630] New: Add covers from AdLibris to the OPAC and Intranet
by bugzilla-daemon＠bugs.koha-community.org 28 Dec '15

28 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8630 Priority: P5 - low Change sponsored?: Sponsored Bug ID: 8630 Assignee: magnus(a)enger.priv.no Summary: Add covers from AdLibris to the OPAC and Intranet Severity: enhancement Classification: Unclassified OS: All Reporter: magnus(a)enger.priv.no Hardware: All Status: ASSIGNED Version: master Component: OPAC Product: Koha The "API" is really simple: http://www.adlibris.com/se/showimagesafe.aspx?isbn=9188876659 -- You are receiving this mail because: You are watching all bug changes.

1 10

[Bug 15406] New: Very SLOW OAI server performance
by bugzilla-daemon＠bugs.koha-community.org 28 Dec '15

28 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15406 Bug ID: 15406 Summary: Very SLOW OAI server performance Change sponsored?: --- Product: Koha Version: 3.20 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: dhd.koha(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org I noticed a very slow performance on oai server koha version 3.22 ! In particular the query ( SELECT biblioitems.biblionumber, biblioitems.timestamp, marcxml FROM biblioitems JOIN oai_sets_biblios ON biblioitems.biblionumber = oai_sets_biblios.biblionumber WHERE timestamp >= '1970-01-01 00:00:00' AND timestamp <= '2015-12-22 23:59:59' AND oai_sets_biblios.set_id = '4' ) UNION ( SELECT deletedbiblio.biblionumber, null as marcxml, timestamp FROM deletedbiblio JOIN oai_sets_biblios ON deletedbiblio.biblionumber = oai_sets_biblios.biblionumber WHERE DATE(timestamp) >= '1970-01-01T00:00:00Z' AND DATE(timestamp) <= '2015-12-22T23:59:59Z' AND oai_sets_biblios.set_id = '4' ) ORDER BY biblionumber LIMIT 51 OFFSET 0 As constructed by oai.pl Requires about a minute to get results for each fetch! So according to my rough calculations a 500K marcs catalogue would require about 6 days to be harvested! Harry! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 2

[Bug 15350] New: DBIx::Class Startup speed
by bugzilla-daemon＠bugs.koha-community.org 28 Dec '15

28 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15350 Bug ID: 15350 Summary: DBIx::Class Startup speed Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org (This follows 15341 comment 5) From https://metacpan.org/pod/distribution/DBIx-Class/lib/DBIx/Class/Manual/Cook… There are some tips to follow to reduce the DBIx::Class startup delays. === 1 - Statically Define Your Schema If you are using DBIx::Class::Schema::Loader to build the classes dynamically based on the database schema then there will be a significant startup delay. For production use a statically defined schema (which can be generated using DBIx::Class::Schema::Loader to dump the database schema once - see make_schema_at and dump_directory for more details on creating static schemas from a database). 2 - Move Common Startup into a Base Class Typically DBIx::Class result classes start off with use base qw/DBIx::Class::Core/; __PACKAGE__->load_components(qw/InflateColumn::DateTime/); If this preamble is moved into a common base class:- package MyDBICbase; use base qw/DBIx::Class::Core/; __PACKAGE__->load_components(qw/InflateColumn::DateTime/); 1; and each result class then uses this as a base:- use base qw/MyDBICbase/; then the load_components is only performed once, which can result in a considerable startup speedup for schemas with many classes. 3 - Explicitly List Schema Result Classes The schema class will normally contain __PACKAGE__->load_classes(); to load the result classes. This will use Module::Find to find and load the appropriate modules. Explicitly defining the classes you wish to load will remove the overhead of Module::Find and the related directory operations: __PACKAGE__->load_classes(qw/ CD Artist Track /); If you are instead using the load_namespaces syntax to load the appropriate classes there is not a direct alternative avoiding Module::Find. 4 - MEMORY USAGE Cached statements DBIx::Class normally caches all statements with prepare_cached(). This is normally a good idea, but if too many statements are cached, the database may use too much memory and may eventually run out and fail entirely. -- You are receiving this mail because: You are watching all bug changes.

1 5

[Bug 15341] New: Performance - Retrieve all sysprefs at once
by bugzilla-daemon＠bugs.koha-community.org 28 Dec '15

28 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15341 Bug ID: 15341 Summary: Performance - Retrieve all sysprefs at once Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org C4::Context->preference generates a call to Koha::Config::SysPrefs->find for all different sysprefs we are searching for. It seems to be a performance killer and be better to retrieve them all together. -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 15342] New: Performance 3.22 - Omnibus
by bugzilla-daemon＠bugs.koha-community.org 28 Dec '15

28 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15342 Bug ID: 15342 Summary: Performance 3.22 - Omnibus Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 7

[Bug 14493] New: export_borrowers.pl - Export patron attributes
by bugzilla-daemon＠bugs.koha-community.org 28 Dec '15

28 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14493 Bug ID: 14493 Summary: export_borrowers.pl - Export patron attributes Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: vfernandes(a)keep.pt QA Contact: testopia(a)bugs.koha-community.org When using the script export_borrowers.pl the patron attributes are not exposed to the CSV. The idea is to have a field called patron_attributes that exposes all the extended attributes. -- You are receiving this mail because: You are watching all bug changes.

1 13

[Bug 12549] New: Hard coded font Paths ( DejaVu ) cause problems for non-Debian systems
by bugzilla-daemon＠bugs.koha-community.org 28 Dec '15

28 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12549 Bug ID: 12549 Summary: Hard coded font Paths ( DejaVu ) cause problems for non-Debian systems Change sponsored?: --- Product: Koha Version: 3.16 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Installation and upgrade (command-line installer) Assignee: gmcharlt(a)gmail.com Reporter: vanoudt(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org In Koha-conf.xml, the font paths for the DejaVu fonts are hardcoded. Unfortunately, the paths don't match the installed font locations in other distributions (such as Fedora). Ideally, the system should enquire of fontconfig where the fonts are installed. Something like: fc-list : file | grep Deja spits out the correct paths, and should work across distributions. Just spent quite a long time trying to figure out why the Creators.t test was continually failing during make test even though they ran fine manually. Problem seems to have been this! -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 15235] New: Add column filters to checkouts table
by bugzilla-daemon＠bugs.koha-community.org 28 Dec '15

28 Dec '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15235 Bug ID: 15235 Summary: Add column filters to checkouts table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: julian.maurice(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When dealing with a large number of checkouts, it could be useful to filter them (before using renew/checkin/export checkboxes for instance). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3