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]
