ERROR 1062: Duplicate entry

2004-07-26 Thread Eli Shemer
details. mysql> create index url_site_idx on URL(Site(255)); ERROR 1062: Duplicate entry 'Transmeta unveils futuristic Crusoe chip ' for key 1 mysql> mysql> select version(); +-+ | version() | +-+ | 4.0.17-standard | +-+ 1 r

Re: Error: 1062 Duplicate Entry '252' for key 1

2004-01-29 Thread Mike Mapsnac
| Thanks From: "Jigal van Hemert" <[EMAIL PROTECTED]> To: "Mike Mapsnac" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Subject: Re: Error: 1062 Duplicate Entry '252' for key 1 Date: Thu, 29 Jan 2004 14:32:51 +0100 From: "Mike Mapsnac" <[EMAIL P

RE: Error: 1062 Duplicate Entry '252' for key 1

2004-01-29 Thread Mike Johnson
From: Mike Mapsnac [mailto:[EMAIL PROTECTED] > Thanks for explanation. > > But I don't insert anything at all to the SLAVE. It is 100%. > > Can the problem be problem be relative to Mysql 4.0.13 ? > > Thanks Out of curiosity, what's the data type of this column? -- Mike Johnson Web Develop

Re: Error: 1062 Duplicate Entry '252' for key 1

2004-01-29 Thread Mike Mapsnac
Thanks for explanation. But I don't insert anything at all to the SLAVE. It is 100%. Can the problem be problem be relative to Mysql 4.0.13 ? Thanks From: "Jigal van Hemert" <[EMAIL PROTECTED]> To: "Mike Mapsnac" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]&g

Re: Error: 1062 Duplicate Entry '252' for key 1

2004-01-29 Thread Jigal van Hemert
From: "Mike Mapsnac" <[EMAIL PROTECTED]> > The slave server stop working today and I looked to the error > log and the the error message is > Error: 1062 Duplicate Entry '252' for key 1 > > And than it shows the query and time when it happens. My >

Error: 1062 Duplicate Entry '252' for key 1

2004-01-29 Thread Mike Mapsnac
Hello The slave server stop working today and I looked to the error log and the the error message is Error: 1062 Duplicate Entry '252' for key 1 And than it shows the query and time when it happens. My question is why no error messages on master server just on slave server? As I

Re: MySQL ERROR 1062: Duplicate entry '1' for key 1

2002-07-29 Thread Dan Nelson
In the last episode (Jul 29), Prince Chidi Ajuzie said: > MySQL Question > I run sql version 3.23.42. > > LOAD DATA INFILE "/usr/lists" INTO TABLE lists; > ERROR 1062: Duplicate entry '1' for key 1 > > Please how do i run this successfully. Ive tried th

Re: MySQL ERROR 1062: Duplicate entry '1' for key 1

2002-07-29 Thread Victoria Reznichenko
Prince, Monday, July 29, 2002, 12:58:22 PM, you wrote: PCA> MySQL Question PCA> I run sql version 3.23.42. PCA> LOAD DATA INFILE "/usr/lists" INTO TABLE lists; PCA> ERROR 1062: Duplicate entry '1' for key 1 PCA> Please how do i run this successfully. Ive t

MySQL ERROR 1062: Duplicate entry '1' for key 1

2002-07-29 Thread Prince Chidi Ajuzie
MySQL Question I run sql version 3.23.42. LOAD DATA INFILE "/usr/lists" INTO TABLE lists; ERROR 1062: Duplicate entry '1' for key 1 Please how do i run this successfully. Ive tried the REPLACE opt

Re: Error 1062: Duplicate entry '127' for Key 1

2002-01-17 Thread Fred van Engen
It's probably a tinyint field which won't go higher than 127. Fred. On Thu, Jan 17, 2002 at 02:40:54PM +0100, Thibaut Allender wrote: > > an index cannot be null > > you should do this : > > insert into equipment (id,description) values ('','test data'); > > regards > > At 14:27 17/01/2002

Re: Error 1062: Duplicate entry '127' for Key 1

2002-01-17 Thread Thibaut Allender
an index cannot be null you should do this : insert into equipment (id,description) values ('','test data'); regards At 14:27 17/01/2002, you wrote: >database,sql,query,table > >If you just reply to this message, and include the entire text of it in the >reply, your reply will go through. How

Error 1062: Duplicate entry '127' for Key 1

2002-01-17 Thread Gary Smith
database,sql,query,table If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for