Attachment 171010 Details for Bug 37820 – Bug 37820: Upgrade fails at 23.12.00.023 [Bug 36993]

[patch] Bug 37820: Upgrade fails at 23.12.00.023 [Bug 36993]

0001-Bug-37820-Upgrade-fails-at-23.12.00.023-Bug-36993.patch (text/plain), 2.39 KB, created by Emmi Takkinen on 2024-09-04 05:48:57 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Emmi Takkinen

Created: 2024-09-04 05:48:57 UTC

Size: 2.39 KB

patch

obsolete

>From 143492f3521047d7e62d5b747f850bcd746398e0 Mon Sep 17 00:00:00 2001
>From: Emmi Takkinen <emmi.takkinen@koha-suomi.fi>
>Date: Wed, 4 Sep 2024 08:47:20 +0300
>Subject: [PATCH] Bug 37820: Upgrade fails at 23.12.00.023 [Bug 36993]
>
>If table aqbudgets is miissing foreign key
>'aqbudgetperiods_ibfk_1' database update fails on
>"Can't DROP FOREIGN KEY" error.
>
>To test:
>1. Remove changes made in bug 32132, drop foreign key
>aqbudgetperiods_ibfk_1 and downgrade your database:
>- ALTER TABLE aqbudgets MODIFY COLUMN `budget_period_id` INT(11) NULL;
>- UPDATE aqbudgets SET budget_period_id = NULL
>WHERE budget_period_id IN(SELECT budget_period_id FROM aqbudgetperiods
>WHERE budget_period_description = "Budget for funds without budget");
>- DELETE FROM aqbudgetperiods
>WHERE budget_period_description = "Budget for funds without budget";
>- ALTER TABLE aqbudgets DROP FOREIGN KEY aqbudgetperiods_ibfk_1;
>- UPDATE systempreferences SET value="23.1200022" WHERE variable = "Version;
>2. Upgrade your database (e.g. running installer/data/mysql/updatedatabase.pl)
>=> Update fails on error "Can't DROP FOREIGN KEY `aqbudgetperiods_ibfk_1`;...".
>4. Apply this patch.
>5. Try to update your database again.
>=> Database should now be upgraded succesfully.
>=> Confirm table aqbudgets now contains 'aqbudgetperiods_ibfk_1'.
>---
> installer/data/mysql/db_revs/231200023.pl | 6 ++++--
> 1 file changed, 4 insertions(+), 2 deletions(-)
>
>diff --git a/installer/data/mysql/db_revs/231200023.pl b/installer/data/mysql/db_revs/231200023.pl
>index cf413d31cb..2d25669e70 100755
>--- a/installer/data/mysql/db_revs/231200023.pl
>+++ b/installer/data/mysql/db_revs/231200023.pl
>@@ -30,8 +30,10 @@ return {
>                 "There were $count budget(s) without budget_period_id. They all have been updated to be under budget called 'Budget for funds without budget' (id $aqbp_id).";
>         }
> 
>-        $dbh->do(q{ALTER TABLE aqbudgets DROP FOREIGN KEY aqbudgetperiods_ibfk_1});
>-        say $out "Dropped foreign key aqbudgetperiods_ibfk_1";
>+        if ( foreign_key_exists( 'aqbudgets', 'aqbudgetperiods_ibfk_1' ) ) {
>+            $dbh->do(q{ALTER TABLE aqbudgets DROP FOREIGN KEY aqbudgetperiods_ibfk_1});
>+            say $out "Dropped foreign key aqbudgetperiods_ibfk_1";
>+        }
> 
>         $dbh->do(q{ALTER TABLE aqbudgets MODIFY COLUMN `budget_period_id` INT(11) NOT NULL});
>         say $out "Updated aqbudgets.budget_period_id to NOT accept NULL values";
>-- 
>2.34.1
>

Actions: View | Diff | Splinter Review

Attachments on bug 37820: 171010 | 171051 | 171127