Bugzilla – Attachment 95850 Details for
Bug 24130
Update 18.12.00.024 can fail due to bad date data
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 24130: (RM follow-up) Fix old invalid data
Bug-24130-RM-follow-up-Fix-old-invalid-data.patch (text/plain), 1.30 KB, created by
Martin Renvoize
on 2019-11-27 15:55:10 UTC
(
hide
)
Description:
Bug 24130: (RM follow-up) Fix old invalid data
Filename:
MIME Type:
Creator:
Martin Renvoize
Created:
2019-11-27 15:55:10 UTC
Size:
1.30 KB
patch
obsolete
>From e493cca4a0cba37894b5327d4cc8776e2e0148db Mon Sep 17 00:00:00 2001 >From: Martin Renvoize <martin.renvoize@ptfs-europe.com> >Date: Wed, 27 Nov 2019 15:52:57 +0000 >Subject: [PATCH] Bug 24130: (RM follow-up) Fix old invalid data > >Signed-off-by: Martin Renvoize <martin.renvoize@ptfs-europe.com> >--- > installer/data/mysql/updatedatabase.pl | 11 +++++++++++ > 1 file changed, 11 insertions(+) > >diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl >index 232e180275..fb3b4c223b 100755 >--- a/installer/data/mysql/updatedatabase.pl >+++ b/installer/data/mysql/updatedatabase.pl >@@ -17632,6 +17632,17 @@ if( CheckVersion( $DBversion ) ) { > $DBversion = '18.12.00.024'; > if ( CheckVersion($DBversion) ) { > >+ # Fixup any pre-existing bad suggestedby, manageddate, accepteddate dates >+ $dbh->do( >+ "UPDATE suggestions SET suggesteddate = '1970-01-01' WHERE suggesteddate = '0000-00-00';" >+ ); >+ $dbh->do( >+ "UPDATE suggestions SET manageddate = '1970-01-01' WHERE manageddate = '0000-00-00';" >+ ); >+ $dbh->do( >+ "UPDATE suggestions SET accepteddate = '1970-01-01' WHERE accepteddate = '0000-00-00';" >+ ); >+ > # Add constraint for suggestedby > unless ( foreign_key_exists( 'suggestions', 'suggestions_ibfk_suggestedby' ) ) > { >-- >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 24130
: 95850