Attachment 49986 Details for Bug 14598 – Bug 14598 [QA Followup] - Update localuse statistics also

[patch] Bug 14598 [QA Followup] - Update localuse statistics also

Bug-14598-QA-Followup---Update-localuse-statistics.patch (text/plain), 1002 bytes, created by Tomás Cohen Arazi (tcohen) on 2016-04-06 14:47:31 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Tomás Cohen Arazi (tcohen)

Created: 2016-04-06 14:47:31 UTC

Size: 1002 bytes

patch

obsolete

>From 8380d2f51e6bbdc298379ee2a1187b14134058c8 Mon Sep 17 00:00:00 2001
>From: Kyle M Hall <kyle@bywatersolutions.com>
>Date: Tue, 19 Jan 2016 14:34:20 +0000
>Subject: [PATCH] Bug 14598 [QA Followup] - Update localuse statistics also
>
>Signed-off-by: Tomas Cohen Arazi <tomascohen@gmail.com>
>---
> installer/data/mysql/updatedatabase.pl | 2 +-
> 1 file changed, 1 insertion(+), 1 deletion(-)
>
>diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl
>index 2e90e28..56f02b5 100755
>--- a/installer/data/mysql/updatedatabase.pl
>+++ b/installer/data/mysql/updatedatabase.pl
>@@ -12213,7 +12213,7 @@ if ( CheckVersion($DBversion) ) {
>      SELECT s.itemnumber, i.itype, b.itemtype FROM
>       ( SELECT DISTINCT itemnumber
>         FROM statistics
>-        WHERE type="return" AND itemtype IS NULL ) s
>+        WHERE ( type = "return" OR type = "localuse" ) AND itemtype IS NULL ) s
>       LEFT JOIN
>       ( SELECT itemnumber,biblionumber, itype
>         FROM items ) i
>-- 
>2.7.4

Actions: View | Diff | Splinter Review

Attachments on bug 14598: 41198 | 41199 | 41200 | 41201 | 41202 | 41203 | 41204 | 41205 | 41383 | 41384 | 41385 | 41627 | 41628 | 41629 | 41637 | 42171 | 42177 | 44665 | 44666 | 44667 | 44668 | 45030 | 45047 | 45838 | 45843 | 45844 | 46546 | 46877 | 47108 | 47109 | 47110 | 47111 | 47112 | 47113 | 47114 | 47115 | 47116 | 49797 | 49798 | 49799 | 49800 | 49801 | 49802 | 49803 | 49804 | 49805 | 49807 | 49963 | 49964 | 49965 | 49966 | 49967 | 49968 | 49969 | 49970 | 49971 | 49972 | 49978 | 49979 | 49980 | 49981 | 49982 | 49983 | 49984 | 49985 | 49986 | 49987 | 49988 | 50018 | 56941 | 56942 | 56943 | 56944 | 56945 | 56946 | 56947 | 56948 | 56949 | 56950 | 56951 | 56952 | 56953 | 62539 | 62555 | 62682