News:

Support the VirtueMart project and become a member

Main Menu

Duplicate product error

Started by pm4698, July 28, 2015, 18:44:22 PM

Previous topic - Next topic

pm4698

Hello there,

I use joomla 2.5 and vm 2.6.10.

When i go to some products to change something and click save i get example code:

vmError: Product store TableProducts: :store failed
Duplicate entry '1087-' for key 'PRIMARY' SQL=UPDATE `prefix_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='23400154',`product_gtin`='',`product_mpn`='',`product_weight`='207.5000',`product_weight_uom`='KG',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='0',`product_ordered`='2',`low_stock_notification`='0',`product_available_date`='0001-01-01 00:00:00',`product_availability`='24h.gif',`product_special`='0',`pordering`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`created_on`='0001-01-01 00:00:00',`modified_on`='2015-07-28 16:07:42',`modified_by`='239',`id`='1087',`hits`=NULL,`locked_on`='0',`locked_by`='0' WHERE `virtuemart_product_id`='1349'


If i go in prefix_products_table i see the product but i cannot find any duplicate when searching with ID value or virtuemart_product_id value or SKU. Also inside this table the product with SKU 23400154, has id=1095 and virtuemart_product_id=1349

If know i go prefix_products_el_gr table (my language's products table) if i search the virtuemart_product_id=1349 i find that in that row, product has id=1087. So, i don't know where the duplication is. If i search prefix_virtuemart_products and also prefix_virtuemart_products_el_gr tables i don't find duplicates of this product.

Any suggestions?

Thank you in advance