Bugzilla – Attachment 96739 Details for
Bug 24329
Patron cardnumber change times are lost during upgrade for bug 3820
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24329: Correction to updatedatabase
Bug-24329-Correction-to-updatedatabase.patch (text/plain), 1.74 KB, created by
Martin Renvoize (ashimema)
on 2020-01-02 13:03:53 UTC
(
hide
)
Description:
Bug 24329: Correction to updatedatabase
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2020-01-02 13:03:53 UTC
Size:
1.74 KB
patch
obsolete
>From b9d204350aa83bc0363f9688f0440fbaeb3a5326 Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Thu, 2 Jan 2020 12:56:19 +0000 >Subject: [PATCH] Bug 24329: Correction to updatedatabase > >Ensure timestamp is not overwriteen during upgrade when applying updates >for bug 3820 >--- > installer/data/mysql/updatedatabase.pl | 6 +++--- > 1 file changed, 3 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index e7687c9939..39536b964c 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -17366,9 +17366,9 @@ if( CheckVersion( $DBversion ) ) { > > $DBversion = '18.12.00.015'; > if( CheckVersion( $DBversion ) ) { >- $dbh->do( "UPDATE action_logs SET info = REPLACE(info,'cardnumber_replaced','cardnumber') WHERE module='MEMBERS' AND action='MODIFY'" ); >- $dbh->do( "UPDATE action_logs SET info = REPLACE(info,'previous_cardnumber','before') WHERE module='MEMBERS' AND action='MODIFY'" ); >- $dbh->do( "UPDATE action_logs SET info = REPLACE(info,'new_cardnumber','after') WHERE module='MEMBERS' AND action='MODIFY'" ); >+ $dbh->do( "UPDATE action_logs SET info = REPLACE(info,'cardnumber_replaced','cardnumber'), timestamp = timestamp WHERE module='MEMBERS' AND action='MODIFY'" ); >+ $dbh->do( "UPDATE action_logs SET info = REPLACE(info,'previous_cardnumber','before'), timestamp = timestamp WHERE module='MEMBERS' AND action='MODIFY'" ); >+ $dbh->do( "UPDATE action_logs SET info = REPLACE(info,'new_cardnumber','after'), timestamp = timestamp WHERE module='MEMBERS' AND action='MODIFY'" ); > > SetVersion( $DBversion ); > print "Upgrade to $DBversion done (Bug 3820 - Update patron modification logs)\n"; >-- >2.20.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 24329
:
96739
|
96740
|
96775
|
96776
|
96831
|
96832
|
96833