[Users] openserctl problem

Bogdan-Andrei Iancu bogdan at voice-system.ro
Wed Feb 28 17:52:03 CET 2007


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 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-----
>
> _______________________________________________
> Users mailing list
> Users at openser.org
> http://openser.org/cgi-bin/mailman/listinfo/users
>
>   





More information about the sr-users mailing list