| 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 | ||
| GIT URL: | Initiative type: | --- | |
| Sponsorship status: | --- | Comma delimited list of Sponsors: | |
| Crowdfunding goal: | 0 | 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