diff options
| author | Mark Wells <mark@freeside.biz> | 2013-08-15 15:37:54 -0700 |
|---|---|---|
| committer | Mark Wells <mark@freeside.biz> | 2013-08-15 15:37:54 -0700 |
| commit | c3596ed941f619f6105aa56ba09da09f3fd631b4 (patch) | |
| tree | 173c70d91f559079c2a1b0ae99082bd16dcff1d5 /FS | |
| parent | 81fbbbd132ec70b81719399aa07d7a6f2606ba6f (diff) | |
set default WillResolve dates on all tickets, #23309
Diffstat (limited to 'FS')
| -rw-r--r-- | FS/FS/TicketSystem.pm | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/FS/FS/TicketSystem.pm b/FS/FS/TicketSystem.pm index c1c69fa3f..3aeadb37f 100644 --- a/FS/FS/TicketSystem.pm +++ b/FS/FS/TicketSystem.pm @@ -342,6 +342,11 @@ sub _upgrade_data { or die $dbh->errstr; $cve_2013_3373_sth->execute or die $cve_2013_3373_sth->errstr; + # fix null WillResolve fields to avoid spurious transactions the + # first time they get updated + my $fix_null_sql = "UPDATE Tickets SET WillResolve = '1970-01-01 00:00:00' WHERE WillResolve IS NULL"; + $dbh->do($fix_null_sql) or die $dbh->errstr; + return; } |