Bug 33118

Summary: Bug 30472 provoke a DBI Exception when upgrading from 22.05.x to 22.11.02-1
Product: Koha Reporter: Pablo AB <pablo.bianchi>
Component: DatabaseAssignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: major    
Priority: P5 - low CC: jonathan.druart
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Pablo AB 2023-03-02 17:33:20 UTC
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,".
Comment 1 Jonathan Druart 2023-05-11 12:40:47 UTC

*** This bug has been marked as a duplicate of bug 33671 ***