From 5240cfe437e1c7b96b48a8424e82b1ab764eb015 Mon Sep 17 00:00:00 2001
From: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Date: Tue, 14 Mar 2023 12:30:32 +0000
Subject: [PATCH] Bug 32057: (follow-up) Add INSERT IGNORE in dbrev
Content-Type: text/plain; charset=utf-8

Preventing:
ERROR - {UNKNOWN}: DBI Exception: DBD::mysql::db do failed: Duplicate entry 'ActionLogsTraceDepth' for key 'PRIMARY' at /usr/share/koha/C4/Installer.pm line 739

Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
---
 installer/data/mysql/db_revs/221200013.pl | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/installer/data/mysql/db_revs/221200013.pl b/installer/data/mysql/db_revs/221200013.pl
index a0cc9a73a9..c4c642f7b2 100755
--- a/installer/data/mysql/db_revs/221200013.pl
+++ b/installer/data/mysql/db_revs/221200013.pl
@@ -16,7 +16,7 @@ return {
         }
 
         $dbh->do(q{
-            INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
+            INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) VALUES
             ('ActionLogsTraceDepth', '0', '', 'Sets the maximum depth of the action logs stack trace', 'Integer')
         });
         say $out "Added new system preference 'ActionLogsTraceDepth'";
-- 
2.30.2