June 2015 - Koha-bugs - lists.koha-community.org

[Bug 13579] New: History file should be open using utf-8 encoding
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13579 Bug ID: 13579 Summary: History file should be open using utf-8 encoding Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: About Assignee: nengard(a)gmail.com Reporter: jonathan.druart(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 15

[Bug 12637] New: UTF-8 problems when creating a patron list from the patron search results page
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12637 Bug ID: 12637 Summary: UTF-8 problems when creating a patron list from the patron search results page Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs(a)lists.koha-community.org Reporter: oleonard(a)myacpl.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Steps to reproduce: 1. Perform a patron search in the patrons module 2. Select one or more patrons 3. Choose "Add selected patrons to: [ New list ]" 4. Enter a patron list title with UTF-8 characters, ex: "Pàtron list five " 5. The list will be created with bad encoding: "P%C3%A0tron%20list%20five%20" -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.

1 23

[Bug 13934] New: Check in fails on master "Can't bless non-reference at .../ItemType.pm Line 64"
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13934 Bug ID: 13934 Summary: Check in fails on master "Can't bless non-reference at .../ItemType.pm Line 64" Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: critical Priority: P5 - low Component: Circulation Assignee: koha-bugs(a)lists.koha-community.org Reporter: nick(a)quecheelibrary.org QA Contact: testopia(a)bugs.koha-community.org CC: gmcharlt(a)gmail.com, kyle.m.hall(a)gmail.com Check in some barcodes on master and you get the perl error above tcohen says git bisect points to 7431f8cfe29e330e2232b0df591afc4d923b0a52 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.

1 23

[Bug 14431] New: Encoding issues - search in staff
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14431 Bug ID: 14431 Summary: Encoding issues - search in staff Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: major Priority: P5 - low Component: Searching Assignee: jonathan.druart(a)biblibre.com Reporter: jonathan.druart(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org It certainly depends on the Encode version. To reproduce: 1) /cgi-bin/koha/catalogue/search.pl?q=ééé&op=Submit " No results match your search for 'kw,wrdl: ��' in my library Catalog. " 2) /cgi-bin/koha/catalogue/search.pl?q=ກ Cannot decode string with wide characters at /usr/lib/i386-linux-gnu/perl/5.20/Encode.pm line 215. My encode version is 2.60 (`pmvers Encode`). -- You are receiving this mail because: You are watching all bug changes.

1 18

[Bug 13810] New: Prevent updatedatabase.pl from breaking because of case insensitive utf8 collation
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13810 Bug ID: 13810 Summary: Prevent updatedatabase.pl from breaking because of case insensitive utf8 collation 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: nicolas.legrand(a)bulac.fr QA Contact: testopia(a)bugs.koha-community.org When upgrading database from 3.18 to master upgrade Upgrade to 3.19.00.006 (Bug 11944 - Convert DB tables to utf8_unicode_ci) may fail like this: DBD::mysql::db do failed: Duplicate entry 'ACQ-995-a' for key 'PRIMARY' at ./installer/data/mysql/updatedatabase.pl line 9671. This is from table marc_subfield_structure where the keys are made of framework (ACQ), tagfield (995) and tagsubfield (a). If we have a key ACQ-995-A it thinks the entries are duplicates, because the collation is case insensitive. It's rather annoying, since it's legit in mark to have a subfield 'a' different from subfield 'A' inside the same subfield. I propose to default collation on one which is not case insensitive, like utf8_bin. -- You are receiving this mail because: You are watching all bug changes.

1 26

[Bug 13815] New: plack loose CGI qw(-utf8) flag creating incorrect utf-8 encoding everywhere
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13815 Bug ID: 13815 Summary: plack loose CGI qw(-utf8) flag creating incorrect utf-8 encoding everywhere 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: dpavlin(a)rot13.org QA Contact: testopia(a)bugs.koha-community.org -- You are receiving this mail because: You are watching all bug changes.

1 20

