From 857b5315a5c57e3a46a38cf9aeca4cc08ebec2de 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 --- installer/data/mysql/updatedatabase.pl | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index a30ceea..3054d0e 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -11314,10 +11314,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} ); } -- 1.7.2.5