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.
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.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Patch is ok, but now the exported file is empty. It contains:
<?xml version="1.0" encoding="UTF-8"?>
<channel>
</item>
</channel>
Please post your debug log so I can see what query is being called. This could also mean you have not setup any fields in the Layout tab. Did you setup your template as explained in the Advanced order XML export tutorial?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log is in attachment.
I setup a very simplified configuration:
Header:
<?xml version="1.0" encoding="UTF-8"?>
<orders xmlns="urn:orders-schema">
Order:
<order>
<customer>
<address>[address_1]</address>
</customer>
<orderlines>
[orderlines]
</orderlines>
</order>
Orderline:
<orderline>
<description>[order_item_name]</description>
</orderline>
Footer:
</orders>
Fields are:
0 address_1
3 order_item_name
I tried to use shipping_address_1 instead address_1, but it fails too.
Hello,
That is indeed simple and I did the same setup to try the export here but it worked just fine as you can see I get this output
<?xml version="1.0" encoding="UTF-8"?>
<orders xmlns="urn:orders-schema">
<order>
<customer>
<address><![CDATA[PO Box 123]]></address>
</customer>
<orderlines>
<orderline>
<description><![CDATA[Jumper]]></description>
</orderline>
</orderlines>
</order>
</orders>
Your debug log is empty, howerver one thing that is interesting is that your fields are number 0 and 3. This seems to indicate there is an issue with the fields. You can try to remove all the fields from the template and then add them again. In my case this reads 1 address_1 and 2 order_item_name.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
I tried to set order columns, but file is always empty.
I tried to make simple Order (not advanced) export, but file is empty.
In my server log, there is the following warning:
stderr: PHP Warning: mysqli_fetch_object() expects parameter 1 to be mysqli_result, resource given in /var/www/[...]/administrator/components/com_csvi/helper/db.php on line 103
I attach CSVI log too. I ran the query in attachment and it return many results without errors.
Hello,
I think the problem is somewhere else. Go to System -> Global configuration -> Server and check your database setting. This must be mysqli. Notice the i at the end, if you have mysql then this should be changed.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Ok, with mysqli, order export (not advanced) runs!
I applied your suggested patch for orderadvanced.php, but advanced order export throws this error:
PHP Fatal error: Call to undefined method CsviHelperFileExportXmlCsvimproved::Order() in /var/www/[...]/administrator/components/com_csvi/addon/com_virtuemart/model/export/orderadvanced.php on line 735
Hello,
This issue is because the wrong XML option is being used. Go to the Advanced order template and save it again, after that run the export. Do you then still get the error?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Rolandd,
I tried as you suggest, but advanced order export doesn't run. The error is
stderr: PHP Fatal error: Call to undefined method CsviHelperFileExportXmlCsvimproved::Order() in /var/www/[...]/administrator/components/com_csvi/addon/com_virtuemart/model/export/orderadvanced.php on line 735
I look into CsviHelperFileExportXmlCsvimproved class, and it doesn't contain Order method!
How is possible?
Hello,
I look into CsviHelperFileExportXmlCsvimproved class, and it doesn't contain Order method!
That is correct because it should be using the class CsviHelperFileExportXmlOrderadvanced. Your template seems to store it as empty or as csvimproved. Can you go to Maintenance and backup your order advanced template? I will modify it and post it back for you to import and it should be OK to run then.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Michele,
Attached the XML file with the needed change. You can restore this template using the Maintenance menu. You probably want to rename the existing orderadvanced template to something else otherwise you get 2 templates with the same name.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Now, there is a new error:
stderr: PHP Fatal error: Cannot use object of type stdClass as array in /var/www/[...]/administrator/components/com_csvi/addon/com_virtuemart/model/export/orderadvanced.php on line 419
I presume this error is on 645, 653, 675 and 683 lines number, too.
A new error :-| Not sure what is different with your system compared to my system as I tried your template before sending it.
Can you open the template and save it again and see if you get the export or the old error again?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
I saved the template and... it's all ok! :woohoo: :woohoo: :woohoo:
Thank you so much.
Glad to hear is all OK. I am still surprised it wasn't working before. Can you make a new template for order advanced and see if that works or gives an error?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
It gives an error:
PHP Fatal error: Call to undefined method CsviHelperFileExportXmlCsvimproved::Order() in /var/www/[...]/administrator/components/com_csvi/addon/com_virtuemart/model/export/orderadvanced.php on line 735
By a summary analysis, I observe that in new template didn't set <export_site> value.
Correct analysis. Now I need a way to reproduce this. Would it be possible to private message me Joomla and FTP login details so I can check the issue on your server? Thanks.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
I sent you a private message.
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
Log in to reply to this topic.