[Koha] Upgrade assistance

[Katrin Fischer]

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.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 listhttp://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
>
> _______________________________________________
>
> Koha mailing listhttp://koha-community.org
> Koha at lists.katipo.co.nz
> Unsubscribe:https://lists.katipo.co.nz/mailman/listinfo/koha