Bug 38432 - FIX a foreign key constraint for koha
Summary: FIX a foreign key constraint for koha
Status: CLOSED INVALID
Alias: None
Product: Koha
Classification: Unclassified
Component: bugs.koha-community.org (show other bugs)
Version: 24.05
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-11-13 08:08 UTC by MR Loi
Modified: 2025-06-02 20:46 UTC (History)
0 users

See Also:
GIT URL:
Initiative type: ---
Sponsorship status: ---
Comma delimited list of Sponsors:
Crowdfunding goal: 0
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description MR Loi 2024-11-13 08:08:24 UTC
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
Comment 1 Katrin Fischer 2024-11-13 08:13:57 UTC
Bugzilla should only be used for bugs and enhancement requests. As you are updating from a very old version, even if it was a bug, it's unlikely to be fixed now. Please try the support channels like the mailing list or chat (https://chat.koha-community.org) for support requests instead.