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)
committerMartin Renvoize <martin.renvoize@ptfs-europe.com>
Fri, 10 Jan 2020 16:10:19 +0000 (16:10 +0000)
commit1599fb92e99f02bccfb8b02561495f4f4de028e7
tree1fa4d2375a5ca6d711495b2616abafa2cc83ad8d
parent5eceeb1bc823eb3602de698b2938d75cddd69a6d
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>
installer/data/mysql/atomicupdate/bug_24206_update_searchfortitlein.perl [new file with mode: 0644]
installer/data/mysql/sysprefs.sql