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': used in a foreign key constraint
'koha_henryville/account_offsets_ibfk_t' of table
'koha_henryville/account_offsets' at
/usr/share/perl5/DBIx/Class/Schema.pm line 1118.
DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x5e4975bc04e8),
"DBI Exception: DBD::mysql::db do failed: Cannot change column"...)
called at /usr/share/perl5/DBIx/Class/Storage.pm line 113
DBIx::Class::Storage::throw_exception(DBIx::Class::Storage::DBI::mysql=HASH(0x5e497aefac50),
"DBI Exception: DBD::mysql::db do failed: Cannot change column"...)
called at /usr/share/perl5/DBIx/Class/Storage/DBI.pm line 1623
DBIx::Class::Storage::DBI::__ANON__("DBD::mysql::db do failed: Cannot
change column 'type': used i"..., DBI::db=HASH(0x5e497b75b710), undef)
called at ./installer/data/mysql/updatedatabase.pl line 15545
This was an install on Debian 12 / Mariadb 10.11 with the koha-common
packages, so I figured maybe some new constraints in Mariadb were in
cause. I moved the DB to a Ubuntu 22, Mariadb 10.6 with dev install but
I have the same problem.
I've never encountered it in my upgrades up to 24.05, and there's no way
to skip it since it's a loop through ALL the tables to add the COLLATE,
etc...
And the code starts with skipping the constraints, so I don't get it.
Any suggestion?
Best regards
--
Logo inLibro <https://inLibro.com> Philippe Blouin
Directeur de la technologie
T 833-INLIBRO (465-4276) <tel:833-465-4276>, poste 230
C philippe.blo...@inlibro.com
www.inLibro.com <https://inLibro.com>
_______________________________________________
Koha-devel mailing list
Koha-devel@lists.koha-community.org
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
website : https://www.koha-community.org/
git : https://git.koha-community.org/
bugs : https://bugs.koha-community.org/
