1062 - Duplicate entry '' for key 2

[mrgtec]

Hi,

 

I am trying to add a product in the admin panel of my site, & I keep getting this error -

 

1062 - Duplicate entry '' for key 2

 

insert into products (products_quantity, products_model, products_upc, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added) values ('63', '*******', '', '****', null, '***.*', '1', '1', '274', '*******.jpg', now())

 

[TEP STOP]

 

I do not know what it means or how to fix it.

 

I stared (******) out some of the info b/c the sites not opened yet.

 

Please help me fix the error.

 

Thank you,

Michael

[mrgtec]

^bump^

[Jan Zonjee]

I am trying to add a product in the admin panel of my site, & I keep getting this error -

 

1062 - Duplicate entry '' for key 2

 

insert into products (products_quantity, products_model, products_upc, products_price, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id, products_image, products_date_added) values ('63', '*******', '', '****', null, '***.*', '1', '1', '274', '*******.jpg', now())

Bumping is not allowed according to the forum rules and within the hour is totally unacceptable :angry:

 

Looks like you added some contribution that added a field called products_upc and that to make it a unique field added a key for that. Now you already seem to have added a product without products_upc filled in so MySQL tells you now you can't do that a second time.