Hi Philippe,
This sounds like the same error that is explained in the SQL13 coding guideline
-
https://wiki.koha-community.org/wiki/Coding_Guidelines#SQL13:_Modifying_columns_with_existing_foreign_key_constraints
This is the first I've heard of the error being seen on a MariaDB server rather
t
You could try "SET GLOBAL foreign_key_checks = 0".
You could also try adding `$dbh->{AutoCommit} = 0;` to see if that will
keep the foreign_key_checks setting set. That shouldn't really change
anything though.
I assume you are using the `koha-upgrade-schema` script to do this; that
should be the w
Yes, that update turns off the foreign key checks for the duration, but I'm
not sure that that would affect the column type, I think it only affects
column content checks. But I could be wrong.
This update does more than add the collate I think. It does check the
collate to see if the update has
Sunny day all!
First time I have this problem: I'm trying to upgrade a 17.05 to 24.11,
but it keeps failing on constraints
Upgrade to 17.12.00.015 done (Bug 20144 - Adapt DB structure to work
with new SQL modes)
{UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column
'type':
