MySQL Bugs: #14446: 230000 DUPLICATE ENTRY 'xxxxxxx' FOR KEY 1

Bug #14446	230000 DUPLICATE ENTRY 'xxxxxxx' FOR KEY 1
Submitted:	28 Oct 2005 22:52	Modified:	29 Nov 2005 16:00
Reporter:	oscar de la cruz	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	5.0.15	OS:	Windows (WIN XP SP1)
Assigned to:		CPU Architecture:	Any

Description:
HI I REALLY WANT TO USE MYSQL SERVER, BUT  I CANNOT, WHY ALWAYS THAT I WANT TO TRY TO INSERT  MANY   ROWS, MYSQL SERVER SHOW AN ERROR :
"230000 DUPLICATE ENTRY 'xxxxxxx' FOR KEY 1", AND THERE'S NOT ANY DUPLICATE ENTRY 

I TRYING VISUAL BASIC .NET 2003 
MYSQL SERVER 5.0.15  RELEASE
CONECTOR 1.6 .NET

WHAT'S HAPPEND?? I'M FED UP OF THIS !!!!!

please help me !!!!!!

How to repeat:
 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        'Dim s As New localhost.Service1 
        Dim i As Integer

        'MessageBox.Show(s.HelloWorld)

        Try
            cn.Open()
            '   MessageBox.Show("Conexion exitosa")

            cmd.Parameters.Add("?pIdEmpleado", TextBox1.Text)
            cmd.Parameters("?pIdEmpleado").Direction = ParameterDirection.Input

            cmd.Parameters.Add("?pNombre", TextBox2.Text)
            cmd.Parameters("?pNombre").Direction = ParameterDirection.Input

            i = cmd.ExecuteNonQuery()
            MessageBox.Show("registros afectados =" & i.ToString)

            cn.Close()
        Catch ex As Exception
            MessageBox.Show(ex.Message)
            cn.Close()
        End Try

    End Sub

Thank you for a problem report. Sorry, but this only subroutine is absolutely not enough for anybody to repeat the problem you wrote about.

Please, send the resutls of the SHOW CREATE TABLE statement for the table you are trying to insert into, the INSERT statement itself (those "cmd" text):

            cmd.Parameters.Add("?pIdEmpleado", TextBox1.Text)
            cmd.Parameters("?pIdEmpleado").Direction = ParameterDirection.Input
            cmd.Parameters.Add("?pNombre", TextBox2.Text)
            cmd.Parameters("?pNombre").Direction = ParameterDirection.Input
            i = cmd.ExecuteNonQuery()

and typical parameter values. 

Do you have any data in that table already? Please, send the dump. You may use File tab for that.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".