I would suggest that if you really want help, you should at least supply
a little information for people to work with.
You might post the table schema, the line that won't insert, and the
query and results
that you ran that shows that the indicated key are not in the table.
Since there are 600.000 entries in the table, you are probably not a
neophyte,
but your post makes you look like one.
Tobias Wolff wrote:
>
> Hello Gerald,
> what would you suggest?? Should I give you a list of all 600.000 entries in
> the table?? And there is nothing special about the structure ... they are
> similar .. with only one single-column primary key.
>
> And the key being different each time I run the script should tell you that
> there is something wrong.
>
> And I even tried the same perl script with the same ACCESS database on a
> MySQL database version 3.22.32 with no problems at all. So there MUST be
> something wrong with version 3.23.33, don't you think?????
>
> But, o.k., I will try to give you a bit more information about the error
> message.
>
> Cheers,
> Tobias.
>
> -----Ursprüngliche Nachricht-----
> Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Im
> Auftrag von Gerald L. Clark
> Gesendet: Donnerstag, 8. März 2001 18:40
> An: Tobias Wolff
> Cc: Mysql
> Betreff: Re: Duplicate Entry in Key 1
>
> Tobias Wolff wrote:
> >
> > Hello,
> > I have searched the mailing list for this topic, but didn't find a match
> vor
> > my problem.
> >
> > I am working on Linux Mandrake with MySQL 3.23.33 installed from the RPMs
> > for Mandrake. I am trying to convert a ACCESS database to MySQL using a
> perl
> > script. The script makes connections to the ACCESS database via ODBC and
> to
> > the MySQL database. The script works find in converting several tables. On
> > one table it fails with saying "duplicate entry in key 1" with "key 1"
> being
> > the primary key. Two funny things:
> >
> > 1. There isn't a duplicate entry for this key. Checked this over and over
> > again.
> > 2. It is not the same key. Each time I run the script it gives me a
> > different key. Of course, I do drop the table first.
> >
> > Can someone help me??
> > Thanks,
> > Tobias.
> >
> Without a listing of the table structures, import files, and query
> results
> to prove your assertion, I would be inclined to believe MySQL.
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
