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

jerad sloan Tue, 13 Mar 2007 15:39:27 -0800

thanks.

i had an extra index setup for one of my fields...i deleted it and itstarted 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 following

insert into tblvideoURL(videourl,userid,shortname,videourlcreated,videoURLcurrentstatus ,xmltitle ) values ('http://vids.myspace.com/index.cfm?fuseaction=vids.individual&videoid=1951753288',3,'MySpace',{ts'2007-03-13 15:04:01'},404 ,'Sporting Riff Raff - Absolutely Wasted(director unknown - hopefully Emily?!)' )



here is the Show Create Table

+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+| Table | CreateTable|+-------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+

| tblvideourl | CREATE TABLE `tblvideourl` (
  `videourlID` int(11) NOT NULL auto_increment,
  `videourl` varchar(255) default NULL,
  `videoID` int(11) default NULL,
  `userID` int(11) default NULL,
  `shortname` varchar(100) default NULL,
  `videourlcurrentstatus` int(11) default '200',
  `videocurrentstatusdate` datetime default NULL,
  `videoembedcode` mediumtext,
  `videourlcreated` datetime default NULL,
  `googledocID` varchar(50) default NULL,
  `googleembed` varchar(50) default NULL,
  `xmltitle` varchar(250) default NULL,
  `youtubevideoid` varchar(15) default '',
  `brightcovebctid` varchar(15) default '',
  `mtvvideoid` varchar(15) default '',
  `yahoovideoID` varchar(15) default '',
  `msnvideoID` varchar(50) default '',
  `videocID` varchar(15) default '',
  `myspacevideoid` varchar(15) default '',

`videoURLscore` int(3) unsigned zerofill NOT NULL default '000'COMMENT 'this is the calculated score for the link - some sort of"best link" type thing',

  `videoscrubrdirectURL` varchar(255) default '',
  `videoscrubrdirectURLstatus` int(4) default NULL,

`videoscrubrdirectURLstatusdate` timestamp NOT NULL default'0000-00-00 00:00:00' on update CURRENT_TIMESTAMP,

  `blastropagename` varchar(100) default '',

`needsreview` int(1) unsigned zerofill NOT NULL default '0'COMMENT '1 means it needs review...defaults to 0',`antvillelink` varchar(120) default '' COMMENT 'link to antvillepage regarding this video / link',

  PRIMARY KEY  (`videourlID`),
  UNIQUE KEY `videourl` (`videourl`),
  KEY `videoURLcurrentstatus` (`videourlcurrentstatus`),
  KEY `youtbuevideoid` (`youtubevideoid`),
  KEY `brightcovebctid` (`brightcovebctid`),
  KEY `blastropagename` (`blastropagename`),
  KEY `mtvvideoid` (`mtvvideoid`),
  KEY `videoID` (`videoID`),
  KEY `userID` (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |



any suggestions would be greatly appreciated.

thanks.
jerad

On Mar 8, 2007, at 8:41 AM, Brian 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 "
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 toindex andfinding a duplicate index key even though there is not a dupliatefield - isthere a 70 character limit on varchar unique indexes or somethingweird?.
this is an InnoDB table with 2 unique keys
and a few other keys...i'm assuming key 3 deals with this datasince it isone of the unique keys and it shows this data in the error...buthow do i
confirm which is 'key 3'?
i've been searching around and can't find any mention known issuesaround
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]

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

Reply via email to