From dafff1cacdda74c994c86a8f5148d656ea00a0d9 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 14 Apr 2020 10:12:57 +0200 Subject: [PATCH] Bug 22887: Remove dup fr-FR for existing installs --- installer/data/mysql/atomicupdate/bug_22887.perl | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/installer/data/mysql/atomicupdate/bug_22887.perl b/installer/data/mysql/atomicupdate/bug_22887.perl index e4bc712eb2..f3dca7d4ca 100644 --- a/installer/data/mysql/atomicupdate/bug_22887.perl +++ b/installer/data/mysql/atomicupdate/bug_22887.perl @@ -1,6 +1,10 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { unless ( index_exists('authorised_values', 'av_uniq') ) { + $dbh->do(q| + DELETE FROM authorised_values + WHERE category="COUNTRY" AND authorised_value="CC" AND lib="Keeling" + |); my $duplicates = $dbh->selectall_arrayref(q| SELECT category, authorised_value, COUNT(concat(category, ':', authorised_value)) AS c FROM authorised_values -- 2.20.1