J 3.4
VM 3.0.6.2
CSVI Pro 6 beta 3
just making some tests, I was trying to export virtuemart_product_id with any second column and I'm receiving following error:
Unknown column 'km_virtuemart_products.virtuemart_product_id' in 'where clause' SQL=SELECT `category_child_id` FROM `km_virtuemart_category_categories` WHERE `category_parent_id` IN (498) AND km_virtuemart_products.virtuemart_product_id IN (6082) GROUP BY `category_child_id`
logs:
Date Time Line Action Comment
Processed 10 lines
2015-03-20 18:07:13 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2015-03-20 18:07:13 0 [QUERY] SELECT csvi_log_id FROM km_csvi_logs ORDER BY csvi_log_id
2015-03-20 18:07:14 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2015-03-20 18:07:14 0 [QUERY] SELECT csvi_log_id FROM km_csvi_logs ORDER BY csvi_log_id
2015-03-20 18:07:14 0 [DEBUG] COM_CSVI_EXPORT_QUERY
2015-03-20 18:07:14 0 [QUERY] SELECT `category_child_id` FROM `km_virtuemart_category_categories` WHERE `category_parent_id` IN (498) GROUP BY `category_child_id`
2015-03-20 18:07:14 0 [DEBUG] COM_CSVI_EXPORT_QUERY
2015-03-20 18:07:14 0 [QUERY] SELECT p.virtuemart_product_id FROM km_virtuemart_products p LEFT JOIN km_virtuemart_product_categories x ON p.virtuemart_product_id = x.virtuemart_product_id WHERE x.virtuemart_category_id IN ('498')
2015-03-20 18:07:14 0 [DEBUG] COM_CSVI_EXPORT_QUERY
2015-03-20 18:07:14 0 [QUERY] SELECT p.virtuemart_product_id FROM km_virtuemart_products p WHERE p.product_parent_id IN ('6082')
Best regards,
Chris