[Bug 13646] New: Facets encoding problem with GRS1
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13646 Bug ID: 13646 Summary: Facets encoding problem with GRS1 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Searching Assignee: jonathan.druart(a)biblibre.com Reporter: jonathan.druart(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Since bug 11944, the facets are not correctly encoded if the indexing mode is GRS1. -- You are receiving this mail because: You are watching all bug changes.

1 14

[Bug 13596] New: Prevent updatedatabase.pl from reverting utf8_mb4 databases to utf8
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13596 Bug ID: 13596 Summary: Prevent updatedatabase.pl from reverting utf8_mb4 databases to utf8 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: abl(a)biblos.pk.edu.pl, benjamin.rokseth(a)kul.oslo.kommune.no, bgkriegel(a)gmail.com, boutrosboutrosboutros(a)gmail.com, dpavlin(a)rot13.org, hbraum(a)nekls.org, jonathan.druart(a)biblibre.com, josef.moravec(a)gmail.com, katrin.fischer(a)bsz-bw.de, m.de.rooy(a)rijksmuseum.nl, magnus(a)enger.priv.no, martin.renvoize(a)ptfs-europe.com, paola.rossi(a)cineca.it, tomascohen(a)gmail.com, z.tajoli(a)cineca.it Depends on: 11248, 11906, 11944, 13264 Blocks: 7380, 10855, 11844, 12176, 12637, 12832, 13239, 13345, 13577, 13579 Bug #11944 fixed utf8 encoding koha wide, however as part of it, it updates all database table to utf8 charset and utf8_unicode_ci collation. This is a good thing for anyone who left the default coallition to being with, but is a step backwards for those working on Wheezy and Ubuntu who may have chosen the utf8_mb4 pragma. The update should first check for such cases, and skip if found. -- You are receiving this mail because: You are watching all bug changes.

1 16

[Bug 13577] New: The correct COLLATE set to all DB tables
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13577 Bug ID: 13577 Summary: The correct COLLATE set to all DB tables Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: blocker Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: jonathan.druart(a)biblibre.com QA Contact: testopia(a)bugs.koha-community.org Bug 11944 added the COLLATE=utf8_unicode_ci to all DB tables. But some new tables have been created between the write of the patch set and the push to master. So these new tables don't have the correct collate. The error is: ERROR 1005 (HY000) at line 3493: Can't create table 'koha.items_search_fields' (errno: 150) -- You are receiving this mail because: You are watching all bug changes.

1 22

[Bug 13239] New: MySQL Character encoding utf8
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13239 Bug ID: 13239 Summary: MySQL Character encoding utf8 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: major Priority: P5 - low Component: Architecture, internals, and plumbing Assignee: gmcharlt(a)gmail.com Reporter: martin.renvoize(a)ptfs-europe.com QA Contact: testopia(a)bugs.koha-community.org CC: abl(a)biblos.pk.edu.pl, benjamin.rokseth(a)kul.oslo.kommune.no, bgkriegel(a)gmail.com, boutrosboutrosboutros(a)gmail.com, dpavlin(a)rot13.org, hbraum(a)nekls.org, jonathan.druart(a)biblibre.com, josef.moravec(a)gmail.com, katrin.fischer(a)bsz-bw.de, m.de.rooy(a)rijksmuseum.nl, magnus(a)enger.priv.no, martin.renvoize(a)ptfs-europe.com, paola.rossi(a)cineca.it, tomascohen(a)gmail.com, z.tajoli(a)cineca.it Depends on: 11248, 11906, 11944 Blocks: 7380, 10855, 11844, 12176, 12637, 12832 As discussed in bug 11944 we should use utf8_mb4 as default mysql encoding where the mysql version allows for it. This would allow for the entire utf8 character range rather than an arbitrarily truncated set as chosen by mysql during their first attempt at utf8 compatibility. As promised, I've opened this followup bug to track this issue. -- You are receiving this mail because: You are watching all bug changes.

1 8