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(a)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(a)openser.org
http://openser.org/cgi-bin/mailman/listinfo/users