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