After apgrading i get this error when creating new user

user error: Duplicate entry '1' for key 1
query: INSERT INTO users (name, pass, init, mail, status, created, changed, uid) VALUES ('test', '77ebe758c31a059507f144047462d2ea', 'test@example.com', 'test@example.com', '1', '1119518923', '1119518923', '4') in /usr/www/users/ne/includes/database.mysql.inc on line 66.

.... also when creating a menu or node

user error: Duplicate entry '1' for key 1
query: INSERT INTO menu .......

user error: Duplicate entry '1' for key 1
query: INSERT INTO node .......

This is my sequences table before error

menu_mid 100
users_uid 100
node_nid 100

this is after the all three errors

menu_mid 100
users_uid 100
node_nid 100
{menu}_mid 9
{users}_uid 1
{node}_nid 1

It should be said here that i have more fields in sequences but for the eg. this will do
Basicall every time i create anything, drupal creates a new {field}

i have noticed that every time i get the error the new {field} increments and not the original PLUS..... listen to this, the error stops when the {field} reaches the original fields value

please help! I want to upgrade several sites. Oh yes and i am using multiple vhosts if this changes anything.

Is this a bug or am i missing something

Comments

willem van straaten’s picture

I implimented this workaround a couple of weeks ago

http://drupal.org/node/1190#comment-35269

THAT WAS THE PROBLEM

http://www.econsultant.co.za