0006142: PostgreSQL: creation of user failed

ID	Project	Category	View Status	Date Submitted	Last Update
0006142	mantisbt	sql	public	2005-08-15 12:49	2005-09-11 08:12

Reporter	Fredy	Assigned To	thraxisp
Priority	normal	Severity	minor	Reproducibility	unable to reproduce
Status	closed	Resolution	fixed
Product Version	1.0.0rc1
Fixed in Version	1.0.0rc2

Summary	0006142: PostgreSQL: creation of user failed
Description	I have fresh installation and i have successfully logged in asi administrator. When i try create new user from administration, a get an error: Database query failed. Error received from database was #-5: ERROR: duplicate key violates unique constraint "mantis_user_table_pkey" for the query: INSERT INTO mantis_user_table ( username, email, password, date_created, last_visit, enabled, access_level, login_count, cookie_string, realname ) VALUES ( 'Fredy', 'fredy@pomeranc.cz', '65facdbf1fb9ccff2707a41116b0afe8', '2005-08-15 18:36:32','2005-08-15 18:36:32', 1, 90, 0, 'e7bb51641dc9a1ee67dd97d4119c5b57b4f0a456eaf1199e0284f78fe8adfe26', '') I have tried running this query from phpPgAdmin and it was completed successfully (i was connected with same user as mantis do).
Additional Information	Apache 2.0.54 PHP 5.0.4 PostgreSQL 8.0.3
Tags	No tags attached.

thraxisp 2005-08-15 20:19 reporter ~0011216 Last edited: 2005-08-15 20:38	This is curious. I had an old database that exhibited this behaviour. It seems that the first insert into this table fails. Once the data is inserted, future creation of users is successful. Upon recreating the database, I don't see any failures.

thraxisp 2005-08-16 10:34 reporter ~0011225	Upon further investigation, it looks like the initial INSERT of user data was done wrong in rc1. It bypassed the auto-increment field. This was fixed in 0006021.