Good day!
The pickup_library_id is set to null, maybe accidentally or they forgot that it is a foreign key. We just set it to none then rerun the update again. and its done. Thank you! On Tue, Jul 2, 2024, 4:49 AM Katrin Fischer <katrin.fischer...@web.de> wrote: > Hi Zen, > > this is a known bug that will hopefully be fixed soon in the stable > releases: > > *Bug 37000* > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=37000> - > Upgrade fails at 23.12.00.044 [Bug 36120 > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36120>] > > You might find some helpful notes on how to get around this one in the > comments or attached patch files on the bug report. > > Hope this helps, > > Katrin > > On 28.06.24 10:19, zen zenitram wrote: > > He is the error > > > > Upgrade to 23.12.00.044 [08:06:11]: 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 > > > > Anyone encountered this error? > > > > Thanks! > > _______________________________________________ > > > > Koha mailing listhttp://koha-community.org > > Koha@lists.katipo.co.nz > > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ > > Koha mailing list http://koha-community.org > Koha@lists.katipo.co.nz > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha > _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
