Bugzilla – Attachment 39457 Details for
Bug 9351
item type not recorded correctly in statistics for returns and some local use
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 9351 - sql update on existing statistics
Bug-9351---sql-update-on-existing-statistics.patch (text/plain), 1.54 KB, created by
Katrin Fischer
on 2015-05-24 12:43:36 UTC
(
hide
)
Description:
Bug 9351 - sql update on existing statistics
Filename:
MIME Type:
Creator:
Katrin Fischer
Created:
2015-05-24 12:43:36 UTC
Size:
1.54 KB
patch
obsolete
>From 415806a14321f54c8cc5e7e1554933730418b74e Mon Sep 17 00:00:00 2001 >From: Fridolin Somers <fridolin.somers@biblibre.com> >Date: Mon, 29 Dec 2014 17:35:26 +0100 >Subject: [PATCH] Bug 9351 - sql update on existing statistics > >Signed-off-by: Kyle M Hall <kyle@bywatersolutions.com> >Signed-off-by: Nick <nick@quecheelibrary.org> >--- > installer/data/mysql/updatedatabase.pl | 23 +++++++++++++++++++++++ > 1 file changed, 23 insertions(+) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 1dd8c0b..05f1421 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -10462,6 +10462,29 @@ if ( CheckVersion($DBversion) ) { > SetVersion ($DBversion); > } > >+ >+$DBversion = "3.21.00.XXX"; >+if ( CheckVersion($DBversion) ) { >+ $dbh->do(q{ >+ UPDATE statistics >+ SET itemtype = >+ ( >+ SELECT u.itype FROM >+ ( >+ SELECT itype,itemnumber FROM items >+ UNION ALL >+ SELECT itype,itemnumber FROM deleteditems >+ ) u >+ WHERE statistics.itemnumber = u.itemnumber >+ LIMIT 1 >+ ) >+ WHERE type IN ('localuse', 'return') >+ }); >+ print "upgrade to $DBversion done (Bug 9351 - item type not recorded correctly in statistics for returns and some local use)\n"; >+ SetVersion ($DBversion); >+} >+ >+ > # DEVELOPER PROCESS, search for anything to execute in the db_update directory > # SEE bug 13068 > # if there is anything in the atomicupdate, read and execute it. >-- >1.9.1
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 9351
:
18545
|
18626
|
18627
|
18699
|
23692
|
34818
|
34819
|
34994
|
34995
|
35578
|
35712
|
35713
|
35714
|
39456
| 39457 |
39458