From 788363e4160d9d7fb7c13dd5c9822b4740573e68 Mon Sep 17 00:00:00 2001 From: Marcel de Rooy Date: Tue, 14 Mar 2023 12:30:32 +0000 Subject: [PATCH] Bug 32057: (follow-up) Add INSERT IGNORE in dbrev 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 Signed-off-by: Tomas Cohen Arazi --- 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.39.5