diff options
| author | mkanat%kerio.com <> | 2005-03-03 16:19:09 +0100 |
|---|---|---|
| committer | mkanat%kerio.com <> | 2005-03-03 16:19:09 +0100 |
| commit | 7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba (patch) | |
| tree | e509aee1bc024c0d486e557cd3f7a2e9750f45e8 /sanitycheck.cgi | |
| parent | 0e8f16e1c64b07cf6d90264f8f754307d340b30e (diff) | |
| download | bugzilla-7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba.tar.gz bugzilla-7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba.tar.xz | |
Bug: 284244: DATE_SUB and DATE_ADD are not ANSI SQL
Patch By Tomas Kopal <Tomas.Kopal@altap.cz> r=wicked, a=justdave
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 8b7701eb1..63ddf181f 100755 --- a/sanitycheck.cgi +++ b/sanitycheck.cgi @@ -177,8 +177,8 @@ if (defined $cgi->param('rescanallBugMail')) { Status("OK, now attempting to send unsent mail"); SendSQL("SELECT bug_id FROM bugs WHERE lastdiffed < delta_ts AND - delta_ts < date_sub(now(), " . $dbh->sql_interval('30 minute') . - ") ORDER BY bug_id"); + delta_ts < now() - " . $dbh->sql_interval('30 minute') . + " ORDER BY bug_id"); my @list; while (MoreSQLData()) { push (@list, FetchOneColumn()); @@ -736,8 +736,8 @@ Status("Checking for unsent mail"); SendSQL("SELECT bug_id " . "FROM bugs WHERE lastdiffed < delta_ts AND ". - "delta_ts < date_sub(now(), " . $dbh->sql_interval('30 minute') . - ") ORDER BY bug_id"); + "delta_ts < now() - " . $dbh->sql_interval('30 minute') . + " ORDER BY bug_id"); while (@row = FetchSQLData()) { my ($id) = (@row); |