Cannot create user

[adg]

When I try to create a new user, it attempts to create it with a userID that already exisits. Below is the SQL error (with example data):

pg_query(): Query failed: ERROR: duplicate key value violates unique constraint "users_pkey"
DETAIL: Key (userid)=(8) already exists. [include/db.inc.php:511]
Error in query [INSERT INTO users (alias,name,surname,passwd,url,autologin,autologou t,lang,theme,refresh,rows_per_page,type,userid) VALUES ('a','a','a','0cc175b9c0f1b6a831c399e269772661','' ,'0','900','en_GB','default','30','50','1','8')] [ERROR: duplicate key value violates unique constraint "users_pkey"
DETAIL: Key (userid)=(8) already exists.]
SQL statement execution has failed "INSERT INTO users (alias,name,surname,passwd,url,autologin,autologou t,lang,theme,refresh,rows_per_page,type,userid) VALUES ('a','a','a','0cc175b9c0f1b6a831c399e269772661','' ,'0','900','en_GB','default','30','50','1','8')".

I can create the user in SQL manually.

Any help appreciated!

[dirckcopeland]

cannot create user

adg,
Can you share the command that you used to create the user manually, I'm stuck with the same error you are seeing and need to get the user added in the mean time.

also did you ever get this error figured out? I just upgraded from 2.4.7 to 3.2.4 and this is one of the few issues I ran onto so far.

Any help would be appreciated.