Opened 13 years ago

Closed 13 years ago

#942 closed enhancement (fixed)

Database might need a clean ?

Reported by: johndrinkwater Owned by: wkornewald
Priority: normal Milestone: Website R1
Component: Website/Trac Version: R1/pre-alpha1
Keywords: Cc:
Blocked By: Blocking:
Has a Patch: no Platform: All

Description (last modified by wkornewald)

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/haikuoslib/python2.4/site-packages/trac/web/main.py", line 356, in dispatch_request

dispatcher.dispatch(req)

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

req.authname = self.authenticate(req)

File "/home/haikuoslib/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/waldemarlib/python2.4/site-packages/trac/db/util.py", line 47, in execute

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

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

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

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

self.errorhandler(self, exc, value)

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

raise errorclass, errorvalue

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

Change History (1)

comment:1 Changed 13 years ago by wkornewald

Description: modified (diff)
Resolution: fixed
Status: newclosed

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! :)

Note: See TracTickets for help on using tickets.