From 952c03d6f9d8be29decb4585f3810017f64917ca Mon Sep 17 00:00:00 2001 From: Nick Clemens Date: Thu, 12 Apr 2018 13:51:17 +0000 Subject: [PATCH] Bug 19882: (follow-up) Add 'IGNORE' in DB update Signed-off-by: Jonathan Druart --- .../bug_19882_Add_novelist_staff_client_profile.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_19882_Add_novelist_staff_client_profile.perl b/installer/data/mysql/atomicupdate/bug_19882_Add_novelist_staff_client_profile.perl index 4109085daf..4595cf587e 100644 --- a/installer/data/mysql/atomicupdate/bug_19882_Add_novelist_staff_client_profile.perl +++ b/installer/data/mysql/atomicupdate/bug_19882_Add_novelist_staff_client_profile.perl @@ -1,6 +1,6 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { - $dbh->do("INSERT INTO systempreferences (variable,value,explanation,options,type) VALUES ('NovelistSelectStaffProfile',NULL,'Novelist staff client user Profile',NULL,'free')"); + $dbh->do("INSERT IGNORE INTO systempreferences (variable,value,explanation,options,type) VALUES ('NovelistSelectStaffProfile',NULL,'Novelist staff client user Profile',NULL,'free')"); SetVersion( $DBversion ); print "Upgrade to $DBversion done (Bug 19882 - Add Novelist Staff Client Profile)\n"; -- 2.20.1