[Users] ERROR 1062 (23000): Duplicate entry

alper ozbilen alperbilen at hotmail.com
Wed Mar 21 14:05:05 CET 2007


I used openserctl add but mysql insert is vital to add user through php 
interface.
As far as i know  ha1 & ha1b & and phplib_id fields generated by md5sum?? 
must there be error in
md5sum ? if so, how can i do?

Thanks again


>From: ¹ù¾ü <jguo at qqtechnology.com>
>To: "alper ozbilen" <alperbilen at hotmail.com>,<users at openser.org>
>Subject: ´ð¸´: [Users] ERROR 1062 (23000): Duplicate entry
>Date: Wed, 21 Mar 2007 16:49:35 +0800
>
>Why don't you use openserctl add ....to add new user?
>

>
>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
>

_________________________________________________________________
Get a FREE Web site, company branded e-mail and more from Microsoft Office 
Live! http://clk.atdmt.com/MRT/go/mcrssaub0050001411mrt/direct/01/





More information about the Users mailing list