Hi Helmut,

if you have the serweb adds-on on the subscriber table, you need to set the HAS_SERWEB variable to "yes" to add also the phplib_id column. See openserctlrc file for "HAS_SERWEB" var.

regards, bogdan

Helmut Kuper wrote:

-----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@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-----

---

Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users