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.83@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