Why don't you use openserctl add ....to add new user? -----邮件原件----- 发件人: alper ozbilen [mailto:alperbilen@hotmail.com] 发送时间: 2007年3月21日 16:45 收件人: users(a)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(a)myfon.com");,"emailoftestuser@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_hmemailtaglinema… _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users _______________________________________________ Users mailing list Users(a)openser.org http://openser.org/cgi-bin/mailman/listinfo/users