By fatfish on

I recive this error

Fatal error: Duplicate entry '4e6ed19051e230135991a250e03b6df6' for key 1 query: INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('4e6ed19051e230135991a250e03b6df6', 0, '85.64.138.254', 1137399923) in c:\.....\wwwroot\site\includes\database.mysql.inc on line 66

AND can not log to my site.
I've found out sess_read() if doing that INSERT but I could not find who's calling it ?

⋅ Categories: Drupal 4.6.x

Comments

venkat-rk’s picture

venkat-rk commented

You have company:(

See http://drupal.org/node/44818 and http://drupal.org/node/44906

sangamreddi’s picture

sangamreddi commented

check this comment may be useful to U.

http://drupal.org/node/44818#comment-83899

Sunny
www.gleez.com

fatfish’s picture

fatfish commented

I repaird an optimize all db and still get the messege.
Any Ideas ?

Fish

..:| Tomer Fish |:..
FatFish - Your Digital Success Partner

venkat-rk’s picture

venkat-rk commented

I can understand how you feel. I will let you know if I am able to solve this.

Are you hosting with Site5, by any chance?

fatfish’s picture

fatfish commented

User ID 0 was missing !!!
I've Create a user with uid 0 (zero) and its all working now.
(fullish me the delete it in the first place ...)

..:| Tomer Fish |:..
FatFish - Your Digital Success Partner

venkat-rk’s picture

venkat-rk commented

I see the following in my dump for the 'Users' table:

INSERT INTO users VALUES("0","","","","0","0","0","","","0","0","0","","","","","");

This seems to suggest that uid 0 is present. Do I need to change anything in this?

HAZ’s picture

HAZ commented

the "no 0" uid was the problem for me... thank you for pointing that one out!

(no idea how or when or why it was deleted - but that was definitely the problem).

thanks!

--HAZ

Vaughan’s picture

Vaughan commented

We just had a site glitch, causing permission problems that turned out to be because the user 0 was not allocated to the Anonymous role. This was causing menu items and content to not be displayed correctly

Fixed after that allocation :)

Vaughan