Attachment 108641 Details for Bug 16112 – Bug 16371: (follow-up) DB changes

[patch] Bug 16371: (follow-up) DB changes

Bug-16371-follow-up-DB-changes.patch (text/plain), 1.45 KB, created by Marco Abi-Ramia on 2020-08-19 15:01:44 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Marco Abi-Ramia

Created: 2020-08-19 15:01:44 UTC

Size: 1.45 KB

patch

obsolete

>From 303bd581e7433a87e0e6ecd7182c9b69b40e24ac Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>Date: Thu, 13 Aug 2020 10:28:24 +0200
>Subject: [PATCH] Bug 16371: (follow-up) DB changes
>
>We need to keep "opac" is the pref was set before the upgrade
>
>Signed-off-by: Jonathan Druart <jonathan.druart@bugs.koha-community.org>
>
>https://bugs.koha-community.org/show_bug.cgi?id=16112
>---
> installer/data/mysql/updatedatabase.pl | 6 ++++--
> 1 file changed, 4 insertions(+), 2 deletions(-)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index d2bd7cb93f..6c335c29b8 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -22576,15 +22576,17 @@ if( CheckVersion( $DBversion ) ) {
> $DBversion = '20.06.00.023';
> if( CheckVersion( $DBversion ) ) {
> 
>+    my $QuoteOfTheDay = C4::Context->preference('QuoteOfTheDay');
>     $dbh->do( q|
>         UPDATE systempreferences
>-        SET value = '',
>-            options = 'intranet,opac',
>+        SET options = 'intranet,opac',
>             explanation = 'Enable or disable display of Quote of the Day on the OPAC and staff interface home page',
>             type = 'multiple'
>         WHERE variable = 'QuoteOfTheDay'
>     | );
> 
>+    C4::Context->set_preference('QuoteOfTheDay', $QuoteOfTheDay ? 'opac' : '');
>+
>     NewVersion( $DBversion, 16371, "Quote of the Day (QOTD) for the staff interface " );
> }
> 
>-- 
>2.17.1

Actions: View | Diff | Splinter Review

Attachments on bug 16112: 107786 | 107835 | 107865 | 107890 | 107891 | 108639 | 108640 | 108641 | 108658 | 108659 | 108661 | 108662 | 108663 | 108665 | 108776 | 108871 | 108872 | 108873