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.
Disregard. Added switch for email in ./addon/com_virtuemart/model/export/userinfo.php and all is well now.
Hello,
Thank you for reporting this issue. However I can't replicate the issue. Even when I run your query, I don't get the email column problem. The error means you have the email column in a table other than the ha_users table.
Is this a customization you have done?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hoi Roland,
No customizations - I do actually have the email in the users table. The query is supposed to be on VM customers which was taking the data from the vm user_infos table. Like I said, the problem was solved when I added the switch and all customer data exported without a hitch. I didn't see anyone else complain about it so it must be an isolated issue.
Hello,
Correct the email field is in the users table, that should be the only table. The query linsk the vm user_infos table to the users table to get some extra information for those people who need that.
Indeed, no one else has the issue nor I can reproduce it. Since you were able to fix it, all is good.
The last thing I want to share with you is, in case you didn't, you can make the customization in an override. This way on an update, it won't get lost.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.