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