Categories
View Replies (2)

Resolved Duplicate entry '268' for key 'PRIMARY'

  1. yourgeek
    yourgeek
  2. RO CSVI
  3. Wednesday, 09 May 2018
  4.  Subscribe via email
Hi,
i am trying to make an import but i get the following error in the process 



Duplicate entry '268' for key 'PRIMARY' SQL=UPDATE `a9jen_virtuemart_products` SET `virtuemart_product_id`='268',`virtuemart_vendor_id`='1',`product_parent_id`='678',`product_gtin`='',`product_mpn`='',`product_weight_uom`='KG',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='2015-04-27 00:00:00',`product_availability`='',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_params`='min_order_level=\"1\"|max_order_level=\"0\"|step_order_level=\"1\"|product_box=\"0\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-27 08:31:23',`created_by`='876',`modified_on`='2018-05-09 07:47:54',`modified_by`='990',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='KLC12-2158'


My versions are:
Joomla 3.4.8
Virtuemart 3.0.10
CSVI 6.6.4
0
Responses (2)
yourgeek
yourgeek
Accepted Answer Pending Moderation
Hi,
you are right there are products with same SKU.

Thank you
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You seem to have two records in `a9jen_virtuemart_products` table with same virtuemart_product_id value 268. Not sure if these records are having the same product_sku . You can check that by going to VirtueMart product page and in the search type KLC12-2158. How many records you see?
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!