February 2018 - Koha-bugs - lists.koha-community.org

[Bug 18336] New: Use utf8mb4 instead of utf8 for MySQL tables, columns, and connections
by bugzilla-daemon＠bugs.koha-community.org 31 Aug '18

31 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18336 Bug ID: 18336 Summary: Use utf8mb4 instead of utf8 for MySQL tables, columns, and connections 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: dcook(a)prosentient.com.au QA Contact: testopia(a)bugs.koha-community.org As noted by myself on the koha-devel listserv, Martin on https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11944#c247, and Mark Tompsett on https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=15794#c2, we might want to use utf8mb4 instead of utf8 for MySQL tables, columns, and connections. utf8 in MySQL has a 3 byte limit: https://dev.mysql.com/doc/refman/5.7/en/charset-unicode-utf8.html. While most "normal" characters in most languages are covered by 1-3 bytes, UTF8 does allow for 4 bytes, which means we have a problem using lesser used characters in Chinese, Japanese, and Korean among other languages. It also means we can't store emoji. When MySQL encounters a 4 byte UTF8 character, it immediately truncates the string from that character onward. Unfortunately, it doesn't raise an error. It raises a warning, which isn't that easy to detect. In my case, I'm trying to store a MARCXML record with a 4 byte character, and while C4::Biblio::AddBiblio returns true, MySQL corrupts the XML record when using utf8 encoding rather than utf8mb4 (both in terms of the MySQL column and the MySQL connection set by Koha::Database). -- You are receiving this mail because: You are watching all bug changes.

1 102

[Bug 16702] New: Notice Triggers Issue: Delivery Mechanism Options Not Saving
by bugzilla-daemon＠bugs.koha-community.org 29 Aug '18

29 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16702 Bug ID: 16702 Summary: Notice Triggers Issue: Delivery Mechanism Options Not Saving Change sponsored?: --- Product: Koha Version: 16.05 Hardware: PC OS: Linux Status: NEW Severity: blocker Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: bassplayer9(a)hotmail.com QA Contact: testopia(a)bugs.koha-community.org Problem with Notice & Status Triggers (Tools › Notice triggers) When attempting to save my notice trigger configuration after (1) setting a delay integer, (2) selecting an overdue notice template, and (3) then choosing a delivery type (Email, SMS, etc.), the configuration saves but without the any of the delivery method types saving/sticking - they reset to an unchecked status. I do get a "changes saved" confirmation overall, but my delivery mechanism selections disappear for Email, Print, and SMS after clicking the "Save Changes" button. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 4

[Bug 20248] New: Elasticsearch - Improvements to mappings UI and indexing script
by bugzilla-daemon＠bugs.koha-community.org 24 Aug '18

24 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20248 Bug ID: 20248 Summary: Elasticsearch - Improvements to mappings UI and indexing script Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Searching - Elasticsearch Assignee: koha-bugs(a)lists.koha-community.org Reporter: ere.maijala(a)helsinki.fi -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 49

[Bug 20160] New: Sort translated languages by code
by bugzilla-daemon＠bugs.koha-community.org 23 Aug '18

23 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20160 Bug ID: 20160 Summary: Sort translated languages by code Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: koha-bugs(a)lists.koha-community.org Reporter: pasi.kallinen(a)joensuu.fi QA Contact: testopia(a)bugs.koha-community.org The language tabs in Change notices -page are in random order, and will rearrange at every page reload. This is quite irritating. Make getTranslatedLanguages return the languages always in the same order, sorted by the language code. This is better than returning them in a random one. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 13

[Bug 20227] New: admin/smart-rules.pl should pass categorycode instead of branchcode
by bugzilla-daemon＠bugs.koha-community.org 22 Aug '18

