diff options
Diffstat (limited to 'Bugzilla')
| -rw-r--r-- | Bugzilla/Search.pm | 2 | ||||
| -rw-r--r-- | Bugzilla/Token.pm | 4 |
2 files changed, 3 insertions, 3 deletions
diff --git a/Bugzilla/Search.pm b/Bugzilla/Search.pm index f2e630784..1a0cb9a7f 100644 --- a/Bugzilla/Search.pm +++ b/Bugzilla/Search.pm @@ -922,7 +922,7 @@ sub init { } elsif ($unit eq 'y') { $unitinterval = 'YEAR'; } - my $cutoff = "DATE_SUB(NOW(), " . + my $cutoff = "NOW() - " . $dbh->sql_interval("$quantity $unitinterval"); my $assigned_fieldid = &::GetFieldID('assigned_to'); push(@supptables, "LEFT JOIN longdescs comment_$table " . diff --git a/Bugzilla/Token.pm b/Bugzilla/Token.pm index 73f074185..feca00c3b 100644 --- a/Bugzilla/Token.pm +++ b/Bugzilla/Token.pm @@ -119,8 +119,8 @@ sub IssuePasswordToken { LEFT JOIN tokens ON tokens.userid = profiles.userid AND tokens.tokentype = 'password' - AND tokens.issuedate > DATE_SUB(NOW(), " . - $dbh->sql_interval('10 MINUTE') . ") + AND tokens.issuedate > NOW() - " . + $dbh->sql_interval('10 MINUTE') . " WHERE login_name = $quotedloginname"); my ($userid, $toosoon) = &::FetchSQLData(); |