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