| 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: | --- | 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