From ee225fd477fd28dd4d47de525563b60566ba0403 Mon Sep 17 00:00:00 2001
From: Charlotte Cordwell <charlotte.cordwell123@gmail.com>
Date: Tue, 16 Jan 2018 20:14:20 +0000
Subject: [PATCH] Bug 17682: (follow-up) Change URL for Google Scholar in
 OPACSearchForTitleIn

Amended the sql statement so it only affects the http://www.scholar.google.com url

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>

Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>

Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
(cherry picked from commit 5bf7600456aa66c1984ba7e8f2d781f468f23b6e)
Signed-off-by: Fridolin Somers <fridolin.somers@biblibre.com>
---
 .../mysql/atomicupdate/bug17682_urlchangeforgooglescholar.sql   | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/installer/data/mysql/atomicupdate/bug17682_urlchangeforgooglescholar.sql b/installer/data/mysql/atomicupdate/bug17682_urlchangeforgooglescholar.sql
index bf4575fc4d..18e9603ebe 100644
--- a/installer/data/mysql/atomicupdate/bug17682_urlchangeforgooglescholar.sql
+++ b/installer/data/mysql/atomicupdate/bug17682_urlchangeforgooglescholar.sql
@@ -1 +1 @@
-UPDATE systempreferences set value =  replace(value, "http://www.", "https://") where variable = 'OPACSearchForTitleIn';
+UPDATE systempreferences set value =  replace(value, "http://www.scholar", "https://scholar") where variable = 'OPACSearchForTitleIn';
-- 
2.39.5