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 |
*** This bug has been marked as a duplicate of bug 35552 *** 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 |
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