Bugzilla – Attachment 85273 Details for
Bug 3820
More detailed patron record changes log
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 3820: (QA follow-up) Change REGEXP_REPLACE to REPLACE for wider compatibility
Bug-3820-QA-follow-up-Change-REGEXPREPLACE-to-REPL.patch (text/plain), 1.78 KB, created by
Martin Renvoize (ashimema)
on 2019-02-19 12:40:48 UTC
(
hide
)
Description:
Bug 3820: (QA follow-up) Change REGEXP_REPLACE to REPLACE for wider compatibility
Filename:
MIME Type:
Creator:
Martin Renvoize (ashimema)
Created:
2019-02-19 12:40:48 UTC
Size:
1.78 KB
patch
obsolete
>From de5d5bd2b5f527a382555285f3f21b8e5a4853e8 Mon Sep 17 00:00:00 2001 >From: Josef Moravec <josef.moravec@gmail.com> >Date: Sun, 17 Feb 2019 21:31:14 +0000 >Subject: [PATCH] Bug 3820: (QA follow-up) Change REGEXP_REPLACE to REPLACE for > wider compatibility > >Signed-off-by: Josef Moravec <josef.moravec@gmail.com> >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > installer/data/mysql/atomicupdate/bug_3820.perl | 6 +++--- > 1 file changed, 3 insertions(+), 3 deletions(-) > >diff --git a/installer/data/mysql/atomicupdate/bug_3820.perl b/installer/data/mysql/atomicupdate/bug_3820.perl >index 7ce68db948..bfc4b51374 100644 >--- a/installer/data/mysql/atomicupdate/bug_3820.perl >+++ b/installer/data/mysql/atomicupdate/bug_3820.perl >@@ -1,8 +1,8 @@ > $DBversion = 'XXX'; # will be replaced by the RM > if( CheckVersion( $DBversion ) ) { >- $dbh->do( "UPDATE action_logs SET info = REGEXP_REPLACE(info,'cardnumber_replaced','cardnumber') WHERE module='MEMBERS' AND action='MODIFY'" ); >- $dbh->do( "UPDATE action_logs SET info = REGEXP_REPLACE(info,'previous_cardnumber','before') WHERE module='MEMBERS' AND action='MODIFY'" ); >- $dbh->do( "UPDATE action_logs SET info = REGEXP_REPLACE(info,'new_cardnumber','after') WHERE module='MEMBERS' AND action='MODIFY'" ); >+ $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'" ); > > 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 3820
:
1584
|
1585
|
85100
|
85102
|
85103
|
85104
|
85161
|
85162
|
85196
|
85197
|
85243
|
85244
|
85245
|
85246
|
85256
|
85257
|
85258
|
85259
|
85260
|
85269
|
85270
|
85271
|
85272
| 85273 |
85274
|
85276
|
85277