diff options
| author | Simon Green <sgreen@redhat.com> | 2013-12-02 23:44:46 +0100 |
|---|---|---|
| committer | Simon Green <sgreen@redhat.com> | 2013-12-02 23:44:46 +0100 |
| commit | 50a44fc4185bb62fdf2a405cb0dfafe782824362 (patch) | |
| tree | 4869ebab10d081f29d64f0f17b277ab1654a7aa5 | |
| parent | d8395124b3664e9216e47234b0000ef81341f520 (diff) | |
| download | bugzilla-50a44fc4185bb62fdf2a405cb0dfafe782824362.tar.gz bugzilla-50a44fc4185bb62fdf2a405cb0dfafe782824362.tar.xz | |
Bug 944583 - sendunsentbugmail.pl has bad SQL
r=glob, a=sgreen
| -rwxr-xr-x | contrib/sendunsentbugmail.pl | 7 |
1 files changed, 3 insertions, 4 deletions
diff --git a/contrib/sendunsentbugmail.pl b/contrib/sendunsentbugmail.pl index 536d12146..474554135 100755 --- a/contrib/sendunsentbugmail.pl +++ b/contrib/sendunsentbugmail.pl @@ -17,10 +17,9 @@ use Bugzilla::BugMail; my $dbh = Bugzilla->dbh; my $list = $dbh->selectcol_arrayref( - 'SELECT bug_id FROM bugs - WHERE lastdiffed IS NULL - OR lastdiffed < delta_ts - AND delta_ts < ' + 'SELECT bug_id FROM bugs + WHERE (lastdiffed IS NULL OR lastdiffed < delta_ts) + AND delta_ts < ' . $dbh->sql_date_math('NOW()', '-', 30, 'MINUTE') . ' ORDER BY bug_id'); |