Skip navigation links

MySQL Forums :: General :: Can some please help me with a duplicate key error


Advanced Search

Can some please help me with a duplicate key error
Posted by: mike browne ()
Date: May 16, 2013 07:03AM

Hello,

I have been trying to solve this problem for a long time and have not found a solution, so could someone please assist me.

I am getting this error:

[MySQL][ODBC 3.51 Driver][mysqld-4.1.22-community-nt]Duplicate entry '' for key 2


Now as far as I know I only have one index on the table and it is the primary key which is auto-increment. So what is this error really telling me, what is it referring to when it says "For Key 2", I cannot figure out what key2 is.

Also, it shows as a '' which to me looks like a null. However I have every field filled in with something on the insert clause.

Insert clause is:

INSERT INTO ASSETSCHEDULE (AssetID,DateReserved,DateReservedString,CreatDate,CreatDateString,CreatTime,CreatTimeString,TimeReserved,TimeReservedString,ReserveLength,LastRecordedTime,LastRecordedTimeString,PatronBarcode,PatronFirstName,PatronLastName,PatronType,ReserveType,BookingCode,RecordDeleted,BranchLocated,ZoneLocated) VALUES('Table7',41409,'5/15/2013',41409,'5/15/2013',0.59880594907,'2:22:16 PM',0.59791666667,'2:21:00 PM',60,0.59791666667,'2:21:00 PM','Temp Schedule ',' ',' ',' ',1,'T8DJ9B350E7OO23',2,'Main Room',0)

I am at a loss for why this would error off with the above error message. So can someone please assist me, or tell me what to look for.

Thanks for any information

Mike

Options: ReplyQuote


Subject Written By Posted
Can some please help me with a duplicate key error mike browne 05/16/2013 07:03AM
Re: Can some please help me with a duplicate key error Peter Brawley 05/16/2013 01:44PM
Re: Can some please help me with a duplicate key error mike browne 05/17/2013 10:00AM
Re: Can some please help me with a duplicate key error Peter Brawley 05/17/2013 01:39PM
Re: Can some please help me with a duplicate key error mike browne 05/18/2013 06:51PM
Re: Can some please help me with a duplicate key error Rick James 05/18/2013 10:49PM
Re: Can some please help me with a duplicate key error mike browne 05/19/2013 07:59PM
Re: Can some please help me with a duplicate key error Rick James 05/19/2013 10:01PM
Re: Can some please help me with a duplicate key error mike browne 05/20/2013 06:44AM
Re: Can some please help me with a duplicate key error Rick James 05/20/2013 10:19PM
Re: Can some please help me with a duplicate key error mike browne 05/28/2013 08:38AM
Re: Can some please help me with a duplicate key error Peter Brawley 05/20/2013 10:54AM
Re: Can some please help me with a duplicate key error Peter Brawley 05/19/2013 11:34AM
Re: Can some please help me with a duplicate key error mike browne 05/19/2013 07:55PM
Re: Can some please help me with a duplicate key error Peter Brawley 05/19/2013 10:01PM
Re: Can some please help me with a duplicate key error mike browne 05/20/2013 06:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.