HELP! Fatal error: Duplicate entry '0' for key 2 query: INSERT INTO drupal_sessions (sid, uid, hostname, timestamp)

Jason: When I moved from 4.6 to 4.7 I had lots of the above type errors. I went to the table (if it is session table, you can empty the table) and made the primary key column auto increment. I think it is sid for session table. The tables I had problems, if I remember correct from my memory, are watchdog, accesslog, session, cache. I emptied all these tables and made the primary key column auto increment. WARNING. BACK up your database always and NEVER Empty Important tables.

This type of error can happen if you delete certain required information from the database.

In your favorite mysql client, run the following (this is safe, queries will simply fail if data already exists):

INSERT INTO users (uid, name, mail) VALUES ('0', '', '');
INSERT INTO users_roles (uid, rid) VALUES (0, 1);
INSERT INTO node_access VALUES (0, 0, 'all', 1, 0, 0);


You can read more about the problem here.

--
Drupal tips, tricks and services
http://devbee.com/ - Effective Drupal

sorry, but I don't speak in english :P

in your database manager, insert this sql

INSERT INTO users (uid, name, mail) VALUES ('0', '', '');

it works for 4.6.9 and for 4.7.3

that's all

Hi i also encountered the problem for www.indrani.net

Fatal error: Duplicate entry '0' for key 2 query: INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES ('c22ec53a37da41bed6a278daa23ec8e2', 0, '165.21.154.10', 1182313616) in D:\Clients\9097\indrani.net\indrani.net\includes\database.mysql.inc on line 66

i'm using drupal 4.6.7 what should i do? (i'm not a sql expert..)