[Koha] Another DBI Exception for foreign key constraint in upgrade to Koha

[Tomas Cohen Arazi]

That's a data issue. Maybe an old bug let things in wrongly on the db, it
incomplete data migration.

You should do something with those checkouts with no linked patron, and the
upgrade script will continue where it left.

Best regards

El vie, 2 dic 2022 20:12, Pablo Bianchi <pablo.bianchi at gmail.com> escribió:

> Hi Katrin,
>
> Both bugs are resolved, but I'm having this issue while upgrading today
> from 20.05 to 22.05 on a Debian 9.13:
>
> Upgrade to 22.05.06.001 [19:37:23]: Bug 30483 - Make issues.borrowernumber
> and itemnumber NOT NULL
> ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change
> column 'borrowernumber': used in a foreign key constraint 'issues_ibfk_1'
> at /usr/share/koha/lib/C4/Installer.pm line 739
>
> Not sure if I'm hitting another similar bug. SELECT * FROM issues WHERE
> borrowernumber IS NULL OR itemnumber IS NULL; doesn't return any row. It
> has only one row with ids on those columns. *reserves* table has no rows.
> Maybe Bug 32240 should be backported?
>
> Regards,
> Pablo
>
>
>
> On Mon, 10 Oct 2022 at 18:01, Katrin Fischer <katrin.fischer.83 at web.de>
> wrote:
>
> > Hi David,
> >
> > please have a look at this bug and the comments there:
> >
> > *Bug 31673*
> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31673> - DB
> > update of bug 31086
> > <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31086> fails:
> > Cannot change column 'branchcode': used in a foreign key constraint
> >
> > Hope this helps,
> >
> > Katrin
> >
> _______________________________________________
>
> Koha mailing list  http://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>