Bug 35522 - 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
Summary: Error in Upgrading: ERROR: {UNKNOWN}: DBI Exception: DBD::mysql::db do failed...
Status: RESOLVED DUPLICATE of bug 35552
Alias: None
Product: Koha
Classification: Unclassified
Component: Installation and upgrade (web-based installer) (show other bugs)
Version: Main
Hardware: All Linux
: P5 - low critical (vote)
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2023-12-10 09:18 UTC by Harsha
Modified: 2023-12-26 19:54 UTC (History)
2 users (show)

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


Attachments
Koha upgrading issues: Cannot change column 'itemnumber': used in a foreign key constraint 'tmp_holdsqueue_ibfk_1 (43.28 KB, image/jpeg)
2023-12-10 09:18 UTC, Harsha
Details

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