From 01b764c436005d5959288adefd04b5f6f0f17ce1 Mon Sep 17 00:00:00 2001
From: Jonathan Druart <jonathan.druart@biblibre.com>
Date: Mon, 20 Apr 2015 11:14:59 +0200
Subject: [PATCH] Bug 9468: followup insert ignore

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Tomas Cohen Arazi <tomascohen@theke.io>
---
 installer/data/mysql/updatedatabase.pl | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
index fb3df4083f..2446527432 100755
--- a/installer/data/mysql/updatedatabase.pl
+++ b/installer/data/mysql/updatedatabase.pl
@@ -11324,10 +11324,10 @@ if ( CheckVersion($DBversion) ) {
 $DBversion = "3.19.00.XXX";
 if ( CheckVersion($DBversion) ) {
     foreach my $format (@{ GetSupportList() }) {
-        $dbh->do(
-            q/INSERT INTO authorised_values (category, authorised_value, lib, lib_opac, imageurl)
-            VALUES (?, ?, ?, ?, ?)/,
-            {},
+        $dbh->do(q|
+            INSERT IGNORE INTO authorised_values (category, authorised_value, lib, lib_opac, imageurl)
+            VALUES (?, ?, ?, ?, ?)
+        |, {},
             'SUGGEST_FORMAT', $format->{itemtype}, $format->{description}, $format->{description}, $format->{imageurl}
         );
     }
-- 
2.39.5