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

[Pablo Bianchi]

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
>