https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=32399
Bug ID: 32399
Summary: Database update for bug 30483 is failing
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: major
Priority: P5 - low
Component: Installation and upgrade (web-based installer)
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
CC: [email protected]
Depends on: 30483
We have had 2 reports recently of this database update failing:
22.06.00.041 [09:45:46]: Bug 30483 - Make issues.borrowernumber and
issues.itemnumber NOT NULLERROR - {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
And:
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
Both refer to the same bug/SQL statements, but backported to different
versions.
Referenced Bugs:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30483
[Bug 30483] Do not allow NULL in issues.borrowernumber and issues.itemnumber
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
