El Wednesday 11 July 2007 13:26:56 TCB escribió:

I have just installed OSER v 1.2.1 and i can only add one entry into my subscriber table after that i get the following error when i run openserctl add .... I can add directly into the db with phppgadmin either . I;m using pgsql.

ERROR: duplicate key violates unique constraint "phplib_id_key" any ideas ?

That is because the field "phplib_id_key" in the table has a "UNIQUE" attribute. When you create a user with "openserctl add ..." the "phplib_id_key" is empty so if you try to create a new one it's not possible since there would be tow entries with the same (empty) "phplib_id_key".

I made it work by modifing the table struct and deleting the "UNIQUE" attribute of the "phplib_id_key" field.