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
Hello,

You are not doing anything wrong, there is a typing mistake in the order advanced file. Find attached the patch file that fixes this. After you load the patch file you can run the export again.

Let me know how it goes.
Attachments (1)
patch_orderadvanced_20150727.zip
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. # 21
  • Page :
  • 1
  • 2


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