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.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 is no match...it seems that they index is not using the full field to index and finding a duplicate index key even though there is not a dupliate field - is there a 70 character limit on varchar unique indexes or something weird?. this is an InnoDB table with 2 unique keys and a few other keys...i'm assuming key 3 deals with this data since it is one of the unique keys and it shows this data in the error...but how do i confirm which is 'key 3'? i've been searching around and can't find any mention known issues around this. any help/suggestions would be greatly appreciated. thanks, jerad
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]