From 7cb62ca9a2742e10334cba6bf965a5c0d8ad40ba Mon Sep 17 00:00:00 2001
From: "mkanat%kerio.com" <>
Date: Thu, 3 Mar 2005 15:19:09 +0000
Subject: Bug: 284244: DATE_SUB and DATE_ADD are not ANSI SQL Patch By Tomas
 Kopal <Tomas.Kopal@altap.cz> r=wicked, a=justdave

---
 Bugzilla/Token.pm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'Bugzilla/Token.pm')

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();
 
-- 
cgit v1.2.3-24-g4f1b