[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