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

2007-03-14 Thread jerad sloan
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 insert. i

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

2007-03-13 Thread jerad sloan
Mansell wrote: 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

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

2007-03-13 Thread jerad sloan
: 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

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

2007-03-07 Thread jerad sloan
when i try to insert the string http://vids.myspace.com/index.cfm?fuseaction=vids.individualvideoid=2012774576;, it returns error : Duplicate entry ' http://vids.myspace.com/index.cfm?fuseaction=vids.individualvideoid=' for key 3 when i check the table and do a search for the string, there is