[Koha] Upgrade assistance

Evan Mungai Njoroge evan.njoroge at gmail.com
Wed Oct 5 19:15:36 NZDT 2022

I had the same issue upgrading from Koha to
This came in handy -

Log in to MySQL/Maria, change database to the instance DB;

*ALTER TABLE reserves MODIFY COLUMN `branchcode` varchar(10) COLLATE
utf8mb4_unicode_ci NOT NULL DEFAULT 0;*

Upgrade Schema.

Your upgrade will complete.


*EM Njoroge*

On Wed, Oct 5, 2022 at 4:51 AM Steve Nickerson <stevenanickerson at gmail.com>

> Good evening everyone,
>    I'm trying to upgrade a Koha environment from to the latest
>, 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  [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
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

More information about the Koha mailing list