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.\r\n\r\nWe 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:\r\n{{{\r\n2011-08-10 08:33:05_339 Trac[api] INFO: Created new user: foobar\r\n2011-08-10 08:33:05_370 Trac[main] ERROR: Internal Server Error:.\r\nTraceback (most recent call last):\r\n  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\r\n    dispatcher.dispatch(req)\r\n  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3dev_r10719-py2.6.egg/trac/web/main.py"_ line 243_ in dispatch\r\n    resp = chosen_handler.process_request(req)\r\n  File "build/bdist.linux-i686/egg/acct_mgr/web_ui.py"_ line 439_ in process_request\r\n    _create_user(req_ self.env)\r\n  File "build/bdist.linux-i686/egg/acct_mgr/web_ui.py"_ line 154_ in _create_user\r\n    set_user_attribute(env_ username_ attribute_ value)\r\n  File "build/bdist.linux-i686/egg/acct_mgr/api.py"_ line 581_ in set_user_attribute\r\n    """_ (username_ attribute_ value))\r\n  File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.3dev_r10719-py2.6.egg/trac/db/util.py"_ line 65_ in execute\r\n    return self.cursor.execute(sql_escape_percent(sql)_ args)\r\nIntegrityError: insert or update on table "session_attribute" violates foreign key constraint "fk_session_sid"\r\nDETAIL:  Key (sid)=(foobar) is not present in table "session".\r\nIntegrityError: insert or update on table "session_attribute" violates foreign key constraint "fk_session_sid"\r\nDETAIL:  Key (sid)=(foobar) is not present in table "session".\r\n}}}\r\nThis 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.\r\n\r\nDo you have an idea what is going on here?\r\n\r\nRegards[[BR]]\r\nOliver\r\n\r\np.s. Thank you for your great work on this plugin.,defect,closed,normal,AccountManagerPlugin,normal,fixed,database PostgreSQL IntegrityError,,0.12