RE: Error: Duplicate entry 'xxxx-L' for key 6

["Jerry Schwartz" <jschwartz@xxxxxxxxxxxxxxxx>]

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: afan@xxxxxxxx [mailto:afan@xxxxxxxx]
> Sent: Wednesday, January 03, 2007 3:45 PM
> To: mysql@xxxxxxxxxxxxxxx
> 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/mysql?unsub=jschwartz@xxxxxxxxxxxxxxxx
>
>




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx