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

[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

[Bug 12176] New: Remove HTML from additem.pl
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=12176 Bug ID: 12176 Summary: Remove HTML from additem.pl Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: bgkriegel(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org There is HTML code on additem.pl In particular an untranslatable "Tag Editor" -- You are receiving this mail because: You are watching all bug changes.

1 70

[Bug 7380] New: Can't filter patron search on detail page
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7380 Bug #: 7380 Summary: Can't filter patron search on detail page Classification: Unclassified Change sponsored?: --- Product: Koha Version: master Platform: All OS/Version: All Status: NEW Severity: minor Priority: P5 - low Component: Templates AssignedTo: oleonard(a)myacpl.org ReportedBy: nengard(a)gmail.com QAContact: ian.walls(a)bywatersolutions.com There is no [+] on patron search from patron detail page like there is on the main patron's page. It should be in all places. -- Configure bugmail: http://bugs.koha-community.org/bugzilla3/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are watching all bug changes.

1 48

[Bug 14529] New: Cannot delete a list even if the permission is set
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14529 Bug ID: 14529 Summary: Cannot delete a list even if the permission is set Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: ASSIGNED Severity: normal Priority: P5 - low Component: Lists 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: m.de.rooy(a)rijksmuseum.nl Bug 13417 allows a librarian to delete any lists if he has the permission (delete_public_lists). -- You are receiving this mail because: You are watching all bug changes.

1 25

[Bug 14308] New: Remove CGI::checkbox from subfield editors
by bugzilla-daemon＠bugs.koha-community.org 27 Aug '15

27 Aug '15

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=14308 Bug ID: 14308 Summary: Remove CGI::checkbox from subfield editors Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: minor Priority: P5 - low Component: Templates Assignee: oleonard(a)myacpl.org Reporter: bgkriegel(a)gmail.com QA Contact: testopia(a)bugs.koha-community.org Use of CGI::checkbox prevents customization of templates -- You are receiving this mail because: You are watching all bug changes.

1 4