Where is the error message itself coming from? Is MySQL itself generating any error? I ask because that error message shouldn't be coming from MySQL.
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 4:10 PM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: RE: Error: Duplicate entry 'xxxx-L' for key 6 > > Yes, it's custom made app, written in php. > The code/query is really very simple: > > INSERT INTO products > (prod_no, prod_name, prod_description, prod_colors, prod_includes, > prod_catalog, prod_supplier, prod_start_date, prod_end_date, > prod_status) > VALUES > ('H846', 'Lavender Peak Purse', 'Large main top load opening for easy > access, additional slim detachable strap for hands-free carrying, > 420D/PVC backed lining, comfortable, long, easy-carry handles. > Dimensions: 12 inches L X 4 inches W X 7.75 inches H.', '03 > Blk, 04 Brn, > 05 Clay', 'Included one location debossed imprint. Die/setup > $130.00(a) > Second location $6.00(a)', '2007 Canyon Outback', 'Canyon Outback', > '0000-00-00', '0000-00-00', 'new' ) > > > Duplicate entry 'Lavender Peak Purse-L' for key 6 > > Nothing special. > > :( > > > > 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]
