diff options
| author |   Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 03:58:28 -0700 |
|---|---|---|
| committer | Max Kanat-Alexander <mkanat@bugzilla.org> | 2010-10-07 03:58:28 -0700 |
| commit | 02a049703de6055f09f44f89a5a821814696ce32 (patch) | |
| tree | 5918c91ceea49d280c8c3c0ce795da549a8bf4c6 /sanitycheck.cgi | |
| parent | Bug 26074 - Ability to limit search by number of Comments (diff) | |
| download | bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.gz bugzilla-02a049703de6055f09f44f89a5a821814696ce32.tar.bz2 bugzilla-02a049703de6055f09f44f89a5a821814696ce32.zip | |
Bug 602165: Change sql_interval to sql_date_math, in preparation for
MS-SQL and SQLite support.
Diffstat (limited to 'sanitycheck.cgi')
| -rwxr-xr-x | sanitycheck.cgi | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/sanitycheck.cgi b/sanitycheck.cgi index 63872bd49..a4f9832b0 100755 --- a/sanitycheck.cgi +++ b/sanitycheck.cgi @@ -229,14 +229,14 @@ if ($cgi->param('rescanallBugMail')) { require Bugzilla::BugMail; Status('send_bugmail_start'); - my $time = $dbh->sql_interval(30, 'MINUTE'); + my $time = $dbh->sql_date_math('NOW()', '-', 30, 'MINUTE'); my $list = $dbh->selectcol_arrayref(qq{ SELECT bug_id FROM bugs WHERE (lastdiffed IS NULL OR lastdiffed < delta_ts) - AND delta_ts < now() - $time + AND delta_ts < $time ORDER BY bug_id}); Status('send_bugmail_status', {bug_count => scalar(@$list)}); @@ -857,12 +857,12 @@ BugCheck("bugs Status('unsent_bugmail_check'); -my $time = $dbh->sql_interval(30, 'MINUTE'); +my $time = $dbh->sql_date_math('NOW()', '-', 30, 'MINUTE'); my $badbugs = $dbh->selectcol_arrayref(qq{ SELECT bug_id FROM bugs WHERE (lastdiffed IS NULL OR lastdiffed < delta_ts) - AND delta_ts < now() - $time + AND delta_ts < $time ORDER BY bug_id}); |