user error: Duplicate entry '9d9de5613c1399b92fa8db21b38ae' for key 1 query: INSERT INTO sessions (uid, sid, hostname, session, timestamp) values(1, '9d9de5613c139b92fa8db21b38ae', '132.230.78.135', '', 1070488473) in /home/vdst.net/www/htdocs/karlsruhe/includes/database.mysql.inc on line 96.

I get this error when somebody logs into my site. I think the following is happening: The user got that id as an anonymous user and then he keeps it as an authorized user. This results in this mysql error.

sess_write in session.inc is the function to look at. Maybe some sql magic can avoid this collision.

Comments

Kjartan’s picture

Kjartan commented
Assigned: Unassigned » Kjartan
killes@www.drop.org’s picture

killes@www.drop.org commented

For whatever reason this does not happen anymore.

robin monks’s picture

robin monks commented
Priority: Normal » Critical

Now reoccuring in Drupal 4.6/CivicSpace 0.8.1.

Reopening...

Robin

Steve Dondley’s picture

Steve Dondley commented
Version: » 4.6.5
killes@www.drop.org’s picture

killes@www.drop.org commented

It is fixed in cvs/4.7. Should be marked fixed after 4.7 got released.

Zen’s picture

Zen commented
Status: Active » Fixed

Marking as fixed - fixed in 4.7 as mentioned above.

-K

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)