Bug 138496

Summary: The 'forgot my password' link generates an error
Product: [Community] Bugzilla Reporter: Sal Conigliaro <sconigli>
Component: Bugzilla GeneralAssignee: David Lawrence <dkl>
Status: CLOSED CURRENTRELEASE QA Contact: David Lawrence <dkl>
Severity: medium Docs Contact:
Priority: medium    
Version: 2.18CC: mmackenz
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2004-11-11 17:38:06 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 138111    

Description Sal Conigliaro 2004-11-09 17:31:10 UTC
User-Agent:       
Build Identifier: 

When you enter your userid, then click on the 'forgot my password' button, the
following message is display:

DBD::Pg::st execute failed: ERROR:  parser: parse error at or near "10" at
character 271 [for Statement "SELECT profiles.userid, tokens.issuedate FROM
profiles                    LEFT JOIN tokens
                   ON tokens.userid = profiles.userid
                   AND tokens.tokentype = 'password'
                   AND tokens.issuedate > DATE_SUB(NOW(), INTERVAL 10 MINUTE)
                   WHERE login_name = 'tao-qa'"] at Bugzilla/DB.pm
line 74
    Bugzilla::DB::SendSQL('SELECT profiles.userid, tokens.issuedate FROM
profiles \x{a}     ...') called at Bugzilla/Token.pm line 119
    Bugzilla::Token::IssuePasswordToken('tao-qa') called at
/var/www/bugzilla/beta2/token.cgi line 160
    main::requestChangePassword() called at /var/www/bugzilla/beta2/token.cgi
line 133


Reproducible: Always
Steps to Reproduce:
1.
2.
3.

Comment 1 David Lawrence 2004-11-09 17:33:03 UTC
Thanks. Adding to mustfix for beta3.

Comment 2 Mike MacKenzie 2004-11-11 17:38:06 UTC
Fixed.  This fix will show up in the next beta release.