https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34276
ivan <ipine...@isep-cba.edu.ar> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ipine...@isep-cba.edu.ar --- Comment #17 from ivan <ipine...@isep-cba.edu.ar> --- (In reply to Jeremiah from comment #11) > Hi, > > I am having the same problem as SOS. > > Upgrade to 23.05.00.002 [11:09:02]: Bug 21983 - Deleted biblio handling on > ILL > ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate key > name 'illrequests_bibfk' at /usr/share/koha/lib/C4/Installer.pm line 741 > > I am coming from 22.05 I believe. > > I tried their suggestion: > "ALTER TABLE illrequests DROP KEY illrequests_bibfk;" > > I got: Cannot drop index 'illrequests_bibfk': needed in a foreign key > constraint Hi, I tried this suggestion and i got the same: Cannot drop index 'illrequests_bibfk': needed in a foreign key constraint message... So i searched and droped the foreign key constraint first: "ALTER TABLE illrequests DROP FOREIGN KEY fk_illrequests_books;" ( I got some help from ChatGPT :) ) And then droped the index as proposed: "ALTER TABLE illrequests DROP KEY illrequests_bibfk;" And then it worked! but now i have the question of the consequences of dropping the foreign key constraint. Will it impact on some transaction? I guess this is a provisional fix. I appreciate any help you can provide on this matter. Thanks! -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org 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/