Bug 24206: Update content of OpacSearchForTitleIn for existing installations
authorKatrin Fischer <katrin.fischer.83@web.de>
Sun, 22 Dec 2019 13:07:46 +0000 (13:07 +0000)
committerLucas Gass <lucas@bywatersolutions.com>
Wed, 12 Feb 2020 22:36:23 +0000 (22:36 +0000)
commit822f6094a31ad797ddb055742d6651aa39e26cb2
tree789df32ab616f724bc8db4e2a3824eb507e4f732
parente9ca854c0288782aa47c9ae4b3bc70b7e367bf9e
Bug 24206: Update content of OpacSearchForTitleIn for existing installations

This includes a database update for existing installations.
Using the REPLACE function it makes the same changes to the URLs
as the previous patch did for new installations:

- Worldcat: now https
- BookFinder: now https
- OpenLibrary: remove / before search parameters

To test:
- Verify the current content of your preference OpacSearchForTitleIn
  (without changes from first patch!)
- Run the database update
- Verify everything still works, but changes have been made

Signed-off-by: David Nind <david@davidnind.com>
Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
Signed-off-by: Joy Nelson <joy@bywatersolutions.com>
(cherry picked from commit 8efad71adbd7fa9afc8bd6c204a91d193e3e308c)

Signed-off-by: Lucas Gass <lucas@bywatersolutions.com>
installer/data/mysql/atomicupdate/bug_24206_update_searchfortitlein.perl [new file with mode: 0644]
installer/data/mysql/sysprefs.sql