https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34276 ivan <ipineiro@isep-cba.edu.ar> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |ipineiro@isep-cba.edu.ar --- Comment #17 from ivan <ipineiro@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.