I get an error on exporting user info:
Column 'email' in field list is ambiguous SQL=SELECT `zxvf_virtuemart_userinfos`.`first_name`, `zxvf_virtuemart_userinfos`.`middle_name`, `zxvf_virtuemart_userinfos`.`last_name`, `email` FROM `zxvf_virtuemart_userinfos` LEFT JOIN `zxvf_virtuemart_vmusers` ON `zxvf_virtuemart_vmusers`.`virtuemart_user_id` = `zxvf_virtuemart_userinfos`.`virtuemart_user_id` LEFT JOIN `zxvf_virtuemart_vmuser_shoppergroups` ON `zxvf_virtuemart_vmuser_shoppergroups`.`virtuemart_user_id` = `zxvf_virtuemart_userinfos`.`virtuemart_user_id` LEFT JOIN `zxvf_virtuemart_vendors` ON `zxvf_virtuemart_vendors`.`virtuemart_vendor_id` = `zxvf_virtuemart_vmusers`.`virtuemart_vendor_id` LEFT JOIN `zxvf_virtuemart_shoppergroups` ON `zxvf_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = `zxvf_virtuemart_vmuser_shoppergroups`.`virtuemart_shoppergroup_id` LEFT JOIN `zxvf_users` ON `zxvf_users`.`id` = `zxvf_virtuemart_userinfos`.`virtuemart_user_id` GROUP BY `email`
My template setting:
Action = Export
Component = Virtuemart
Operation = Users Info
I tried Component = Joomla Users but that also results in errors.
Any ideas on how to fix this? Thnx!