Attachment 90356 Details for Bug 10215 – Bug 10215: (follow-up) Correct existing data

[patch] Bug 10215: (follow-up) Correct existing data

Bug-10215-follow-up-Correct-existing-data.patch (text/plain), 1.35 KB, created by Nick Clemens (kidclamp) on 2019-06-06 12:10:38 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Nick Clemens (kidclamp)

Created: 2019-06-06 12:10:38 UTC

Size: 1.35 KB

patch

obsolete

>From 9a122933e4e26ecefa034fc2b329dc03a2794918 Mon Sep 17 00:00:00 2001
>From: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>Date: Wed, 5 Jun 2019 12:54:30 +0100
>Subject: [PATCH] Bug 10215: (follow-up) Correct existing data
>
>This patch adds the correction of data ('' => NULL) during the DB
>update.
>
>Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com>
>
>Signed-off-by: Nick Clemens <nick@bywatersolutions.com>
>---
> installer/data/mysql/atomicupdate/bug_10215.perl | 3 +++
> 1 file changed, 3 insertions(+)
>
>diff --git a/installer/data/mysql/atomicupdate/bug_10215.perl b/installer/data/mysql/atomicupdate/bug_10215.perl
>index a960435a24..1358cdfb67 100644
>--- a/installer/data/mysql/atomicupdate/bug_10215.perl
>+++ b/installer/data/mysql/atomicupdate/bug_10215.perl
>@@ -4,6 +4,9 @@ if ( CheckVersion($DBversion) ) {
>     $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE opacnote opacnote LONGTEXT NULL});
>     $dbh->do(q{ALTER TABLE subscriptionhistory CHANGE librariannote librariannote LONGTEXT NULL});
> 
>+    $dbh->do(q{UPDATE subscriptionhistory SET opacnote = NULL WHERE opacnote = ''});
>+    $dbh->do(q{UPDATE subscriptionhistory SET librariannote = NULL WHERE librariannote = ''});
>+
>     SetVersion ($DBversion);
>     print "Upgrade to $DBversion done (Bug 10215 - Increase the size of opacnote and librariannote for table subscriptionhistory)\n";
> }
>-- 
>2.11.0

Actions: View | Diff | Splinter Review

Attachments on bug 10215: 17998 | 17999 | 19247 | 19335 | 85395 | 85400 | 87705 | 90323 | 90324 | 90325 | 90355 | 90356 | 90357