From d83fa50d08957400a5aba88ee33bb0138767edc0 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Wed, 20 Sep 2017 23:28:49 +0200 Subject: [PATCH] Bug 16401: (follow-up) Avoid changing empty staffClientBaseURL preference Adds a condition to check that the staffClientBaseUrl is not empty before updating it with 'http://'. --- installer/data/mysql/atomicupdate/bug_16401.perl | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installer/data/mysql/atomicupdate/bug_16401.perl b/installer/data/mysql/atomicupdate/bug_16401.perl index 946953c46c..3f3492e1ee 100644 --- a/installer/data/mysql/atomicupdate/bug_16401.perl +++ b/installer/data/mysql/atomicupdate/bug_16401.perl @@ -1,6 +1,6 @@ $DBversion = 'XXX'; # will be replaced by the RM if( CheckVersion( $DBversion ) ) { - $dbh->do( "UPDATE systempreferences SET value = CONCAT('http://', value) WHERE variable = 'staffClientBaseURL' AND value NOT LIKE 'http%'" ); + $dbh->do( "UPDATE systempreferences SET value = CONCAT('http://', value) WHERE variable = 'staffClientBaseURL' AND value <> '' AND value NOT LIKE 'http%'" ); # Always end with this (adjust the bug info) SetVersion( $DBversion ); -- 2.11.0