From 1a4e302bc61b59dc7f1d7baa0a74b694863713a3 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 --- 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 a352e5d..a2ea7a5 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -10039,10 +10039,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.1.0