i think you are in fact duplicating an entry on the index, probably one of your indexes on that table is length restricted and that cause that 2 fields that as a whole are different, they are not to the index length.
My two cents. Carlos On 1/3/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I'm gettig it on browser after I run php code for adding new products. http://www.vernoncompany.com/screen/PrntScrn.gif > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
