https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33671
--- Comment #33 from Marcel de Rooy <[email protected]> --- (In reply to Jeremiah from comment #32) > Hello, > > I updated the koha files on 7/19/2023. > I am encountering the same error: > > Upgrade to 22.06.00.048 [22:23:00]: Bug 30472 - > borrower_relationships.guarantor_id NOT NULL > ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change > column 'guarantor_id': used in a foreign key constraint 'r_guarantor' at > /usr/share/koha/lib/C4/Installer.pm line 741 > > Based on the bug comments, it looks like this is something in the works. > Any solutions I can try in the meantime? > > Any help is appreciated. I guess you missed the latest change on this dbrev. You could apply the last follow-up to your install or pick the SQL statements from the last patch and run them under mysql client. Especially: SET FOREIGN_KEY_CHECKS=0; ALTER TABLE borrower_relationships CHANGE COLUMN guarantor_id guarantor_id int(11) NOT NULL SET FOREIGN_KEY_CHECKS=1 -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
