Database might need a clean ?

[johndrinkwater]

Upon accessing Trac, I was presented with the following error, and stack crawl

Oops… Trac detected an internal error:

Traceback (most recent call last):

File "/home/haikuos//lib/python2.4/site-packages/trac/web/main.py", line 356, in dispatch_request

dispatcher.dispatch(req)

File "/home/haikuos//lib/python2.4/site-packages/trac/web/main.py", line 189, in dispatch

req.authname = self.authenticate(req)

File "/home/haikuos//lib/python2.4/site-packages/trac/web/main.py", line 145, in authenticate

authname = authenticator.authenticate(req)

File "build/bdist.linux-i686/egg/dbauth/auth.py", line 78, in authenticate File "build/bdist.linux-i686/egg/dbauth/auth.py", line 259, in _get_name_for_cookie File "build/bdist.linux-i686/egg/dbauth/auth.py", line 286, in _update_email File "/home/waldemar//lib/python2.4/site-packages/trac/db/util.py", line 47, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/home/waldemar//lib/python2.4/site-packages/trac/db/util.py", line 47, in execute

return self.cursor.execute(sql_escape_percent(sql), args)

File "/home/waldemar//lib/python2.4/site-packages/MySQLdb/cursors.py", line 163, in execute

self.errorhandler(self, exc, value)

File "/home/waldemar//lib/python2.4/site-packages/MySQLdb/connections.py", line 35, in defaulterrorhandler

raise errorclass, errorvalue

IntegrityError: (1062, "Duplicate entry 'johndrinkwater-1-email' for key 1")

[wkornewald]

I don't know why I didn't notice it on my machine. I tested everything (even manually setting an older date for my session, so it gets updated). Well, I've fixed it now.

FYI, I've changed the way the authentication system works, so you get logged out after one week of inactivity instead of every 24h. If that doesn't work then please file a bug, again. Thanks! :)