Hallo,
Purchased CSVI today and ran into a snag trying to run my last export. First my details:
2016-01-25 04:13:34 0 [DEBUG] CSVI Pro Version: 6.4.3
2016-01-25 04:13:34 0 [DEBUG] Joomla! version: 3.4.8
2016-01-25 04:13:34 0 [DEBUG] PHP version: 5.6.14-1
Error
Column 'email' in field list is ambiguous SQL=SELECT `email`, `first_name`, `last_name`, `address_1`, `address_2`, `city`, `ah_virtuemart_userinfos`.`virtuemart_state_id`, `zip`, `phone_1`, `activation` FROM `ah_virtuemart_userinfos` LEFT JOIN `ah_virtuemart_vmusers` ON `ah_virtuemart_vmusers`.`virtuemart_user_id` = `ah_virtuemart_userinfos`.`virtuemart_user_id` LEFT JOIN `ah_virtuemart_vmuser_shoppergroups` ON `ah_virtuemart_vmuser_shoppergroups`.`virtuemart_user_id` = `ah_virtuemart_userinfos`.`virtuemart_user_id` LEFT JOIN `ah_virtuemart_vendors` ON `ah_virtuemart_vendors`.`virtuemart_vendor_id` = `ah_virtuemart_vmusers`.`virtuemart_vendor_id` LEFT JOIN `ah_virtuemart_shoppergroups` ON `ah_virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = `ah_virtuemart_vmuser_shoppergroups`.`virtuemart_shoppergroup_id` LEFT JOIN `ah_users` ON `ah_users`.`id` = `ah_virtuemart_userinfos`.`virtuemart_user_id` WHERE `ah_virtuemart_userinfos`.`address_type` = 'BT' AND `ah_users`.`block` = 1 AND `ah_users`.`activation` = '' GROUP BY `email`,`first_name`,`last_name`,`address_1`,`address_2`,`city`,`zip`,`phone_1`,`activation`
Looking through the rest of the debug info doesn't show any direct errors except for the steps taken by CSVI (for instance
2016-01-25 04:13:34 0 [DEBUG] Export field: email
2016-01-25 04:13:34 0 [DEBUG] Export field: first_name
2016-01-25 04:13:34 0 [DEBUG] Export field: last_name
2016-01-25 04:13:34 0 [DEBUG] Export field: address_1
2016-01-25 04:13:34 0 [DEBUG] Export field: address_2
2016-01-25 04:13:34 0 [DEBUG] Export field: city
2016-01-25 04:13:34 0 [DEBUG] Export field: state_name
2016-01-25 04:13:34 0 [DEBUG] Export field: zip
2016-01-25 04:13:34 0 [DEBUG] Export field: phone_1
2016-01-25 04:13:34 0 [DEBUG] Export field: activation )
Those are the only fields I'm trying to export and also the last part I would need CSVI for as I'm finally moving on to better pastures (Magento). Anyway, the (SQL) error above is what I get when I try to run a customer export. Has anyone experienced this and if so, any tips?
Any help would be greatly appreciated.
- foomandingo
- RO CSVI
- Monday, 25 January 2016
- 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!