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
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.individualvid' for key 2
when doing the following
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
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
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
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
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
