https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17216 --- Comment #96 from Jacek Ablewicz <abl@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.