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

[Bug 17354] New: Group By/Order By SQL mismatch in issues_stats.pl
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17354 Bug ID: 17354 Summary: Group By/Order By SQL mismatch in issues_stats.pl Change sponsored?: --- Product: Koha Version: 16.05 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Reports Assignee: gmcharlt(a)gmail.com Reporter: jcoehoorn(a)york.edu QA Contact: testopia(a)bugs.koha-community.org I'm looking in intranet/cgi-bin/reports/issues_stats.pl. I'm not sure of the exact line number, since I may have changed some white space earlier in the file on my system while tracking this down, but near line 350 in that file you'll see this: $colorder = ($colfield =~ /dayname/) ? "weekday($column)" : ($colfield =~ /^month/ ) ? " month($column)" : $colfield; The $colorder value will be used in the ORDER BY clause for the final SQL statement for the report. Contrast that with this code from earlier in the file, which will be used for the GROUP BY and SELECT clauses: $colfield = ($dsp == 1) ? " dayname($column)" : ($dsp == 2) ? "monthname($column)" : There's a clear mismatch here. The earlier snippet should be using "monthname()" instead of "month()", to match the GROUP BY syntax. I found this while playing with Ubunutu 16.04/MySql 5.7. I have turned strict mode off in MySql 5.7, but even with strict mode off the Circulation Report listed under "Statistics Wizards" was broken when I tried to group by month. I suspect grouping by day will be broken as well. The report works as expected for grouping by month after changing to use the monthname() function. -- You are receiving this mail because: You are watching all bug changes.

1 1

[Bug 17133] New: DE Startseite
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17133 Bug ID: 17133 Summary: DE Startseite Change sponsored?: --- Product: Project Infrastructure Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Project website Assignee: wizzyrea(a)gmail.com Reporter: mirko(a)abunchofthings.net Übersetzung der Startseite -- You are receiving this mail because: You are watching all bug changes.

1 5

[Bug 17004] New: REST API: add route to authenticate patron
by bugzilla-daemon＠bugs.koha-community.org 25 Jun '23

25 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17004 Bug ID: 17004 Summary: REST API: add route to authenticate patron Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: mail(a)jkozlovsky.cz QA Contact: testopia(a)bugs.koha-community.org Add API route to authenticate patron. This would be very useful for 3rd party applications, such as NCIP's LookupUser service or simpleSAMLphp IdP for eduGAIN. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 57

[Bug 16956] New: Inserting null borrowernumber value in statistics table while book is checkin if book is not checkedout
by bugzilla-daemon＠bugs.koha-community.org 10 Jun '23

10 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16956 Bug ID: 16956 Summary: Inserting null borrowernumber value in statistics table while book is checkin if book is not checkedout Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: amitddng135(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Inserting null borrowernumber value in statistics table while book is checkin if book is not checkedout -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 4

[Bug 17482] New: Untranslatable "Machine generated authority record" ( Marc field 667$a)
by bugzilla-daemon＠bugs.koha-community.org 08 Jun '23

08 Jun '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17482 Bug ID: 17482 Summary: Untranslatable "Machine generated authority record" (Marc field 667$a) Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: I18N/L10N Assignee: koha-bugs(a)lists.koha-community.org Reporter: marjorie.barry-vila(a)ccsr.qc.ca QA Contact: testopia(a)bugs.koha-community.org CC: frederic(a)tamil.fr Hi, When an authority is automaticaly created, marc field 667$a contains "Machine generated authority record". I don't find this string in the translation file (fr-CA or fr-FR) Regards, Marjorie -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 3

[Bug 16243] New: Add Mendeley reference manager to OPAC
by bugzilla-daemon＠bugs.koha-community.org 26 May '23

26 May '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16243 Bug ID: 16243 Summary: Add Mendeley reference manager to 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: hector.hecaxmmx(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Mendeley provides a mechanism for export bib records to a personal account in a free reference manager and academic social network (similar to Zotero) <https://www.mendeley.com/> -- You are receiving this mail because: You are watching all bug changes.

1 64

[Bug 16522] New: Add 773 (Host item entry) to the cart display and e-mail
by bugzilla-daemon＠bugs.koha-community.org 19 May '23

19 May '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16522 Bug ID: 16522 Summary: Add 773 (Host item entry) to the cart display and e-mail 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 When adding an analytical record to your cart or your list, the host item entry - the serial or monograph the analytic is included in, will now show. Ideally this information should show in staff and OPAC - in the brief display table - on the more details view - in the e-mail text For libraries with a lot of analytical records this is quite an issue. -- You are receiving this mail because: You are watching all bug changes.

1 123

[Bug 17867] New: Improve display of source (MARC21 773) in result list
by bugzilla-daemon＠bugs.koha-community.org 14 May '23

14 May '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17867 Bug ID: 17867 Summary: Improve display of source (MARC21 773) in result list 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 Currently only $t is shown. If there is no author in $a, the title goes in $a and there is no $t. We should also catch this case and show at least a and t. >From the XSLT: 928 <xsl:if test="marc:datafield[@tag=773]"> 929 <xsl:for-each select="marc:datafield[@tag=773]"> 930 <xsl:if test="marc:subfield[@code='t']"> 931 <span class="results_summary"> 932 <span class="label">Source: </span> 933 <xsl:value-of select="marc:subfield[@code='t']"/> 934 </span> 935 </xsl:if> 936 </xsl:for-each> 937 </xsl:if> Note: if there were multiple 773, the lable would be printed mulitple times. -- You are receiving this mail because: You are watching all bug changes.

1 17

[Bug 16732] New: Add audio alerts (custom sound notifications) to web based self checkout
by bugzilla-daemon＠bugs.koha-community.org 10 May '23

10 May '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16732 Bug ID: 16732 Summary: Add audio alerts (custom sound notifications) to web based self checkout Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Self checkout Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org Work to be done: * Create new audio alert entries for self check out in the administration area * Have sounds be accessible via the self check * Play sounds at appropriate times in the self check interface -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 18

[Bug 16640] New: Move actions on acquisitions receipt summary page into menu
by bugzilla-daemon＠bugs.koha-community.org 09 May '23

09 May '23

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16640 Bug ID: 16640 Summary: Move actions on acquisitions receipt summary page into menu Change sponsored?: --- Product: Koha Version: master Hardware: All URL: /cgi-bin/koha/acqui/parcel.pl?invoiceid=x OS: All Status: ASSIGNED 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, veron(a)veron.ch Depends on: 16592 Created attachment 51965 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=51965&action=ed… Screenshot showing one part of the proposed change I propose to consolidate some links on the acquisitions receipt summary page into menus: - MARC and Card view - Receive, transfer, cancel etc. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16592 [Bug 16592] Use Bootstrap modal for MARC and Card preview on acquisitions receipt summary page -- You are receiving this mail because: You are watching all bug changes.

1 15