[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

beardst at rlasd.net changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |beardst at rlasd.net

--- Comment #19 from beardst at rlasd.net ---
I upgraded from 22.05 and came across this issue as well. Actually had 3 issues
in the DB that I had to work through independently. For this one here is what
worked, had to track down the FK that was blocking the drop of the
illrequests_bibfk key

ALTER TABLE illrequests DROP FOREIGN KEY illrequests_ibfk_1;
ALTER TABLE illrequests DROP KEY illrequests_bibfk;

After that I was able to retry the webinstall and it went through. Ran this
command to see if the FK constraint was recreated. This is also the command I
used to find the FK in the first place

SELECT RefCons.constraint_schema, RefCons.table_name,
RefCons.referenced_table_name, RefCons.constraint_name, KeyCol.column_name
FROM information_schema.referential_constraints RefCons
JOIN information_schema.key_column_usage KeyCol ON RefCons.constraint_schema =
KeyCol.table_schema
     AND RefCons.table_name = KeyCol.table_name
     AND RefCons.constraint_name = KeyCol.constraint_name
WHERE RefCons.constraint_schema = 'DATABASE_NAME';

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.