https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36978
--- Comment #4 from Rex Barkdoll <[email protected]> --- Ok, I've finally upgraded to 24.05.00.000 I took a screenshot of the Foreign Key constraint in PHPmyadmin's relation view and figured out how to remove it so that i could run the upgrade again. The upgrade continued until got stopped here: Upgrade to 23.12.00.044 [17:47:36]: Bug 36120 - Add pickup location to bookings Added column 'bookings.pickup_library_id' Set existing bookings pickup location to item homebranch ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'pickup_library_id': used in a foreign key constraint 'bookings_ibfk_4' at /usr/share/koha/lib/C4/Installer.pm line 741 I added back the first constraint to the aqbudgets.budget_period_id then repeated the process of screenshotting the bookings.pickup_library_id foreign key, removing it, running the update (which then got me all the way to version 24.05) and then finally re-added the constraint for bookings.pickup_library_id. Koha is back up and running now, so I should be all good. I would appreciate it if you could let me know whether adding back those foreign key constraints was the right thing to do or if I should remove them? Thank you for your assistance on this Katrin :) -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug. _______________________________________________ Koha-bugs mailing list [email protected] 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/
