[RTEMS Project] #3013: 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")

[RTEMS trac]

#3013: 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")
----------------------------------+-----------------------------
 Reporter:  Nikolay Komashinskiy  |      Owner:  joel.sherrill@…
     Type:  defect                |     Status:  new
 Priority:  normal                |  Milestone:  Indefinite
Component:  web                   |    Version:
 Severity:  normal                |   Keywords:
----------------------------------+-----------------------------
 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 at 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")
 }}}

--
Ticket URL: <http://devel.rtems.org/ticket/3013>
RTEMS Project <http://www.rtems.org/>
RTEMS Project