List:General Discussion« Previous MessageNext Message »
From:Carlos Proal Date:January 4 2007 1:08am
Subject:Re: Error: Duplicate entry 'xxxx-L' for key 6
View as plain text  
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, afan@stripped <afan@stripped> 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: afan@stripped [mailto:afan@stripped]
> >> Sent: Wednesday, January 03, 2007 4:10 PM
> >> To: Jerry Schwartz
> >> Cc: mysql@stripped
> >> 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: afan@stripped [mailto:afan@stripped]
> >> >> Sent: Wednesday, January 03, 2007 3:45 PM
> >> >> To: mysql@stripped
> >> >> 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=1
> >> >>
> >> >>
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>

Thread
Error: Duplicate entry 'xxxx-L' for key 6afan3 Jan
  • RE: Error: Duplicate entry 'xxxx-L' for key 6Jerry Schwartz3 Jan
    • RE: Error: Duplicate entry 'xxxx-L' for key 6afan3 Jan
      • RE: Error: Duplicate entry 'xxxx-L' for key 6Jerry Schwartz3 Jan
        • RE: Error: Duplicate entry 'xxxx-L' for key 6afan3 Jan
          • Re: Error: Duplicate entry 'xxxx-L' for key 6Carlos Proal4 Jan
RE: Error: Duplicate entry 'xxxx-L' for key 6Imran Chaudhry4 Jan
  • RE: Error: Duplicate entry 'xxxx-L' for key 6afan4 Jan