[Koha-bugs] [Bug 33671] New: Database update 22.06.00.048 breaks when there are borrower_relationships.guarantor_id with NULL

[bugzilla-daemon at bugs.koha-community.org]

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: koha-bugs at lists.koha-community.org
          Reporter: katrin.fischer at bsz-bw.de
        QA Contact: testopia at bugs.koha-community.org
                CC: gmcharlt at gmail.com
        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.