Are you using a custom-written application to do the loading? If so, what language is it written in? I suspect that some of your variables are getting clobbered by a bad subscript, bad pointer, so something like that.
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 03, 2007 3:45 PM > To: mysql@lists.mysql.com > Subject: Error: Duplicate entry 'xxxx-L' for key 6 > > Hi, > While we were using old hosting company (15 days ago) on php > 4.3.4/mysql > 4.x based Linux server, the application I wrote to upload new > products i > MySQL was working fine. > After we moved now I'm getting strange error I can't explain. > I think it's > caused by moving to mysql 5. > For example: in the application csv file is uploaded to the > server, then > it reads product no. from product row and search if such > exosts in DB. If > yes, add prod. number to message that will list all products > that admin > tried to upload but they already exists. > But, I'll sometimes get the error message, e.g.: > Duplicate entry 'Lavander Peak Purse-L' fo r key 6 > The thing I don't understand is 'Lavander Peak Purse' (without -L) is > product name and it's not index nor unique?!? And there is no such a > product in DB?!? > Why is '-L' added to the products? What does it mean? What's key 6? > > I tried to find answer on mysql.com but only think I found is > > Error: 1062 SQLSTATE: 23000 (ER_DUP_ENTRY) > Message: Duplicate entry '%s' for key %d > > > CREATE TABLE `web_products` ( > `prod_id` int(8) unsigned NOT NULL auto_increment, > `prod_no` varchar(50) NOT NULL default '', > `prod_name` varchar(255) NOT NULL default '', > `prod_description` text, > `prod_colors` text, > `prod_includes` text, > `prod_catalog` varchar(45) default NULL, > `prod_status` enum('hidden','live','new') NOT NULL default 'new', > `prod_supplier` varchar(45) default NULL, > `prod_start_date` date default '0000-00-00', > `prod_end_date` date default '0000-00-00', > `prod_featured` enum('0','1') default NULL, > `on_sale` enum('Yes','No') NOT NULL default 'No', > PRIMARY KEY (`prod_id`), > UNIQUE KEY `prod_no` (`prod_no`), > KEY `products_index1` (`prod_status`), > KEY `products_index2` (`prod_start_date`,`prod_end_date`), > KEY `on_sale` (`on_sale`), > FULLTEXT KEY `prod_search` (`prod_name`,`prod_description`), > FULLTEXT KEY `prod_no_2` (`prod_no`) > ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6151 ; > > > Thanks for any help > > -afan > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
