From 01b764c436005d5959288adefd04b5f6f0f17ce1 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Mon, 20 Apr 2015 11:14:59 +0200 Subject: [PATCH] Bug 9468: followup insert ignore Signed-off-by: Jonathan Druart Signed-off-by: Tomas Cohen Arazi --- 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