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.