Re: getting a " Duplicate entry" error when inserting a new record - but there is no duplicate record

thanks for the suggestions. doing the insert in the commandline gives the same error. i deleted all the other indexes except the one in question (just to see if it changed anything)...same error. did a check table (and a repair table and an optimize table) - no change. is it possible the

Re: getting a " Duplicate entry" error when inserting a new record - but there is no duplicate record

At 5:24 PM -0700 3/13/07, jerad sloan wrote: thanks for the quick reply. i want that to be unique so there is no way to insert the same URL more than once. there isn't a record with that URL...but it gives the error anyway...it seems to be just checking a portion of the entry i'm trying to in

Re: getting a " Duplicate entry" error when inserting a new record - but there is no duplicate record

thanks for the quick reply. i want that to be unique so there is no way to insert the same URL more than once. there isn't a record with that URL...but it gives the error anyway...it seems to be just checking a portion of the entry i'm trying to insert. i don't want uniqueness across a set

Re: getting a " Duplicate entry" error when inserting a new record - but there is no duplicate record

At 4:36 PM -0700 3/13/07, jerad sloan wrote: thanks. i had an extra index setup for one of my fields...i deleted it and it started working as expected...but now the same thing is happening again. i'm getting the error "Duplicate entry 'http://vids.myspace.com/index.cfm?fuseaction=vids.indivi

Re: getting a " Duplicate entry" error when inserting a new record - but there is no duplicate record

thanks. i had an extra index setup for one of my fields...i deleted it and it started working as expected...but now the same thing is happening again. i'm getting the error "Duplicate entry 'http://vids.myspace.com/index.cfm? fuseaction=vids.individual&vid' for key 2" when doing the followi

Re: getting a " Duplicate entry" error when inserting a new record - but there is no duplicate record

Jerad - First of all, please reply all with a SHOW CREATE TABLE of the table you're inserting the row into, so that we can identify the indexes you've established for the table. thanks, --bemansell On 3/7/07, jerad sloan <[EMAIL PROTECTED]> wrote: when i try to insert the string " http://vids.

getting a " Duplicate entry" error when inserting a new record - but there is no duplicate record

when i try to insert the string " http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=2012774576";, it returns "error : Duplicate entry ' http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=' for key 3" when i check the table and do a search for the string, there

Re: Duplicate entry error

Hello. > | 4.0.17-standard | It is an old version of MySQL which could contain lots of bugs. It is strongly recommended to upgrade to the latest release 4.1.12, or if it is impossible in your production environment to 4.0.24. Usually upgrade solves such kind of errors. Please, next

Re: Duplicate entry error

ag > > > -Original Message- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 30, 2005 3:20 PM > To: mysql@lists.mysql.com > Subject: Re: Duplicate entry error > > > Hello. > > Please examine your master's

RE: Duplicate entry error

in for your help and cooperation. Anurag -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Thursday, June 30, 2005 3:20 PM To: mysql@lists.mysql.com Subject: Re: Duplicate entry error Hello. Please examine your master's binary and slave's relay logs with

Re: Duplicate entry error

er old, check if the problem remains after upgrade. [EMAIL PROTECTED] wrote: > > Hi all, > I am getting duplicate entry error while inserting data in the table. > My table name is TEMP and it contains only one field which is primary key= > ,nt null as well as auto increm

Duplicate entry error

Hi all, I am getting duplicate entry error while inserting data in the table. My table name is TEMP and it contains only one field which is primary key ,nt null as well as auto increment . 050628 16:05:00 Slave: Error 'Duplicate entry '77' for key 1' on query 

Fw: Duplicate entry error -THANKS!

THANK_YOU! I was modifying entries for a joiner table without checking to see tif they were already present! > Subject: RE: Duplicate entry error?? > > > > Hi, > > > > You have a unique key defined which includes Ekey and another field (the > key > > 2 ment

Re: Duplicate entry error??

You have set EKey to be unique, so if you already have another row with EKey = 13, you cannot establish an additional row with the same key. (unique keys can be either set by primary key(), or unique()) .. Atle On Mon, 12 Feb 2001, Paul Wilkinson wrote: > Thanks in advance for your help! >

RE: Duplicate entry error??

MAIL PROTECTED]] Sent: Tuesday, 13 February 2001 10:39 To: Help MySQL List Subject: Duplicate entry error?? Thanks in advance for your help! How does one replace a single field value when the value repeats? I tryed the following and get an error message "Duplicate entry '88-252&#

Duplicate entry error??

Thanks in advance for your help! How does one replace a single field value when the value repeats? I tryed the following and get an error message "Duplicate entry '88-252' for key 2" UPDATE DKWords SET EKey='252' WHERE EKey='13' What is wrong? Paul -