From ec3afdcd1076596df66dce801061599a71917985 Mon Sep 17 00:00:00 2001 From: Lucas Gass Date: Fri, 30 Jul 2021 17:31:08 +0000 Subject: [PATCH] Bug 13188: (follow-up) Get value from PatronSelfRegistrationBorrowerMandatoryField when updating database Signed-off-by: Martin Renvoize --- ...3188_add_PatronSelfModificationMandatoryField_syspref.perl | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_13188_add_PatronSelfModificationMandatoryField_syspref.perl b/installer/data/mysql/atomicupdate/bug_13188_add_PatronSelfModificationMandatoryField_syspref.perl index 9462d3b3ea0..0e9e76b3583 100644 --- a/installer/data/mysql/atomicupdate/bug_13188_add_PatronSelfModificationMandatoryField_syspref.perl +++ b/installer/data/mysql/atomicupdate/bug_13188_add_PatronSelfModificationMandatoryField_syspref.perl @@ -1,7 +1,9 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { $dbh->do(q{ - INSERT IGNORE INTO systempreferences (`variable`, `value`, `options`, `explanation`, `type`) VALUES ('PatronSelfModificationMandatoryField','', NULL,'Define the required fields when a patron is editing their information via the OPAC.','multiple'); + INSERT IGNORE INTO systempreferences ( `variable`, `value`, `options`, `explanation`, `type` ) + SELECT 'PatronSelfModificationMandatoryField', value, NULL, 'Define the required fields when a patron is editing their information via the OPAC','multiple' + FROM (SELECT value FROM systempreferences WHERE variable="PatronSelfRegistrationBorrowerMandatoryField") tmp }); NewVersion($DBversion, 13188, "Allow configuration of required fields when a patron is editing their information via the OPAC"); } -- 2.20.1