[Koha-bugs] [Bug 34276] upgrading 23.05 to 23.05.002

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=34276

ivan <ipineiro at isep-cba.edu.ar> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |ipineiro at isep-cba.edu.ar

--- Comment #17 from ivan <ipineiro at 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.