https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17216
--- Comment #96 from Jacek Ablewicz <a...@biblos.pk.edu.pl> --- (In reply to Mirko Tietgen from comment #93) > With a Debian package for 16.11, on upgrade from 16.05 the following happens: > > Upgrade to 16.06.00.032 done (Bug 17357 - WTHDRAWN is still used in > installer files) > DBD::mysql::db do failed: Can't create table 'koha_upgrade.#sql-329_a5' > (errno: 150) [for Statement " > ALTER TABLE marc_subfield_structure > MODIFY COLUMN authorised_value VARCHAR(32) DEFAULT NULL, > ADD CONSTRAINT marc_subfield_structure_ibfk_1 FOREIGN KEY > (authorised_value) REFERENCES authorised_value_categories (category_name) ON > UPDATE CASCADE ON DELETE SET NULL; > "] at > /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line > 13175. > Upgrade to 16.06.00.033 done (Bug 17216 - Add a new table to store > authorized value categories) > > I assume it is related to this bug? Is it safe to ignore? It does sound more > scary than the duplicate warnings we get from time to time. Got the same error in my test setup. For undetermined reason, authorised_value field in marc_subfield_structure table did not have utf8_unicode_ci collation. I replaced MODIFY COLUMN authorised_value VARCHAR(32) DEFAULT NULL, with MODIFY COLUMN authorised_value VARCHAR(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL, and after that it seems to work fine. No idea why this DB update is tagged with "Bug 17357 - WTHDRAWN is still used in installer files)" and not with a "Bug 17216 ..." instead. BTW, there are some other text fields in my test DB with inconsistent collation too, but this is a database with a long history of accumulated DB updates (including various unstable / atomic ones). -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/