Attachment 41827 Details for Bug 9468 – Bug 9468: followup insert ignore

[patch] Bug 9468: followup insert ignore

Bug-9468-followup-insert-ignore.patch (text/plain), 1.18 KB, created by Kyle M Hall (khall) on 2015-08-24 10:48:03 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Kyle M Hall (khall)

Created: 2015-08-24 10:48:03 UTC

Size: 1.18 KB

patch

obsolete

>From b3749876e9cdbb23227b7a9661644e7a21eafbc7 Mon Sep 17 00:00:00 2001
>From: Jonathan Druart <jonathan.druart@biblibre.com>
>Date: Mon, 20 Apr 2015 11:14:59 +0200
>Subject: [PATCH] Bug 9468: followup insert ignore
>
>---
> installer/data/mysql/updatedatabase.pl |    8 ++++----
> 1 files changed, 4 insertions(+), 4 deletions(-)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 33d58ed..0925265 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -10765,10 +10765,10 @@ if ( CheckVersion($DBversion) ) {
> $DBversion = "3.19.00.XXX";
> if ( CheckVersion($DBversion) ) {
>     foreach my $format (@{ GetSupportList() }) {
>-        $dbh->do(
>-            q/INSERT INTO authorised_values (category, authorised_value, lib, lib_opac, imageurl)
>-            VALUES (?, ?, ?, ?, ?)/,
>-            {},
>+        $dbh->do(q|
>+            INSERT IGNORE INTO authorised_values (category, authorised_value, lib, lib_opac, imageurl)
>+            VALUES (?, ?, ?, ?, ?)
>+        |, {},
>             'SUGGEST_FORMAT', $format->{itemtype}, $format->{description}, $format->{description}, $format->{imageurl}
>         );
>     }
>-- 
>1.7.2.5

Actions: View | Diff | Splinter Review

Attachments on bug 9468: 14801 | 16647 | 16674 | 19086 | 21759 | 21760 | 22714 | 22715 | 27932 | 27933 | 27934 | 27935 | 37100 | 37101 | 37102 | 37103 | 38097 | 38163 | 38164 | 38165 | 38166 | 38167 | 38168 | 41822 | 41823 | 41824 | 41825 | 41826 | 41827 | 41828 | 41936 | 41937 | 41938 | 41939 | 41940 | 41941 | 41942 | 41943 | 44504 | 44505 | 44506 | 44507 | 44508 | 44509 | 44510