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

[Katrin Fischer]

Hi Pablo,

the database update query here should be:

https://git.koha-community.org/Koha-community/Koha/src/branch/22.05.x/installer/data/mysql/db_revs/220506001.pl

Do you have entries in your issues table, where the borrowernumber is NULL?

Hope that helps,

Katrin


On 03.12.22 00:10, Pablo Bianchi wrote:
> 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
>