https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33671
Bug ID: 33671
Summary: Database update 22.06.00.048 breaks when there are
borrower_relationships.guarantor_id with NULL
Change sponsored?: ---
Product: Koha
Version: master
Hardware: All
OS: All
Status: NEW
Severity: normal
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: 30472
We've had 2 reports of this database update breaking the update on bug 30472.
The database update altered the table without checking/dealing with existing
NULL values:
PabloAB:
Upgrading to 22.11.02-1 from an updated 22.05 on a Debian 11:
Upgrade to 22.06.00.048 [18:33:27]: Bug 30472 -
borrower_relationships.guarantor_id NOT NULL
ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change
column 'guarantor_id': used in a foreign key constraint 'r_guarantor' at
/usr/share/koha/lib/C4/Installer.pm line 739
Maybe the same issue as on bug 32399?
------
Mona Panchaud:
Hello.
While upgrading from 22.05 to 22.11 we are running into the following problem
that is related to this change:
"Upgrade to 22.06.00.048 [20:19:53]: Bug 30472 -
borrower_relationships.guarantor_id NOT NULL
ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column
'guarantor_id': used in a foreign key constraint 'r_guarantor' at
/usr/share/koha/lib/C4/Installer.pm line 743"
Is there any workaround?
What can we do to get the upgrade working?
Referenced Bugs:
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30472
[Bug 30472] Field borrower_relationships.guarantor_id should be marked as NOT
NULL
--
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/
