[Users] openserctl problem

Helmut Kuper helmut.kuper at ewetel.de
Tue Feb 27 16:17:07 CET 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

After fixing that Query error I tried to add 2 user to openser. The
first was successfully added to database. the 2nd failed with:

ERROR 1062 (23000) at line 1: Duplicate entry '' for key 3
ERROR: introducing the new user '103 at sip0.en.ewetel.de' to the database
failed

I looked into the database table subscribers and saw that column
phplib_id is of type UNIQUE.

I looked into the detailed mysql.log file and find out that the executed
INSERT statement doesn't set the column phplib_id, so the 2nd user would
have the same phplib_id value ('' or NULL) as the first. Because of
column typ UNIQUE this will lead to that error above.

Maybe someone of the developers can fix this.

regards
Helmut
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFF5Etw4tZeNddg3dwRAiX3AJwKD0DDVwKDxbeX1/9fVitIxQSaKgCgliv5
u5IIkongIw3a16e4uu+vm4A=
=kV49
-----END PGP SIGNATURE-----




More information about the sr-users mailing list