Bug 138496 - The 'forgot my password' link generates an error
Summary: The 'forgot my password' link generates an error
Alias: None
Product: Bugzilla
Classification: Community
Component: Bugzilla General
Version: 2.18
Hardware: All
OS: Linux
medium vote
Target Milestone: ---
Assignee: David Lawrence
QA Contact: David Lawrence
Depends On:
Blocks: BZ_218_Beta3
TreeView+ depends on / blocked
Reported: 2004-11-09 17:31 UTC by Sal Conigliaro
Modified: 2007-04-18 17:14 UTC (History)
1 user (show)

Clone Of:
Last Closed: 2004-11-11 17:38:06 UTC

Attachments (Terms of Use)

Description Sal Conigliaro 2004-11-09 17:31:10 UTC
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@redhat.com'"] 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@redhat.com') 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:

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.

Note You need to log in before you can comment on or make changes to this bug.