Hi Steve, please have a look at this bug and the comments:
*Bug 31673* <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31673> - DB update of bug 31086 <https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31086> fails: Cannot change column 'branchcode': used in a foreign key constraint Hope this helps, Katrin On 05.10.22 14:10, Steve Nickerson wrote:
Thanks for the reference bug and the command. Unfortunately, when I execute the command suggested I receive: ERROR 1832 (HY000): Cannot change column 'branchcode': used in a foreign key constraint 'reserves_ibfk_4' Any other thoughts? Thanks again! Steve From: Evan Mungai Njoroge<evan.njor...@gmail.com> Sent: Wednesday, October 05, 2022 2:16 AM To: Steve Nickerson<stevenanicker...@gmail.com> Cc: koha<koha@lists.katipo.co.nz> Subject: Re: [Koha] Upgrade assistance I had the same issue upgrading from Koha 22.05.04.001 to 22.05.05.000. This came in handy -https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=31086 SOLUTION: Log in to MySQL/Maria, change database to the instance DB; Run; ALTER TABLE reserves MODIFY COLUMN `branchcode` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 0; Upgrade Schema. Your upgrade will complete. Regards ---- EM Njoroge On Wed, Oct 5, 2022 at 4:51 AM Steve Nickerson <stevenanicker...@gmail.com <mailto:stevenanicker...@gmail.com> > wrote: Good evening everyone, I'm trying to upgrade a Koha environment from 19.11.03.000 to the latest 22.05.04.000, including upgrading Debian OS from jessie to stretch. This was originally a package install on Debian Jessie. I did the upgrade successfully in a "test" environment and am now trying on my production system. After my first attempt I got the "welcome to Koha, please login using the default Koha user' screen, so I deleted that DB completely and restored from the backup I took right before the upgrade. Now when I try to execute 'koha-upgrade-schema <koha_site>' I get: Upgrade to 22.05.04.002 [21:40:11]: Bug 31086 - Do not allow null values in branchcodes for reserves ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Cannot change column 'branchcode': used in a foreign key constraint 'reserves_ibfk_4' at /usr/share/koha/lib/C4/Installer.pm line 739 Any ideas? Thanks! Steve _______________________________________________ Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha _______________________________________________ Koha mailing listhttp://koha-community.org Koha@lists.katipo.co.nz Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
