Attachment 96570 Details for Bug 24206 – Bug 24206: Update content of OpacSearchForTitleIn for existing installations

[patch] Bug 24206: Update content of OpacSearchForTitleIn for existing installations

Bug-24206-Update-content-of-OpacSearchForTitleIn-f.patch (text/plain), 1.96 KB, created by Katrin Fischer on 2019-12-22 13:10:04 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2019-12-22 13:10:04 UTC

Size: 1.96 KB

patch

obsolete

>From 11397daec1446172c33af32a9dd13ed124f5cb1d Mon Sep 17 00:00:00 2001
>From: Katrin Fischer <katrin.fischer.83@web.de>
>Date: Sun, 22 Dec 2019 13:07:46 +0000
>Subject: [PATCH] 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
>---
> .../mysql/atomicupdate/bug_24206_update_searchfortitlein.perl    | 9 +++++++++
> 1 file changed, 9 insertions(+)
> create mode 100644 installer/data/mysql/atomicupdate/bug_24206_update_searchfortitlein.perl
>
>diff --git a/installer/data/mysql/atomicupdate/bug_24206_update_searchfortitlein.perl b/installer/data/mysql/atomicupdate/bug_24206_update_searchfortitlein.perl
>new file mode 100644
>index 0000000000..46c26c2d49
>--- /dev/null
>+++ b/installer/data/mysql/atomicupdate/bug_24206_update_searchfortitlein.perl
>@@ -0,0 +1,9 @@
>+$DBversion = 'XXX'; # will be replaced by the RM
>+if( CheckVersion( $DBversion ) ) {
>+    $dbh->do( 'UPDATE systempreferences SET value = REPLACE(value, "http://worldcat.org", "https://worldcat.org") WHERE variable = "OPACSearchForTitleIn"' );
>+    $dbh->do( 'UPDATE systempreferences SET value = REPLACE(value, "http://www.bookfinder.com", "https://www.bookfinder.com") WHERE variable = "OPACSearchForTitleIn"' );
>+    $dbh->do( 'UPDATE systempreferences SET value = REPLACE(value, "https://openlibrary.org/search/?", "https://openlibrary.org/search?") WHERE variable = "OPACSearchForTitleIn"' );
>+
>+    SetVersion( $DBversion );
>+    print "Upgrade to $DBversion done (Bug XXXXX - Update OpacSearchForTitleIn system preference)\n";
>+}
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 24206: 96569 | 96570 | 96673 | 96674 | 96675 | 96768 | 96769 | 97186 | 97187 | 97264 | 97265