[Koha-bugs] [Bug 33118] New: Bug 30472 provoke a DBI Exception when upgrading from 22.05.x to 22.11.02-1

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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=33118

            Bug ID: 33118
           Summary: Bug 30472 provoke a DBI Exception when upgrading from
                    22.05.x to 22.11.02-1
 Change sponsored?: ---
           Product: Koha
           Version: master
          Hardware: All
                OS: All
            Status: NEW
          Severity: major
          Priority: P5 - low
         Component: Database
          Assignee: koha-bugs at lists.koha-community.org
          Reporter: pablo.bianchi at gmail.com
        QA Contact: testopia at bugs.koha-community.org

Rising the comment 8 from bug 30472 to a new bug:

Upgrading to 22.11.02-1 from an updated 22.05 on a Debian 11 crash with this
error:

   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 is the same issue as on bug 32399?.

One of the people who sent me a PM suggest a workaround: changing the DEFAULT
to NOT on "`guarantor_id` int DEFAULT NULL,".

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.