Hey,
I tried to export the field "product_name" from Virtuemart and am getting the following error message:
Error
Unknown column 'aw2hd_virtuemart_products.product_parent_id = 0' in 'where clause' SQL=SELECT `aw2hd_virtuemart_products`.`virtuemart_product_id`, `aw2hd_virtuemart_products`.`product_parent_id` FROM `aw2hd_virtuemart_products` LEFT JOIN `aw2hd_virtuemart_product_prices` ON `aw2hd_virtuemart_products`.`virtuemart_product_id` = `aw2hd_virtuemart_product_prices`.`virtuemart_product_id` LEFT JOIN `aw2hd_virtuemart_product_manufacturers` ON `aw2hd_virtuemart_products`.`virtuemart_product_id` = `aw2hd_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `aw2hd_virtuemart_manufacturers` ON `aw2hd_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `aw2hd_virtuemart_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `aw2hd_virtuemart_product_categories` ON `aw2hd_virtuemart_products`.`virtuemart_product_id` = `aw2hd_virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `aw2hd_virtuemart_currencies` ON `aw2hd_virtuemart_currencies`.`virtuemart_currency_id` = `aw2hd_virtuemart_product_prices`.`product_currency` LEFT JOIN `aw2hd_virtuemart_product_shoppergroups` ON `aw2hd_virtuemart_product_shoppergroups`.`virtuemart_product_id` = `aw2hd_virtuemart_products`.`virtuemart_product_id` WHERE `aw2hd_virtuemart_products`.`product_parent_id = 0` AND (`aw2hd_virtuemart_product_prices`.`virtuemart_shoppergroup_id` = '0' OR `aw2hd_virtuemart_product_prices`.`virtuemart_shoppergroup_id` IS NULL)
- Julius.Piwowar
- RO CSVI
- Friday, 18 September 2015
- Subscribe via email
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!