Categories
View Replies (4)

Resolved Export SQL error on customers (email)

  1. foomandingo
    foomandingo
  2. RO CSVI
  3. Monday, 25 January 2016
  4.  Subscribe via email
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.
0
Responses (4)
foomandingo
foomandingo
Accepted Answer Pending Moderation
Disregard. Added switch for email in ./addon/com_virtuemart/model/export/userinfo.php and all is well now.
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 2
foomandingo
foomandingo
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 4
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!