Bug 32132 during upgrade from Koha 23.11 to 24.05
Dear All, Wishing you a good day. I am trying to upgrade from Koha 23.11 to 24.05 on Ubuntu. After the successful installation of Koha and the Web Installer screen, i get the following message; I believe during MySQL upgrade. Upgrade to 23.12.00.023 [12:32:00]: Bug 32132 - Set aqbudgets.budget_period_id as NOT NULL ERROR: {UNKNOWN}: DBI Exception: DBD::mysql: b do failed: Cannot change column 'budget_period_id': used in a foreign key constraint 'aqbudgetperiods_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 741 I can see in the release notes of 24.05 that this bug has been resolved. But does that mean I cannot upgrade from 23.11 to 24.05? Is there a work around I can apply? With best regards, Naveen Ali ITM-JE (EAKL) Inst Representative for HEC Digital Library Resources. NEDUET, Karachi.
Hi Naveen, This error has been resolved by bug 36993, which will be coming out in 24.05.01. If you are okay with waiting a few weeks to upgrade, one option is to wait until 24.05.01 is released at the end of the month and upgrade directly to that version. If waiting isn't a good option, there is also a workaround that was posted as a comment on the bug: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=36993#c1 Hope that helps! Emily Lamancusa (she/her) IT Specialist III Montgomery County Public Libraries (240) 777-0052 ________________________________ From: Ms. Naveen Ali <naveen@neduet.edu.pk> Sent: Thursday, June 6, 2024 11:38 PM To: koha-devel@lists.koha-community.org <koha-devel@lists.koha-community.org>; koha@lists.katipo.co.nz <koha@lists.katipo.co.nz> Subject: [Koha-devel] Bug 32132 during upgrade from Koha 23.11 to 24.05 Dear All, Wishing you a good day. I am trying to upgrade from Koha 23.11 to 24.05 on Ubuntu. After the successful installation of Koha and the Web Installer screen, i get the following message; I believe during MySQL upgrade. Upgrade to 23.12.00.023<callto:23.12.00.023> [12:32:00]: Bug 32132 - Set aqbudgets.budget_period_id as NOT NULL ERROR: {UNKNOWN}: DBI Exception: DBD::mysql:b do failed: Cannot change column 'budget_period_id': used in a foreign key constraint 'aqbudgetperiods_ibfk_1' at /usr/share/koha/lib/C4/Installer.pm line 741 I can see in the release notes of 24.05 that this bug has been resolved. But does that mean I cannot upgrade from 23.11 to 24.05? Is there a work around I can apply? With best regards, Naveen Ali ? ITM-JE (EAKL) Inst Representative for HEC Digital Library Resources. NEDUET, Karachi. [https://www.montgomerycountymd.gov/mcg/Resources/Images/Cybersecurity-footer...] For more helpful Cybersecurity Resources, visit: https://www.montgomerycountymd.gov/cybersecurity
participants (2)
-
Lamancusa, Emily -
Ms. Naveen Ali