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)
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
Thanks, it's working now!
Log in to reply to this topic.