(SOLVED) an error occurred while creating object attribute (Duplicate entry '335-1' for key 1)

[Torbz]

An error occurred while creating object attribute (Duplicate entry '335-1' for key 1)

Having problems when creating attributes for a newly created group.

I'm assuming this error message has something to do with an attempt to write to the database that is being scuppered by an already existing entry.

Does anyone have any ideas as to why this might be happening and how to solve the problem?

I have the skills to look up the entry in the database and fiddle, but I don't immediately know to what the quoted number refers nor what is meant by key 1.

[Torbz]

Bump! Anyone from the dev team able to shed light on this?

[rocky]

I have no idea what would cause it. The only solution would be to log in to phpMyAdmin and search tables starting with ps_attribute for rows with ID 335 and delete them.

[Torbz]

Sussed out what it was - I used a migration script from Tomer to move an OSCommerce catalogue across into PS - which largely worked, except it screwed up the auto-increment in the ps_attribute_lang and ps_attribute tables, so I've raised the last entry to a higher number than anything else existing in the the DB and it creates new groups and attributes without kicking out this error.

So it was the migration script at fault.

[tomerg3]

Now that I know of it, a fix is in the works, a new version will be released soon, which will set all the auto-increment value correctly, without having to re-import.

[J.Sahu]

This problem occurs if you have not correctly added the attribute and try to add the combinations.

It's very simple to solve if you haven't added many attributes.

First deselect the auto increment of "id_attribute" field in the "ps_attribute" table then you can delete all values of below tables and again select the auto increment of "id_attribute" table.

• ps_attribute
  
• ps_attribute_group
  
• ps_attribute_group_lang
  
• ps_attribute_group_shop
  
• ps_attribute_impact
  
• ps_attribute_lang
  
• ps_attribute_shop
  

Hope this will work for you.

[J.Sahu]

This solution was for old prestashop method i am not sure it will work on new.