Edgewall Software

Opened 3 years ago

Closed 3 years ago

Last modified 3 years ago

#12788 closed defect (cantfix)

Error while reseting a password - AccountManager Plugin v0.5dev

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 ...
File "build/bdist.linux-x86_64/egg/trac/web/main.py", line 613, in _dispatch_request
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

Attachments (0)

Change History (3)

comment:1 by Jun Omae, 3 years ago

Description: modified (diff)
Keywords: AccountManager Plugin v0.5dev removed
Milestone: 1.2.3
Resolution: cantfix
Status: newclosed

comment:2 by Jun Omae, 3 years ago

Component: database backendgeneral
Description: modified (diff)

comment:3 by Jun Omae, 3 years ago

Description: modified (diff)

Modify Ticket

Change Properties
Set your email in Preferences
as closed The ticket will remain with no owner.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from (none) to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.