summaryrefslogtreecommitdiffstats
path: root/contrib/sendunsentbugmail.pl
diff options
context:
space:
mode:
authorSimon Green <sgreen@redhat.com>2013-12-02 23:44:46 +0100
committerSimon Green <sgreen@redhat.com>2013-12-02 23:44:46 +0100
commit50a44fc4185bb62fdf2a405cb0dfafe782824362 (patch)
tree4869ebab10d081f29d64f0f17b277ab1654a7aa5 /contrib/sendunsentbugmail.pl
parentd8395124b3664e9216e47234b0000ef81341f520 (diff)
downloadbugzilla-50a44fc4185bb62fdf2a405cb0dfafe782824362.tar.gz
bugzilla-50a44fc4185bb62fdf2a405cb0dfafe782824362.tar.xz
Bug 944583 - sendunsentbugmail.pl has bad SQL
r=glob, a=sgreen
Diffstat (limited to 'contrib/sendunsentbugmail.pl')
-rwxr-xr-xcontrib/sendunsentbugmail.pl7
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');