April 2017 - Koha-bugs - lists.koha-community.org

[Bug 17941] New: CanBookBeRenewed is very inefficient/slow
by bugzilla-daemon＠bugs.koha-community.org 29 Mar '18

29 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17941 Bug ID: 17941 Summary: CanBookBeRenewed is very inefficient/slow Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Hold requests Assignee: koha-bugs(a)lists.koha-community.org Reporter: boutrosboutrosboutros(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com I started investigating why populating the checkout list in the patron view sometimes took ages (minutes), and on occations even causing the system to almost halt because of DB overload. It turned out that reason is calls to C4::Circulation::CanBookBeRenewed. The critical factor is whether an item has many holds on it, and if there are many items that can fill the hold. Briefly looking at the code it seems obvious that the time spent grows exponentially with the number of holds and items. As one example, checking if an item with 111 holds (and 12 items on the biblio) can be renewed takes around 25 sec and generates over 18,000 SQL queries. I can't help to think there must be some missed "early returns" opportunities in the loops somewhere. For example, if there are more unfulfilled holds than available items, can the item ever be renewed? If no, return before even begin to calculate.. However, I know holds are full of complexities and things I probably haven't thought about so I need to dig into the code more. I would be very gratefull if anyone knowledgeable about this part of the code could help me find some ways to optimize this! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 54

[Bug 16427] New: Direct link to authority records missing in record detail view
by bugzilla-daemon＠bugs.koha-community.org 26 Mar '18

26 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16427 Bug ID: 16427 Summary: Direct link to authority records missing in record detail view Change sponsored?: --- Product: Koha Version: 3.22 Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: verolencinas(a)yahoo.com.ar QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com In previous versions of Koha you could see next to a controlled access point with link to an authority record a magnifying glass icon that linked to the authority record with or without the default XSLT enabled (XSLTDetailsDisplay). In the OPAC the icon is visible and usable. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 20

[Bug 16940] New: Show active currency's symbol to users in OPAC
by bugzilla-daemon＠bugs.koha-community.org 26 Mar '18

26 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16940 Bug ID: 16940 Summary: Show active currency's symbol to users in OPAC Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: OPAC Assignee: oleonard(a)myacpl.org Reporter: katrin.fischer(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org It would be nice if we could show the currency symbol in the OPAC. Formatting could be another system preference or maybe be wrapped into the existing CurrencyFormat system preference. -- You are receiving this mail because: You are watching all bug changes.

1 7

[Bug 17457] New: Use SearchWithISBNVariations in acquisition advanced search ( histsearch.pl)
by bugzilla-daemon＠bugs.koha-community.org 26 Mar '18

26 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17457 Bug ID: 17457 Summary: Use SearchWithISBNVariations in acquisition advanced search (histsearch.pl) 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: marjorie.barry-vila(a)ccsr.qc.ca QA Contact: testopia(a)bugs.koha-community.org Hi, In acquisition advanced search, it will be great that isbn index use system preference SearchWithISBNVariations. Regards, Marjorie -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 21

[Bug 17956] New: Provide additional functionality in the onboarding tool through configuring z-targets , and providing information on setting up SIP and LDAP services
by bugzilla-daemon＠bugs.koha-community.org 23 Mar '18

23 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17956 Bug ID: 17956 Summary: Provide additional functionality in the onboarding tool through configuring z-targets, and providing information on setting up SIP and LDAP services Change sponsored?: --- Product: Koha Version: 17.05 Hardware: All OS: All Status: ASSIGNED Severity: enhancement Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: alexbuckley(a)catalyst.net.nz Reporter: alexbuckley(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Depends on: 17855 This bug depends on bug 17855 because this bug adds additional functionality to the onboarding tool. The additional features are: 1. A tickbox to check if the user is using SIP, LDAP. If this tickbox is selected then information on how to set up these services is displayed. 2. A z-target configuration form (which is displayed if the user did not install sample z-targets in the web installer). Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17855 [Bug 17855] Updated Koha web installer and new onboarding tool feature to guide users through setting up Koha -- You are receiving this mail because: You are watching all bug changes.

1 40

[Bug 17672] New: Items table should have a damaged_on column
by bugzilla-daemon＠bugs.koha-community.org 23 Mar '18

23 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17672 Bug ID: 17672 Summary: Items table should have a damaged_on column 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: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Mirroring the itemlost_on column it would be nice to have the ability to see when an item was marked damaged so libraries can track repairs and mending. -- You are receiving this mail because: You are watching all bug changes.

1 27

[Bug 17462] New: Pay fines not accepting ', ' for EUR currency input
by bugzilla-daemon＠bugs.koha-community.org 13 Mar '18

13 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17462 Bug ID: 17462 Summary: Pay fines not accepting ',' for EUR currency input Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: claire_gravely(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com When currencyformat is set to EUR, it is not currently possible to enter amounts into pay amount /cgi-bin/koha/members/paycollect.pl?borrowernumber=XXX using ','(comma) instead of '.' (point). -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 9

[Bug 18384] New: Add syspref to show all subs attached to a biblio in serial collection by default
by bugzilla-daemon＠bugs.koha-community.org 09 Mar '18

09 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18384 Bug ID: 18384 Summary: Add syspref to show all subs attached to a biblio in serial collection by default Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Serials Assignee: koha-bugs(a)lists.koha-community.org Reporter: aleisha(a)catalyst.net.nz QA Contact: testopia(a)bugs.koha-community.org CC: colin.campbell(a)ptfs-europe.com At the moment, to see all subscriptions attached to a biblio in serial collection you must click another link. It would be nice to have a syspref that showed this page by default when viewing serial collection -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 10

[Bug 16671] New: Wrong itemtype picked in HoldsQueue.t
by bugzilla-daemon＠bugs.koha-community.org 05 Mar '18

05 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16671 Bug ID: 16671 Summary: Wrong itemtype picked in HoldsQueue.t Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org >From bug 14828: -my @item_types = C4::ItemType->all; -my @for_loan = grep { $_->{notforloan} == 0 } @item_types - or BAIL_OUT("No adequate itemtype"); -my $itemtype = $for_loan[0]->{itemtype}; +my $itemtype = Koha::ItemTypes->search({ notforloan => 1 })->next; +$itemtype or BAIL_OUT("No adequate itemtype"); #FIXME Should be $itemtype = $itemtype->itemtype (First you are allowed to wonder what this FIXME has not been done...) The wrong itemtypes are picked from the DB, we want itemtypes with notforloan == 0, not 1. -- You are receiving this mail because: You are watching all bug changes.

1 26

[Bug 17657] New: Item type' s images could not be displayed correctly on the item types admin page
by bugzilla-daemon＠bugs.koha-community.org 05 Mar '18

05 Mar '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17657 Bug ID: 17657 Summary: Item type's images could not be displayed correctly on the item types admin page Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: System Administration Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: jonathan.druart(a)bugs.koha-community.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com >From the ML https://lists.katipo.co.nz/pipermail/koha/2016-November/046616.html > When trying to configure an icon for an item type, the chosen icon won't > show in the Koha menu "Administration > Item types". I used to see the > icon in the first column entitled "Image" - now this column is empty. > Also the icon won't show in staff interface or OPAC. -- You are receiving this mail because: You are watching all bug changes.

1 12