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