[Koha] Upgrade assistance

[Steve Nickerson]

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