Bugzilla – Attachment 102898 Details for
Bug 22887
authorised_values is missing a unique constraint on category + authorised_value
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 22887: Remove dup fr-FR for existing installs
Bug-22887-Remove-dup-fr-FR-for-existing-installs.patch (text/plain), 1.10 KB, created by
Jonathan Druart
on 2020-04-14 08:13:10 UTC
(
hide
)
Description:
Bug 22887: Remove dup fr-FR for existing installs
Filename:
MIME Type:
Creator:
Jonathan Druart
Created:
2020-04-14 08:13:10 UTC
Size:
1.10 KB
patch
obsolete
>From dafff1cacdda74c994c86a8f5148d656ea00a0d9 Mon Sep 17 00:00:00 2001 >From: Jonathan Druart <jonathan.druart@bugs.koha-community.org> >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
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 22887
:
89550
|
101790
|
101791
|
101792
|
101793
|
101889
|
101890
|
101891
|
101892
|
102409
|
102410
|
102411
|
102412
|
102511
|
102876
|
102877
|
102878
|
102879
|
102880
| 102898 |
102939
|
102999
|
103000