答复: [Users] ERROR 1062 (23000): Duplicate entry

[郭军]

Why don't you use openserctl add ....to add new user?

-----邮件原件-----
发件人: alper ozbilen [mailto:alperbilen at hotmail.com] 
发送时间: 2007年3月21日 16:45
收件人: users at openser.org
主题: [Users] ERROR 1062 (23000): Duplicate entry

Dear All,

I can not insert a new subscriber from mysql console.
When I look at subscireber table, ha1 & ha1b & and phplib_id fields looks 
null. So, i can only insert one new subscriber. When i attempt to insert 
second one, i get error written below:

ERROR 1062 (23000): Duplicate entry '' for key 3

Note : My insert sentence like that:
insert into subscriber (username, domain, password, email_address) values 
("testuser","myfon.com","testpasswd","emailoftestuser at myfon.com");

I am confused about what i should to do to fix null statement of ha1 & ha2 & 
and phplib_id fields.

on the other side, there is no probem to add new user through openserctl

What was the problem? I will wait your kind suggestion.

Regards,
Alper Ozbilen

_________________________________________________________________
Exercise your brain! Try Flexicon. 
http://games.msn.com/en/flexicon/default.htm?icid=flexicon_hmemailtaglinemarch07


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