[Koha] Upgrade assistance

[Steve Nickerson]

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.njoroge at gmail.com> 
Sent: Wednesday, October 05, 2022 2:16 AM
To: Steve Nickerson <stevenanickerson at gmail.com>
Cc: koha <koha at 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 <stevenanickerson at gmail.com <mailto:stevenanickerson at 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 list  http://koha-community.org
Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz> 
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha