Attachment 36623 Details for Bug 5338 – [PASSED QA] Bug 5338: Use insert ignore to avoid a warning if 'SER' already exists

[patch] [PASSED QA] Bug 5338: Use insert ignore to avoid a warning if 'SER' already exists

PASSED-QA-Bug-5338-Use-insert-ignore-to-avoid-a-wa.patch (text/plain), 1.20 KB, created by Katrin Fischer on 2015-03-05 16:27:03 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Katrin Fischer

Created: 2015-03-05 16:27:03 UTC

Size: 1.20 KB

patch

obsolete

>From f1c12b57e4344fe437fdb6d84d44b9ff2b261959 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@biblibre.com>
>Date: Wed, 4 Mar 2015 12:26:34 +0100
>Subject: [PATCH] [PASSED QA] Bug 5338: Use insert ignore to avoid a warning if
> 'SER' already exists
>
>Signed-off-by: Katrin Fischer <katrin.fischer.83@web.de>
>---
> installer/data/mysql/updatedatabase.pl | 4 ++--
> 1 file changed, 2 insertions(+), 2 deletions(-)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 18b4411..54f0c09 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -9796,11 +9796,11 @@ if(CheckVersion($DBversion)) {
> $DBversion = "3.19.00.XXX";
> if ( CheckVersion($DBversion) ) {
>     $dbh->do(q|
>-        INSERT INTO authorised_values (category, authorised_value, lib) VALUES
>+        INSERT IGNORE INTO authorised_values (category, authorised_value, lib) VALUES
>         ('REPORT_GROUP', 'SER', 'Serials')
>     |);
> 
>-    print "Upgrade to $DBversion done (Bug 5338 - Add Serial to the report groups)\n";
>+    print "Upgrade to $DBversion done (Bug 5338 - Add Serial to the report groups if does not exist)\n";
>     SetVersion ($DBversion);
> }
> 
>-- 
>1.9.1

Actions: View | Diff | Splinter Review

Attachments on bug 5338: 11601 | 22908 | 23299 | 29271 | 35148 | 35149 | 35179 | 35180 | 35300 | 35301 | 36457 | 36458 | 36459 | 36621 | 36622 | 36623 | 36624 | 39302