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.bianchi@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.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
_______________________________________________
Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha