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: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
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.
_______________________________________________
Koha-bugs mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
