http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=13577
Kyle M Hall <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #35182|0 |1 is obsolete| | --- Comment #3 from Kyle M Hall <[email protected]> --- Created attachment 35333 --> http://bugs.koha-community.org/bugzilla3/attachment.cgi?id=35333&action=edit [PASSED QA] Bug 13577: Add the utf8_unicode_ci COLLATE to all tables 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. Test plan: 0/ Reproduce the error: mysql> create database koha_test CHARACTER SET utf8 COLLATE utf8_unicode_ci; mysql koha_test < installer/data/mysql/kohastructure.sql It will boom with: ERROR 1005 (HY000) at line 3493: Can't create table `koha_test`.`items_search_fields` (errno: 150 "Foreign key constraint is incorrectly formed") 1/ Apply the patch, destroy the DB and recreate it: mysql> create database koha_test CHARACTER SET utf8 COLLATE utf8_unicode_ci; mysql> drop database koha_test; mysql koha_test < installer/data/mysql/kohastructure.sql All tables should be inserted without any error. Signed-off-by: Paola Rossi <[email protected]> Signed-off-by: Kyle M Hall <[email protected]> -- 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/
