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

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

Bug-16371-follow-up-DB-changes.patch (text/plain), 1.32 KB, created by Jonathan Druart on 2020-08-13 08:29:00 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Jonathan Druart

Created: 2020-08-13 08:29:00 UTC

Size: 1.32 KB

patch

obsolete

>From 60cb6f2a85ed8bbbb6c887088f40c77209b42971 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
>---
> 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.20.1

Actions: View | Diff | Splinter Review

Attachments on bug 16371: 102515 | 102516 | 102517 | 102969 | 103019 | 103329 | 103330 | 103331 | 103332 | 103333 | 103334 | 103732 | 103973 | 103974 | 103975 | 103976 | 103977 | 103978 | 103979 | 106818 | 106819 | 106820 | 106858 | 106859 | 106860 | 106861 | 106862 | 106863 | 106864 | 106865 | 106866 | 106867 | 106868 | 106894 | 106895 | 106896 | 106897 | 106898 | 106899 | 106900 | 106901 | 106902 | 106903 | 108097 | 108098 | 108160 | 108163