https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=38432 Bug ID: 38432 Summary: FIX a foreign key constraint for koha Change sponsored?: --- Product: Koha Version: 24.05 Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: bugs.koha-community.org Assignee: koha-bugs@lists.koha-community.org Reporter: loi.tathuan@hoasen.edu.vn QA Contact: testopia@bugs.koha-community.org Plese help me Fix . update 17.x to 24.x Thanks you {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'type': used in a foreign key constraint 'koha_kohalibrary/account_offsets_ibfk_t' of table 'koha_kohalibrary/account_offsets' at /usr/share/perl5/DBIx/Class/Schema.pm line 1118. DBIx::Class::Schema::throw_exception(Koha::Schema=HASH(0x5b8a48683b70), "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(0x5b8a4dcb62d8), "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(0x5b8a4e2ffb00), undef) called at /usr/share/koha/intranet/cgi-bin/installer/data/mysql/updatedatabase.pl line 15544 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.