https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33671 --- Comment #33 from Marcel de Rooy <m.de.rooy@rijksmuseum.nl> --- (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.