Bugzilla – Attachment 11660 Details for
Bug 8253
fix fine doubling, when upgrading from 3.6 to 3.8 (or later)
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 8253 - Fine doubling - Followup
Bug-8253---Fine-doubling---Followup.patch (text/plain), 1.71 KB, created by
Kyle M Hall (khall)
on 2012-08-17 12:48:53 UTC
(
hide
)
Description:
Bug 8253 - Fine doubling - Followup
Filename:
MIME Type:
Creator:
Kyle M Hall (khall)
Created:
2012-08-17 12:48:53 UTC
Size:
1.71 KB
patch
obsolete
>From ff0778b529011714e18e598f97eef7e19100a172 Mon Sep 17 00:00:00 2001 >From: Kyle M Hall <kyle@bywatersolutions.com> >Date: Fri, 17 Aug 2012 08:48:39 -0400 >Subject: [PATCH] Bug 8253 - Fine doubling - Followup > >Use timestamp as the 'un-matcher' rather than the fine description. >--- > installer/data/mysql/updatedatabase.pl | 6 +++--- > 1 files changed, 3 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index ad93d65..c5bcc48 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -5692,13 +5692,13 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { > SELECT * FROM accountlines > WHERE ( accounttype = 'FU' OR accounttype = 'F' ) > AND description like '%23:59%' >- ORDER BY borrowernumber, itemnumber, accountno, description >+ ORDER BY borrowernumber, itemnumber, accountno, description, timestamp DESC > "; > my $sth = $dbh->prepare( $query ); > $sth->execute(); > my $results = $sth->fetchall_arrayref({}); > >- $query = "SELECT * FROM accountlines WHERE description LIKE ? AND description NOT LIKE ?"; >+ $query = "SELECT * FROM accountlines a WHERE a.description LIKE ? AND a.timestamp != ?"; > $sth = $dbh->prepare( $query ); > > my @fines; >@@ -5708,7 +5708,7 @@ if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { > $description_to_match .= '%'; > #warn "DESCRIPTION TO MATCH: " . $description_to_match; > >- $sth->execute( $description_to_match, $keeper->{'description'} ); >+ $sth->execute( $description_to_match, $keeper->{'timestamp'} ); > > my $has_changed = 0; > >-- >1.7.2.5
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 8253
:
10369
|
10405
|
10416
|
10429
|
10436
|
11087
|
11127
|
11660
|
12653
|
12665
|
12666
|
12667
|
12685
|
12686