Bug 35522

Summary: Error in Upgrading: ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'itemnumber': used in a foreign key constraint 'tmp_holdsqueue_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 741
Product: Koha Reporter: Harsha <hbala>
Component: Installation and upgrade (web-based installer)Assignee: Bugs List <koha-bugs>
Status: RESOLVED DUPLICATE QA Contact: Testopia <testopia>
Severity: critical    
Priority: P5 - low CC: gmcharlt, vctrzuniga
Version: Main   
Hardware: All   
OS: Linux   
Change sponsored?: --- Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:
Attachments: Koha upgrading issues: Cannot change column 'itemnumber': used in a foreign key constraint 'tmp_holdsqueue_ibfk_1

Description Harsha 2023-12-10 09:18:24 UTC
Created attachment 159694 [details]
Koha upgrading issues: Cannot change column 'itemnumber': used in a foreign key constraint 'tmp_holdsqueue_ibfk_1

Cannot upgrade the Koha , Following error message appears in  both command line updating and web base upgrading process

ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'itemnumber': used in a foreign key constraint 'tmp_holdsqueue_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 741
Comment 1 Victor Zuniga 2023-12-26 19:51:06 UTC

*** This bug has been marked as a duplicate of bug 35552 ***
Comment 2 Victor Zuniga 2023-12-26 19:54:07 UTC
Hi Harsha,

Please take a look at ticket #35552:

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

Igor pointed me in the right direction. After replacing the content of the file:

/usr/share/koha/intranet/cgi-bin/installer/data/mysql/db_revs/230600013.pl

with the code Igor shared on the ticket, I was able to complete the upgrade process.

Best,

Victor