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
