[Koha-bugs] [Bug 17216] Add a new table to store authorized value categories

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17216

--- Comment #96 from Jacek Ablewicz <abl at 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.