Categories
View Replies (1)

Resolved Export Users: virtuemart_userinfo.name error

  1. Donnerflug
    Donnerflug
  2. RO CSVI
  3. Monday, 07 November 2016
  4.  Subscribe via email
Hello,

get this error when trying export:

Fehler
Unknown column '#__virtuemart_userinfos.name' in 'field list' SQL=SELECT `activation`, `address_1`, `address_2`, `address_type`, `address_type_name`, `#__virtuemart_userinfos`.`agreed`, `block`, `city`, `company`, `#__virtuemart_userinfos`.`virtuemart_country_id`, `#__virtuemart_userinfos`.`created_by`, `#__virtuemart_userinfos`.`created_on`, `customer_note`, `customer_number`, `email`, `fax`, `first_name`, `#__virtuemart_userinfos`.`first_name`, `#__virtuemart_userinfos`.`middle_name`, `#__virtuemart_userinfos`.`last_name`, `grade`, `#__users`.`id`, `lastResetTime`, `lastvisitDate`, `last_name`, `#__virtuemart_userinfos`.`locked_by`, `#__virtuemart_userinfos`.`locked_on`, `middle_name`, `#__virtuemart_userinfos`.`modified_by`, `#__virtuemart_userinfos`.`modified_on`, `#__virtuemart_userinfos`.`name`, `otep`, `otpKey`, `params`, `password`, `phone_1`, `phone_2`, `registerDate`, `requireReset`, `resetCount`, `sendEmail`, `shipping_mail`, `shopper_group_name`, `#__virtuemart_userinfos`.`virtuemart_state_id`, `title`, `tos`, `#__virtuemart_userinfos`.`virtuemart_user_id`, `username`, `user_is_vendor`, `vendor_name`, `virtuemart_paymentmethod_id`, `virtuemart_shipmentmethod_id`, `virtuemart_state_id`, `virtuemart_userinfo_id`, `#__virtuemart_vmusers`.`virtuemart_vendor_id`, `zip` FROM `#__virtuemart_userinfos` LEFT JOIN `#__virtuemart_vmusers` ON `#__virtuemart_vmusers`.`virtuemart_user_id` = `#__virtuemart_userinfos`.`virtuemart_user_id` LEFT JOIN `#__virtuemart_vmuser_shoppergroups` ON `#__virtuemart_vmuser_shoppergroups`.`virtuemart_user_id` = `#__virtuemart_userinfos`.`virtuemart_user_id` LEFT JOIN `#__virtuemart_vendors` ON `#__virtuemart_vendors`.`virtuemart_vendor_id` = `#__virtuemart_vmusers`.`virtuemart_vendor_id` LEFT JOIN `#__virtuemart_shoppergroups` ON `#__virtuemart_shoppergroups`.`virtuemart_shoppergroup_id` = `#__virtuemart_vmuser_shoppergroups`.`virtuemart_shoppergroup_id` RIGHT JOIN `#__users` ON `#__users`.`id` = `#__virtuemart_userinfos`.`virtuemart_user_id` WHERE #__users.id NOT IN ('179','180','181')

Kind regards,

Teresa
0
Responses (1)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Teresa,

Hm, I see that VirtueMart has removed the name field from the userinfos table. You can remove this field from your template and use the full_name field instead to get a full name.
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. # 1
  • Page :
  • 1


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