id	summary	reporter	owner	description	type	status	priority	component	severity	resolution	keywords	cc	release
9079	PostgreSQL: Database error when creating new user with attributes	olistudent	hasienda	"Hi.

We are running trac-0.12.3 with postgres db. Since one of the last updates of account manager plugin users cause this error message when creating a new account:
{{{
2011-08-10 08:33:05,339 Trac[api] INFO: Created new user: foobar
2011-08-10 08:33:05,370 Trac[main] ERROR: Internal Server Error:.
Traceback (most recent call last):
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.3dev_r10719-py2.6.egg/trac/web/main.py"", line 522, in _dispatch_request
    dispatcher.dispatch(req)
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.3dev_r10719-py2.6.egg/trac/web/main.py"", line 243, in dispatch
    resp = chosen_handler.process_request(req)
  File ""build/bdist.linux-i686/egg/acct_mgr/web_ui.py"", line 439, in process_request
    _create_user(req, self.env)
  File ""build/bdist.linux-i686/egg/acct_mgr/web_ui.py"", line 154, in _create_user
    set_user_attribute(env, username, attribute, value)
  File ""build/bdist.linux-i686/egg/acct_mgr/api.py"", line 581, in set_user_attribute
    """""", (username, attribute, value))
  File ""/usr/local/lib/python2.6/dist-packages/Trac-0.12.3dev_r10719-py2.6.egg/trac/db/util.py"", line 65, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
IntegrityError: insert or update on table ""session_attribute"" violates foreign key constraint ""fk_session_sid""
DETAIL:  Key (sid)=(foobar) is not present in table ""session"".
IntegrityError: insert or update on table ""session_attribute"" violates foreign key constraint ""fk_session_sid""
DETAIL:  Key (sid)=(foobar) is not present in table ""session"".
}}}
This happens only when one of the additional fields (name, email) is filled out. Otherwise everything ist fine. Despite the error message the user is created.

Do you have an idea what is going on here?

Regards[[BR]]
Oliver

p.s. Thank you for your great work on this plugin."	defect	closed	normal	AccountManagerPlugin	normal	fixed	database PostgreSQL IntegrityError		0.12