Duplicate Entry Error When uploading new products - 1062

Started by Adella Priscilla Pasos, Jan 28 2012, 15:44

products description myphp admin sql os commerce errors 1062 error

You cannot reply to this topic
Go to first unread post

1 reply to this topic

#1 Adella Priscilla Pasos

Community Member
2 posts

Real Name:Bob animal
Gender:Male

@Mention

Posted 28 January 2012, 15:44

I keep getting this error code when adding products, i reviewed myphpadmin to make ssure the products_id was set to auto_increment, which it was in products table and products_description table. I need help, i don't know what else to say. I've attached a screen shot of my settings. I really don't know what else to look for or what I can do. I emptied the sessions information, i'm unsure of how to fix this

1062 - Duplicate entry '1212-3' for key 1

insert into products_description (products_name, products_description, products_url, products_id, language_id) values ('', '', '', '1212', '3')

[TEP STOP

hope someone can help me.

Back to top

#2 geoffreywalton

Community Sponsor
7,731 posts

Real Name:Geoffrey Walton
Gender:Male
Location:Norfolk, UK (close to the centre of the universe)

@Mention

Posted 28 January 2012, 22:41

It looks to me as if you already have an entry in the products description file for the product with an id of 1212 and language 3.

Delete that record and try again.

HTH

G

Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile

Virus Threat Scanner
My Contributions
Basic install answers.
Click here for Contributions / Add Ons.
UK your site.
Site Move.
Basic design info.

For links mentioned in old answers that are no longer here follow this link Useful Threads.

If this post was useful, click the Like This button over there ======>>>>>.

Back to top

Back to Installation and Configuration · Next Unread Topic →