From bcc57cf8b8e10568f3faa832cb527ad5cbfae4a5 Mon Sep 17 00:00:00 2001 From: Matt Blenkinsop Date: Tue, 19 Sep 2023 09:24:04 +0000 Subject: [PATCH] Bug 34789: (follow-up) Fix atomic update file Atomic update file had a versioning issue - now changed to be compatible with older versions Please backport --- installer/data/mysql/atomicupdate/bug_34789-rename-column.pl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_34789-rename-column.pl b/installer/data/mysql/atomicupdate/bug_34789-rename-column.pl index f305f27ffa..4f96713e7f 100755 --- a/installer/data/mysql/atomicupdate/bug_34789-rename-column.pl +++ b/installer/data/mysql/atomicupdate/bug_34789-rename-column.pl @@ -10,7 +10,7 @@ return { if ( column_exists( 'erm_eholdings_titles', 'preceeding_publication_title_id' ) ) { $dbh->do( q{ - ALTER TABLE erm_eholdings_titles RENAME COLUMN preceeding_publication_title_id TO preceding_publication_title_id + ALTER TABLE erm_eholdings_titles CHANGE COLUMN preceeding_publication_title_id preceding_publication_title_id varchar(255) DEFAULT NULL } ); say $out 'Column renamed to preceding_publication_title_id'; -- 2.37.1 (Apple Git-137.1)