1. Julius.Piwowar
  2. RO CSVI
  3. Friday, 18 September 2015
  4.  Subscribe via email
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)
Accepted Answer Pending Moderation
Hello Julius,

I found the typo, if you set the option Parent Product Only to No, the export will run. The fix will be included in the next release. If you are interested I can let you know what to change to fix this, otherwise the next release will include it.
Kind regards,

RolandD

=========================
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. # 1
Accepted Answer Pending Moderation
Thanks, it's working now!
  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!