#3013 closed defect (fixed)

ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sid='nikolaykomashinskiy' AND authenticated=1 AND name='force_change_passwd'' at line 1")

Reported by: Nikolay Komashinskiy Owned by: Amar Takhar
Priority: normal Milestone: 5.1
Component: tool/website Version:
Severity: normal Keywords:
Cc: Blocked By:
Blocking:

Description

Hello, during reset password I had an internal error. This card was automatically generated.

How to Reproduce

While doing a POST operation on /reset_password, Trac issued an internal error.

(please provide additional details here)

Request parameters:

{u'__FORM_TOKEN': u'56888d70c5e5799302935f97',
 u'email': u'nikolay.komashinskiy@yandex.ru',
 u'register_phone': u'',
 u'rtems_user_phone': u'',
 u'username': u'nikolaykomashinskiy'}

User agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36

System Information

System information not available

Enabled Plugins

Plugin information not available

Interface Customization

Interface customization information not available

Python Traceback

Traceback (most recent call last):
  File "/data/src/trac/trac/web/main.py", line 620, in _dispatch_request
    dispatcher.dispatch(req)
  File "/data/src/trac/trac/web/main.py", line 253, in dispatch
    resp = chosen_handler.process_request(req)
  File "/data/trac/plugins/TracAccountManager-0.5.dev0-py2.7.egg/acct_mgr/web_ui.py", line 168, in process_request
    self._do_reset_password(req)
  File "/data/trac/plugins/TracAccountManager-0.5.dev0-py2.7.egg/acct_mgr/web_ui.py", line 256, in _do_reset_password
    self._reset_password(req, username, email)
  File "/data/trac/plugins/TracAccountManager-0.5.dev0-py2.7.egg/acct_mgr/web_ui.py", line 301, in _reset_password
    set_user_attribute(self.env, username, 'force_change_passwd', 1)
  File "/data/trac/plugins/TracAccountManager-0.5.dev0-py2.7.egg/acct_mgr/model.py", line 509, in set_user_attribute
    (value, username, attribute))
  File "/data/src/trac/trac/db/util.py", line 128, in execute
    cursor.execute(query, params if params is not None else [])
  File "/data/src/trac/trac/db/util.py", line 72, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/local/lib/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'sid='nikolaykomashinskiy' AND authenticated=1 AND name='force_change_passwd'' at line 1")

Change History (3)

comment:1 Changed on May 9, 2017 at 8:13:00 PM by Gedare

Owner: changed from joel.sherrill@… to Amar Takhar
Status: newassigned

comment:2 Changed on May 9, 2017 at 8:37:15 PM by Amar Takhar

Whoa very strange. I will look at this when I get home. Thank you for the report.

comment:3 Changed on Oct 20, 2018 at 8:02:25 PM by Amar Takhar

Milestone: Indefinite5.1
Resolution: fixed
Status: assignedclosed

This should have been fixed long ago if anyone runs into this issue again please open a new ticket.

Note: See TracTickets for help on using tickets.