Duplicate Key Error on non_unique key in large table

2002-09-24 Thread Calvert, Jeremy
Hi everybody. I just joined since [EMAIL PROTECTED] had the closest hits for my question via google (entries from Oct. 2000). That list seems to no longer exist and this seems to be the most specific applicable list. My problem: I get the following MySQL error using Perl DBI. Error: Duplic

re: Duplicate key error

2002-09-23 Thread Egor Egorov
Graham, Sunday, September 22, 2002, 3:15:23 PM, you wrote: GH> I am aware that this is an error of my own making, however . . . GH> I am unable to install my sql because the scipt fails with GH> a duplicate key error GH> Preparing db table GH> Preparing host table GH> Prepa

Duplicate key error

2002-09-22 Thread Graham Hodges
I am aware that this is an error of my own making, however . . . I am unable to install my sql because the scipt fails with a duplicate key error Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table

Re: duplicate key error on autoincrement field while inserting

2001-04-24 Thread Dan Shapella
oincrement problems at virtually the same time. And this is the only app running on this system. Why did MySql decide these 2 keys already exist when in fact they don't? >From: Gerald Clark <[EMAIL PROTECTED]> >To: Dan Shapella <[EMAIL PROTECTED]> >CC: [EMAIL PROTECTED]

Re: duplicate key error on autoincrement field while inserting

2001-04-24 Thread Gerald Clark
records into one of 2 different tables. > The other day, an insert attempt on one of the tables failed with a > duplicate key error on key 1, an autoincrement field. About a minute later, > an insert attempt on the other table failed similarly. But, when a SELECT > was done on each ta

duplicate key error on autoincrement field while inserting

2001-04-24 Thread Dan Shapella
I have a weird one here. I have an application that inserts records into one of 2 different tables. The other day, an insert attempt on one of the tables failed with a duplicate key error on key 1, an autoincrement field. About a minute later, an insert attempt on the other table failed