Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help with - 1062 - Duplicate entry '1-1' for key 1


tot25

Recommended Posts

Posted

Hello,

When I try to add new products in my store I get the following message:

 

----

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

 

insert into products_description (products_name, products_description, products_url, products_id, language_id) values ('PoductTest', 'Test Product', '', '1', '1')

 

-----

 

The products are added but mixed in all categories.

This is fresh installation with only installed clear_db and easy populate.

 

What is the problem and how can I fix it?

 

Thanks for your help.

Posted

The clear_db contrib only clears the customers, products, and sessions tables.

 

I don't know if by 'products' they mean all tables that begin with 'products' or just the 'products' table.

 

Go to the db via phpmyAdmin and elect to "Empty" or "Truncate" all tables beginning with 'product' one table at a time. Don't select "Drop".

 

Vger

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...