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
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
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
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
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
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.
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
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
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
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
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
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
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
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!
>
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
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
-
16 matches
Mail list logo