Categories
View Replies (21)

Resolved SQL error message with order advanced export

  1. mmichele
    mmichele
  2. RO CSVI
  3. Monday, 27 July 2015
  4.  Subscribe via email
I follow the guide to set order advanced export, but I have this following error message:



Unknown column 'jos_users.id = user_info1.virtuemart_user_id' in 'on clause' SQL=SELECT `jos_virtuemart_orders`.`virtuemart_order_id`, `address_1`, `CodFiscalePIVA`, `order_item_name`, `order_item_sku` FROM `jos_virtuemart_orders` LEFT JOIN `jos_virtuemart_order_items` ON `jos_virtuemart_orders`.`virtuemart_order_id` = `jos_virtuemart_order_items`.`virtuemart_order_id` LEFT JOIN `jos_virtuemart_order_userinfos` AS `user_info1` ON `jos_virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id` LEFT JOIN `jos_virtuemart_orderstates` ON `jos_virtuemart_orders`.`order_status` = `jos_virtuemart_orderstates`.`order_status_code` LEFT JOIN `jos_virtuemart_product_manufacturers` ON `jos_virtuemart_order_items`.`virtuemart_product_id` = `jos_virtuemart_product_manufacturers`.`virtuemart_product_id` LEFT JOIN `jos_virtuemart_manufacturers` ON `jos_virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `jos_virtuemart_manufacturers`.`virtuemart_manufacturer_id` LEFT JOIN `jos_users` ON `jos_users`.`id = user_info1`.`virtuemart_user_id` LEFT JOIN `jos_virtuemart_countries` ON `jos_virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id` LEFT JOIN `jos_virtuemart_invoices` ON `jos_virtuemart_orders`.`virtuemart_order_id` = `jos_virtuemart_invoices`.`virtuemart_order_id` LEFT JOIN `jos_virtuemart_paymentmethods_it_it` ON `jos_virtuemart_orders`.`virtuemart_paymentmethod_id` = `jos_virtuemart_paymentmethods_it_it`.`virtuemart_paymentmethod_id` LEFT JOIN `jos_virtuemart_shipmentmethods_it_it` ON `jos_virtuemart_orders`.`virtuemart_shipmentmethod_id` = `jos_virtuemart_shipmentmethods_it_it`.`virtuemart_shipmentmethod_id`


Where have I wrong?
I use:
Joomla 3.4.3
CSVI Pro 6.0.1
Virtuemart 3.0.9

Thanks in advice.
0
Responses (21)
rolandd
rolandd
Accepted Answer Pending Moderation
Thanks, the problem has been identified and will be fixed in the next release of CSVI 6.
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
  • 2


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