[Bug 35522] New: 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
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35522 Bug ID: 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 Change sponsored?: --- Product: Koha Version: master Hardware: All OS: Linux Status: NEW Severity: critical Priority: P5 - low Component: Installation and upgrade (web-based installer) Assignee: koha-bugs@lists.koha-community.org Reporter: hbala@ou.ac.lk QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com Created attachment 159694 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=159694&action=edit 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 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35522 Victor Zuniga <vctrzuniga@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |vctrzuniga@gmail.com Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #1 from Victor Zuniga <vctrzuniga@gmail.com> --- *** This bug has been marked as a duplicate of bug 35552 *** -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=35522 --- Comment #2 from Victor Zuniga <vctrzuniga@gmail.com> --- 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 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon@bugs.koha-community.org