22 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=20227 Bug ID: 20227 Summary: admin/smart-rules.pl should pass categorycode instead of branchcode Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Staff Client Assignee: koha-bugs(a)lists.koha-community.org Reporter: m.de.rooy(a)rijksmuseum.nl QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com Found while testing bug 15524. Trivial error. Field mixed up (copy-paste). DBD::mysql::st execute failed: Duplicate entry 'ST' for key 'PRIMARY' [for Statement " INSERT INTO default_borrower_circ_rules (categorycode, maxissueqty, maxonsiteissueqty, max_holds) VALUES (?, ?, ?, ?) " with ParamValues: 0="ST", 1=undef, 2=undef, 3="3"] at /usr/share/koha/devclone/admin/smart-rules.pl line 309. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 12

[Bug 16923] New: System Preference Missing from Manual -- IndependentBranchesPatronModifications
by bugzilla-daemon＠bugs.koha-community.org 17 Aug '18

17 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16923 Bug ID: 16923 Summary: System Preference Missing from Manual -- IndependentBranchesPatronModifications Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Documentation Assignee: nengard(a)gmail.com Reporter: misilot(a)fit.edu QA Contact: testopia(a)bugs.koha-community.org The system preference "IndependentBranchesPatronModifications" which was added in 3.22 is missing from the 3.22 manual and the 16.05 manual. -- You are receiving this mail because: You are watching all bug changes.

1 3

[Bug 18236] New: Add classes to material type icons on result lists and detail pages
by bugzilla-daemon＠bugs.koha-community.org 16 Aug '18

16 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=18236 Bug ID: 18236 Summary: Add classes to material type icons on result lists and detail pages Change sponsored?: --- Product: Koha Version: 3.22 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 Some libraries would prefer to show different material type icons in the result lists and detail pages in OPAC in staff. In order to make this possible with CSS, it would be nice if every icon had its own specific class so it's easy to target them. Something like: mt_icon_book, mt_icon_film, mt_icon_... -- You are receiving this mail because: You are watching all bug changes.

1 22

[Bug 19743] New: Header and Footer should be updated on each item for checkin / checkout / renewal notices
by bugzilla-daemon＠bugs.koha-community.org 16 Aug '18

16 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19743 Bug ID: 19743 Summary: Header and Footer should be updated on each item for checkin / checkout / renewal notices Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)bywatersolutions.com QA Contact: testopia(a)bugs.koha-community.org When generating the checkout notice for a patron we only update the section in between the '---' tags For template toolkit purposes it means we cannot affect the content based on more than a single item. For instance, we want to add the total cost of all items checked out. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 17

[Bug 16189] New: Add an exception to SMS via email documentation in the Koha manual
by bugzilla-daemon＠bugs.koha-community.org 14 Aug '18

14 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=16189 Bug ID: 16189 Summary: Add an exception to SMS via email documentation in the Koha manual Change sponsored?: --- Product: Koha Version: master Hardware: All URL: https://lists.katipo.co.nz/pipermail/koha/2016-April/0 45114.html OS: All Status: NEW Severity: minor Priority: P5 - low Component: Documentation Assignee: nengard(a)gmail.com Reporter: indradg(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Add an "exception note" that basically says "this may not work for all providers. Especially, users in India should aware of any liability - both civil and criminal, for sending unauthorised bulk SMS using this feature." -- You are receiving this mail because: You are watching all bug changes.

1 4

[Bug 19381] New: Replace the built-in help files with links to the online manual
by bugzilla-daemon＠bugs.koha-community.org 14 Aug '18

14 Aug '18

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=19381 Bug ID: 19381 Summary: Replace the built-in help files with links to the online manual Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Documentation Assignee: koha-bugs(a)lists.koha-community.org Reporter: magnus(a)libriotech.no QA Contact: testopia(a)bugs.koha-community.org We would probably be better off maintaining documentation in one place - the manual. Links to the manual could have "placeholders" for version and language (based on the language chosen by the user). The base URL of those links could also be configurable, so a somewhat paranoid library could link to their own local version of the manual, instead of being potentially tracked by a central server. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 5