[Koha] Error while upgrading koha version 23.11 to version 24.05

[zen zenitram]

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 at 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 at lists.katipo.co.nz
> > Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>