September 2020 - Koha-bugs - lists.koha-community.org

[Bug 19967] New: Search patrons with non-Latin languages is brocken if DefaultPatronSearchFields includes dateofbirth
by bugzilla-daemon＠bugs.koha-community.org 02 Sep '20

02 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19967 Bug ID: 19967 Summary: Search patrons with non-Latin languages is brocken if DefaultPatronSearchFields includes dateofbirth Change sponsored?: --- Product: Koha Version: 16.11 Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: ulrich.kleiber(a)bsz-bw.de QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com In this particular case you get the mysql error message: Illegal mix of collations for operation 'like' You can prevent this error by removing dateofbirth from DefaultPatronSearchFields or by the following patch: diff --git a/C4/Utils/DataTables/Members.pm b/C4/Utils/DataTables/Members.pm index 2446703..ba32a12 100644 --- a/C4/Utils/DataTables/Members.pm +++ b/C4/Utils/DataTables/Members.pm @@ -117,7 +117,12 @@ sub search { my @where_strs_or; for my $searchfield ( split /,/, $searchfields->{$searchfieldstype} ) { - push @where_strs_or, "borrowers." . $dbh->quote_identifier($searchfield) . " LIKE ?"; + if ( $searchfield eq 'dateofbirth' ) { + push @where_strs_or, "DATE_FORMAT(borrowers." . $dbh->quote_identifier($searchfield) . ", '%Y-%m-%d') LIKE ?"; + } else { + push @where_strs_or, "borrowers." . $dbh->quote_identifier($searchfield) . " LIKE ?"; + } + push @where_args, $term; } -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 10

[Bug 25803] New: Internet Explorer: unable to save patron edits or view patron checkouts
by bugzilla-daemon＠bugs.koha-community.org 02 Sep '20

02 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=25803 Bug ID: 25803 Summary: Internet Explorer: unable to save patron edits or view patron checkouts Change sponsored?: --- Product: Koha Version: 19.11 Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Browser compatibility Assignee: oleonard(a)myacpl.org Reporter: janet.mcgowan(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org This is on the staff interface. On 19.11 sites using Internet Explorer 11 we have found 2 issues: - /members/memberentry.pl make an edit to a patron record and click Save. The page does not save. - If a user has checkouts, on /members/moremember.pl in the issues table no issues are displayed. Click on Always show checkouts immediately and no issues are displayed. I marked this as Major as we still have customers with organisations restricted to using IE. Thanks. -- You are receiving this mail because: You are watching all bug changes.

1 9

[Bug 26091] New: Add column configuration and export options to catalog statistics report
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26091 Bug ID: 26091 Summary: Add column configuration and export options to catalog statistics report Change sponsored?: --- Product: Koha Version: master Hardware: All 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: caroline.cyr-la-rose(a)inlibro.com, katrin.fischer(a)bsz-bw.de, koha-bugs(a)lists.koha-community.org, testopia(a)bugs.koha-community.org Blocks: 19282 The catalog statistics report can return results in a table with an arbitrary set of columns, so it's not possible to define a global table settings configuration, but it is possible to add on-the-fly columns settings and export options to the page. Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19282 [Bug 19282] Add the copy, print and export DataTables buttons on all koha tables -- You are receiving this mail because: You are watching all bug changes. You are on the CC list for the bug.

1 13

[Bug 26345] New: new
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26345 Bug ID: 26345 Summary: new Change sponsored?: --- Product: Koha Version: 20.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Acquisitions Assignee: koha-bugs(a)lists.koha-community.org Reporter: jeff96hcs(a)yahoo.com QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 5959] Add search link for analytics to serial records
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=5959 Katrin Fischer <katrin.fischer(a)bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Blocks|15851 | Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15851 [Bug 15851] "Analytics: Show analytics" showing regardless of whether they have analytics -- You are receiving this mail because: You are the QA Contact for the bug. You are watching all bug changes.

1 0

[Bug 26335] New: Aku
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26335 Bug ID: 26335 Summary: Aku Change sponsored?: --- Product: Koha Version: unspecified Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Web services Assignee: koha-bugs(a)lists.koha-community.org Reporter: xaihaxor(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Created attachment 109426 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=109426&action=e… Sayank Sayang kamu -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 1

[Bug 26320] New: Crash when click search button with empty key word
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26320 Bug ID: 26320 Summary: Crash when click search button with empty key word Change sponsored?: --- Product: Project Infrastructure Version: unspecified Hardware: PC OS: Windows Status: NEW Severity: major Priority: P5 - low Component: Bugzilla Assignee: jonathan.druart(a)bugs.koha-community.org Reporter: yuan.wan(a)sjsu.edu Go to the Buzilla main page and click search button with empty key word. Then it will crash(testing). -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 11299] Add a button to automatically link authority records in cataloguing (AJAX)
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11299 Jonathan Druart <jonathan.druart(a)bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|Passed QA |ASSIGNED -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 14825] Accounts Rewrite Omnibus
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14825 Martin Renvoize <martin.renvoize(a)ptfs-europe.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Depends on| |26332 Referenced Bugs: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=26332 [Bug 26332] Koha::Account::pay incorrectly defaults to '0' for manager_id -- You are receiving this mail because: You are watching all bug changes.

1 0

[Bug 12617] Koha should let admins to configure automatically generated password complexity/difficulty
by bugzilla-daemon＠bugs.koha-community.org 01 Sep '20

01 Sep '20

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12617 Emmi Takkinen <emmi.takkinen(a)outlook.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ASSIGNED |Needs Signoff -- You are receiving this mail because: You are watching all bug changes.

1 0