@@ -, +, @@ --- installer/data/mysql/updatedatabase.pl | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) --- a/installer/data/mysql/updatedatabase.pl +++ a/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} ); } --