Edgewall Software

Opened 7 years ago

Closed 7 years ago

Last modified 7 years ago

#12788 closed defect (cantfix)

Error while reseting a password - AccountManager Plugin v0.5dev — at Version 1

Reported by: t.baron@… Owned by:
Priority: normal Milestone:
Component: general Version: 1.2
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description (last modified by Jun Omae)

TracAccountManager 	0.5dev 	/var/www/trac/plugins/TracAccountManager-0.5dev-py2.7.egg
======================================================================== 

Trac detected an internal error:

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='TEST1' AND authenticated=1 AND name='force_change_passwd'' at line 1")

========================================================================

File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 72, in execute 
Name	Value
args 	(1, u'TEST1', 'force_change_passwd')
self 	<trac.db.util.IterableCursor object at 0x7f0849a5add0>
sql 	'UPDATE session_attribute SET value=%sWHERE sid=%s AND authenticated=1 ...

=======================================================================

Traceback:
File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 613, in _dispatch_request
  dispatcher.dispatch(req)
File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 253, in dispatch
  resp = chosen_handler.process_request(req)
File "build/bdist.linux-x86_64/egg/trac/admin/web_ui.py", line 108, in process_request
  provider.render_admin_panel(req, cat_id, panel_id, path_info)
File "build/bdist.linux-x86_64/egg/acct_mgr/admin.py", line 219, in render_admin_panel
  return self._do_users(req)
File "build/bdist.linux-x86_64/egg/acct_mgr/admin.py", line 621, in _do_users
  acctmod._reset_password(req, username, email)
File "build/bdist.linux-x86_64/egg/acct_mgr/web_ui.py", line 301, in _reset_password
  set_user_attribute(self.env, username, 'force_change_passwd', 1)
File "build/bdist.linux-x86_64/egg/acct_mgr/model.py", line 509, in set_user_attribute
  (value, username, attribute))
File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 128, in execute
  cursor.execute(query, params if params is not None else [])
File "build/bdist.linux-x86_64/egg/trac/db/util.py", line 72, in execute
  return self.cursor.execute(sql_escape_percent(sql), args)
File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
  self.errorhandler(self, exc, value)
File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
  raise errorclass, errorvalue

=======================================================================

System Information

User Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:52.0) 
Gecko/20100101 Firefox/52.0

Package	Version

Trac 	1.2

Genshi 	0.7 (without speedups)

mod_wsgi 	4.3.0 (WSGIProcessGroup WSGIApplicationGroup %{GLOBAL})

MySQL 	server: "5.5.52-0+deb8u1", client: "5.5.52", thread-safe: 1

MySQLdb 	1.2.3

Python 	2.7.9 (default, Jun 29 2016, 13:11:10) [GCC 4.9.2]

setuptools 	5.5.1

jQuery	1.11.3

jQuery UI	1.11.4

jQuery Timepicker	1.5.5

Change History (1)

comment:1 by Jun Omae, 7 years ago

Description: modified (diff)
Keywords: AccountManager Plugin v0.5dev removed
Milestone: 1.2.3
Resolution: cantfix
Status: newclosed
Note: See TracTickets for help on using tickets.