Bug 33118 - Bug 30472 provoke a DBI Exception when upgrading from 22.05.x to 22.11.02-1
Summary: Bug 30472 provoke a DBI Exception when upgrading from 22.05.x to 22.11.02-1
Status: RESOLVED DUPLICATE of bug 33671
Alias: None
Product: Koha
Classification: Unclassified
Component: Database (show other bugs)
Version: Main
Hardware: All All
: P5 - low major (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-03-02 17:33 UTC by Pablo AB
Modified: 2023-05-11 12:40 UTC (History)
1 user (show)

See Also:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 ***