May 2016 - Koha-bugs - lists.koha-community.org

[Bug 16076] New: DBIx searches - performance issues
by bugzilla-daemon＠bugs.koha-community.org 08 Jul '16

08 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16076 Bug ID: 16076 Summary: DBIx searches - performance issues Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: abl(a)biblos.pk.edu.pl QA Contact: testopia(a)bugs.koha-community.org While testing Bug 11998 and Bug 15341, I did some quick & dirty comparisons on DBI vs DBIx search performace - how long does it take to fetch from the database: one small system preference (marcflavour) and all system preferences (545 rows). Results: 1) one syspref, DBI: 130 microseconds ( using 'SELECT value FROM systempreferences WHERE variable = ? LIMIT 1') 2) one syspref, DBIx: 1.25 miliseconds ( Koha::Config::SysPrefs->find($var)->value() ) 3) all preferences, DBI: 1.8 miliseconds ( 'SELECT variable, value FROM systempreferences' ) 4) all preferences, DBIx: 21 miliseconds ( Koha::Config::SysPrefs->search()->unblessed(), like in Bug 15341) If I use my $all_prefs_rs = Koha::Config::SysPrefs->search( undef, { columns => [qw/value variable/] } )->unblessed(); in 4), search is a bit quicker (17.1 ms). Maybe it can be improved somehow further, but I don't know how - any ideas? Those numbers may look not very significant at the first glanace, but remember that it's not uncommon for the Koha script to make 2000+ DBI calls (in such cases, they are usually very repetitive - small stuff fetched from uncomplicated tables, over and over again). -- You are receiving this mail because: You are watching all bug changes.

1 6

[Bug 16502] New: Table koha_plugin_com_bywatersolutions_kitchensink_mytable not always dropped after running Plugin.t
by bugzilla-daemon＠bugs.koha-community.org 08 Jul '16

08 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16502 Bug ID: 16502 Summary: Table koha_plugin_com_bywatersolutions_kitchensink_mytable not always dropped after running Plugin.t Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org Happened to notice that running this test (t/db_dependent/Plugin.t) twice may not have the expected result. Sometimes(?) I need to manually drop the table. Note that quickly adding a transaction does not resolve it. -- You are receiving this mail because: You are watching all bug changes.

1 34

[Bug 16589] New: Quote of the day: Can not upload csv file
by bugzilla-daemon＠bugs.koha-community.org 06 Jul '16

06 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16589 Bug ID: 16589 Summary: Quote of the day: Can not upload csv file Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: veron(a)veron.ch QA Contact: testopia(a)bugs.koha-community.org Upload a valid CSV file to QOD results in error message. Uploads limited to csv. Incorrect filetype: application/vnd.sun.xml.calc Tested with a valid sample file from Bug 15684 - Fix encoding issues with quote upload https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=47405 -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 16278] New: Export.pl Tool needs select all/unselect all boxes for Library section
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '16

05 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16278 Bug ID: 16278 Summary: Export.pl Tool needs select all/unselect all boxes for Library section Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: hbraum(a)nekls.org QA Contact: testopia(a)bugs.koha-community.org The export.pl tool needs select all and unselect all boxes for the Library section. Right now, if you're only wanting a certain library's records exported, you have to unchecked lots of boxes (if you're in a multi-branch system). For us, that's 51 boxes to uncheck. -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 16548] New: All libraries selected on Tools -> Export Data screen
by bugzilla-daemon＠bugs.koha-community.org 05 Jul '16

05 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16548 Bug ID: 16548 Summary: All libraries selected on Tools -> Export Data screen Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Tools Assignee: gmcharlt(a)gmail.com Reporter: joy(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org In 3.22.05 when a user goes to the Tools->Export Data screen. All the libraries are listed and checked. This causes two issues: 1. In a large consortium a user may need to unclick a large number of boxes to only get the libraries they want. 2. When the tool is run as is (with all libraries selected) bibliographic records without items are not exported. (ebook bib records without items) -- You are receiving this mail because: You are watching all bug changes.

1 19

[Bug 16543] New: Make edit and delete links styled buttons in patron attribute types administration
by bugzilla-daemon＠bugs.koha-community.org 01 Jul '16

01 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16543 Bug ID: 16543 Summary: Make edit and delete links styled buttons in patron attribute types administration Change sponsored?: --- Product: Koha Version: master Hardware: All URL: /cgi-bin/koha/admin/cities.pl OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: testopia(a)bugs.koha-community.org In Administration -> Patron attribute types, the edit and delete buttons should be made into Bootstrap-styled buttons with Font Awesome icons. -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 16541] New: Make edit and delete links styled buttons in cities administration
by bugzilla-daemon＠bugs.koha-community.org 01 Jul '16

01 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16541 Bug ID: 16541 Summary: Make edit and delete links styled buttons in cities administration Change sponsored?: --- Product: Koha Version: master Hardware: All URL: /cgi-bin/koha/admin/cities.pl OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org In Administration -> Cities, the edit and delete buttons should be made into Bootstrap-styled buttons with Font Awesome icons. -- You are receiving this mail because: You are watching all bug changes.

1 10

[Bug 16127] New: Add discharge menu item to patron toolbar
by bugzilla-daemon＠bugs.koha-community.org 01 Jul '16

01 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16127 Bug ID: 16127 Summary: Add discharge menu item to patron toolbar Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org The patron discharge feature added a "Discharge" tab in the left-hand sidebar menu. I think if we follow views vs. actions guideline (https://wiki.koha-community.org/wiki/Interface_patterns#Views_and_Actions) the link in the sidebar should say "Discharges" (as in view the patron's list of discharges) and there should be menu item in the toolbar (members-toolbar.inc) for the action of discharging the patron. I think this should be added to the "More" drop-down menu. -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 16594] New: Orders by fund has wrong link to css and other issues
by bugzilla-daemon＠bugs.koha-community.org 01 Jul '16

01 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16594 Bug ID: 16594 Summary: Orders by fund has wrong link to css and other issues Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: trivial Priority: P5 - low Component: Templates Assignee: hector.hecaxmmx(a)gmail.com Reporter: hector.hecaxmmx(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Orders by fund has wrong link to css and other issues -> The example in the wiki is wrong: <https://wiki.koha-community.org/wiki/DataTables_HowTo> <link rel="stylesheet" type="text/css" href="[% themelang %]/css/datatables.css" /> [% INCLUDE 'datatables.inc' %] -> Must be: <link rel="stylesheet" type="text/css" href="[% interface %]/[% theme %]/css/datatables.css" /> NOTE: Wiki needs to be updated -> Missing <th></th> in <tfoot> tag -> Wrong word used "Date deceived" should be "Date received" -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 16607] New: Add verbose flag to builder sub in TestBuilder
by bugzilla-daemon＠bugs.koha-community.org 01 Jul '16

01 Jul '16

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16607 Bug ID: 16607 Summary: Add verbose flag to builder sub in TestBuilder Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Test Suite Assignee: chris(a)bigballofwax.co.nz Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: gmcharlt(a)gmail.com -- You are receiving this mail because: You are watching all bug changes.

1 23