From 587a838b338364b330b803274e3b24f2c2107946 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Tue, 13 Apr 2021 10:45:58 +0200 Subject: [PATCH] Bug 14233: Set default for NoticesLog to 0 To prevent a warning on the about page: System preference 'NoticesLog' must be '0' or '1', but is ''. --- installer/data/mysql/mandatory/sysprefs.sql | 2 +- installer/data/mysql/updatedatabase.pl | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/installer/data/mysql/mandatory/sysprefs.sql b/installer/data/mysql/mandatory/sysprefs.sql index b06c51e9cde..e0f803a98c7 100644 --- a/installer/data/mysql/mandatory/sysprefs.sql +++ b/installer/data/mysql/mandatory/sysprefs.sql @@ -356,7 +356,7 @@ INSERT INTO systempreferences ( `variable`, `value`, `options`, `explanation`, ` ('NotHighlightedWords','and|or|not',NULL,'List of words to NOT highlight when OpacHitHighlight is enabled','free'), ('NoticeBcc','','','Email address to bcc outgoing notices sent by email','free'), ('NoticeCSS','',NULL,'Notices CSS url.','free'), -('NoticesLog','',NULL,'If enabled, log changes to notice templates','YesNo'), +('NoticesLog','0',NULL,'If enabled, log changes to notice templates','YesNo'), ('NotifyBorrowerDeparture','30',NULL,'Define number of days before expiry where circulation is warned about patron account expiry','Integer'), ('NovelistSelectEnabled','0',NULL,'Enable Novelist Select content. Requires Novelist Profile and Password','YesNo'), ('NovelistSelectPassword','',NULL,'Novelist select user Password','free'), diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 0c9498132e5..582056114a8 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -23784,7 +23784,7 @@ if ( CheckVersion($DBversion) ) { $dbh->do(q{ INSERT IGNORE INTO systempreferences (variable, value, explanation, options, type) - VALUES ('NoticesLog','',NULL,'If enabled, log changes to notice templates','YesNo') + VALUES ('NoticesLog','0',NULL,'If enabled, log changes to notice templates','YesNo') }); NewVersion( $DBversion, 14233, "Add id field to letter table" ); -- 2.20.1