Import Product Data Duplicate Error

I get the following message when importing into CS-Cart:



[HTML]



Importing data

Updating Products…315. Updating links… OK

Updating Products…316.



Database error: Duplicate entry ‘2982-EN’ for key 1 (1062)

Invalid query: INSERT INTO cscart_product_option_variants_descriptions (variant_name, variant_id, lang_code) VALUES (‘3 to 5 years’, ‘2982’, ‘EN’)



Backtrace:

File: /home/cuccikuc/public_html/core/fn.database.php

Line: 310

Function: db_error

File: /home/cuccikuc/public_html/core/fn.catalog.php

Line: 3279

Function: db_query

File: /home/cuccikuc/public_html/schemas/exim/products.php

Line: 742

Function: fn_update_product_option

File: /home/cuccikuc/public_html/controllers/admin/exim.php

Line: 486

Function: fn_exim_set_product_options

File: /home/cuccikuc/public_html/controllers/admin/exim.php

Line: 129

Function: fn_import

File: /home/cuccikuc/public_html/core/fn.control.php

Line: 530

Function: include

File: /home/cuccikuc/public_html/core/fn.control.php

Line: 393

Function: fn_run_controller

File: /home/cuccikuc/public_html/my_admin.php

Line: 27

Function: fn_dispatch



[/HTML]



I have tried removing the dupicate entry from the row in the “cscart_product_option_variants_descriptions” table but it then errors on the next row.



Can anyone help?

You have a ground of product options that have duplicated descriptions. I would anticipate that there is another “2982-EN” key located within the same portion of the DB.



Since it is apparent that you are using CSV to import, you’ve screwed up the product options somewhere.

Hi i need a help quickly. when i add a product it happens that error. what can i do .



Database error: Duplicate entry ‘6262-EN’ for key 1 (1062)

Invalid query: INSERT INTO cscart_product_descriptions (product, full_description, page_title, meta_description, meta_keywords, search_words, short_description, age_warning_message, product_id, lang_code) VALUES (‘adsdas’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘’, ‘6262’, ‘EN’)



Backtrace:

File: /var/www/vhosts/xxxx.com/httpdocs/core/fn.database.php

Line: 310

Function: db_error

File: /var/www/vhosts/xxxx.com/httpdocs/controllers/admin/products.php

Line: 1168

Function: db_query

File: /var/www/vhosts/xxxx.com/httpdocs/controllers/admin/products.php

Line: 42

Function: fn_update_product

File: /var/www/vhosts/xxxx.com/httpdocs/core/fn.control.php

Line: 529

Function: include

File: /var/www/vhosts/xxxx.com/httpdocs/core/fn.control.php

Line: 392

Function: fn_run_controller

File: /var/www/vhosts/xxxx.com/httpdocs/sepetadmin.php

Line: 27

Function: fn_dispatch

i add 500 product and something is wrong then i delete directly from database so database error from this. Thanks.