If I could see the structure of the table with the name of the key field,
I may be able to help.. otherwise, there's just not enough info.
Thanks,
Michael Ridinger
On Fri, 9 Mar 2001, Gerald L. Clark wrote:
> 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
>
>
---------------------------------------------------------------------
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
