Resolved Export to email fails after update to joomla 3.5.1

Seems I skipped the first "view files",

Regards

Hello,

when you click in view files and download you download 6.5.4 instead.

I don't see that happen, I am getting the 6.5.5 package. Downloaded from this page.

Thanks, works fine now.

I meant that if you go to the download section in your website although 6.5.5 is described when you click in view files and download you download 6.5.4 instead.

Regards

Hello,

We seem to have found the download not working at about the same time as I just fixed it. Please use the attached patch file. This also comes with better error handling for the email. Just in case

BTW version in downloads is 6.5.4 in the file where vm plugin is 6.5.5

Not sure what you mean by that because CSVI 6.5.5 is on the download page as well. Later today I will release version 6.5.6 if nothing else comes up.

Hello again

The patch seems to affect the export to CSV.

The csv file is not generated, there is no error but it doesnt appear to download and open:

The log of one of this failed exports:

Detalles

Fecha 	2016-04-07 09:17:58 UTC

Software 	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Fecha 	Tiempo 	Línea 	Acción 	Comentario

Procesadas 85 líneas

2016-04-07 	09:17:58 	0 	[DEBUG] 	Clean up old logs. Found 25 logs and threshold is 25 logs

2016-04-07 	09:17:58 	0 	[QUERY] 	SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id

2016-04-07 	09:17:59 	0 	[DEBUG] 	Limpiar registros antiguos. 25 registros encontrados y umbral de 25 registros

2016-04-07 	09:17:59 	0 	[QUERY] 	SELECT csvi_log_id FROM u8713_csvi_logs ORDER BY csvi_log_id

2016-04-07 	09:17:59 	0 	[DEBUG] 	CSVI Pro Versión:@version@

2016-04-07 	09:17:59 	0 	[DEBUG] 	COM_CSVI_JOOMLA_VERSION

2016-04-07 	09:17:59 	0 	[DEBUG] 	Versión PHP: 5.5.30

2016-04-07 	09:17:59 	0 	[DEBUG] 	=========================

2016-04-07 	09:17:59 	0 	[DEBUG] 	action: export

2016-04-07 	09:17:59 	0 	[DEBUG] 	component: com_virtuemart

2016-04-07 	09:17:59 	0 	[DEBUG] 	operation: order

2016-04-07 	09:17:59 	0 	[DEBUG] 	localpath: /home/comenara/public_html

2016-04-07 	09:17:59 	0 	[DEBUG] 	ftphost:

2016-04-07 	09:17:59 	0 	[DEBUG] 	ftpport:

2016-04-07 	09:17:59 	0 	[DEBUG] 	ftproot:

2016-04-07 	09:17:59 	0 	[DEBUG] 	ftpfile:

2016-04-07 	09:17:59 	0 	[DEBUG] 	export_email_subject:

2016-04-07 	09:17:59 	0 	[DEBUG] 	export_email_body:

2016-04-07 	09:17:59 	0 	[DEBUG] 	export_filename: Pedidos almacén [d]-[m]-[Y].csv

2016-04-07 	09:17:59 	0 	[DEBUG] 	export_file: csv

2016-04-07 	09:17:59 	0 	[DEBUG] 	field_delimiter: ,

2016-04-07 	09:17:59 	0 	[DEBUG] 	text_enclosure: "

2016-04-07 	09:17:59 	0 	[DEBUG] 	include_column_headers: Sí

2016-04-07 	09:17:59 	0 	[DEBUG] 	signature: No

2016-04-07 	09:17:59 	0 	[DEBUG] 	publish_state:

2016-04-07 	09:17:59 	0 	[DEBUG] 	recordstart:

2016-04-07 	09:17:59 	0 	[DEBUG] 	recordend:

2016-04-07 	09:17:59 	0 	[DEBUG] 	export_date_format: d/m/Y H:i:s

2016-04-07 	09:17:59 	0 	[DEBUG] 	export_price_format_decimal: 2

2016-04-07 	09:17:59 	0 	[DEBUG] 	export_price_format_decsep: .

2016-04-07 	09:17:59 	0 	[DEBUG] 	export_price_format_thousep:

2016-04-07 	09:17:59 	0 	[DEBUG] 	header:

2016-04-07 	09:17:59 	0 	[DEBUG] 	body:

2016-04-07 	09:17:59 	0 	[DEBUG] 	footer:

2016-04-07 	09:17:59 	0 	[DEBUG] 	language: es-ES

2016-04-07 	09:17:59 	0 	[DEBUG] 	splitorderline: Sí

2016-04-07 	09:17:59 	0 	[DEBUG] 	ordernostart:

2016-04-07 	09:17:59 	0 	[DEBUG] 	ordernoend:

2016-04-07 	09:17:59 	0 	[DEBUG] 	orderlist:

2016-04-07 	09:17:59 	0 	[DEBUG] 	orderdaterange:

2016-04-07 	09:17:59 	0 	[DEBUG] 	orderdatestart:

2016-04-07 	09:17:59 	0 	[DEBUG] 	orderdateend:

2016-04-07 	09:17:59 	0 	[DEBUG] 	ordermdatestart:

2016-04-07 	09:17:59 	0 	[DEBUG] 	ordermdateend:

2016-04-07 	09:17:59 	0 	[DEBUG] 	order_address: BTST

2016-04-07 	09:17:59 	0 	[DEBUG] 	orderpricestart:

2016-04-07 	09:17:59 	0 	[DEBUG] 	orderpriceend:

2016-04-07 	09:17:59 	0 	[DEBUG] 	groupbyfields:

2016-04-07 	09:17:59 	0 	[DEBUG] 	sortfields:

2016-04-07 	09:17:59 	0 	[DEBUG] 	use_system_limits: No

2016-04-07 	09:17:59 	0 	[DEBUG] 	max_execution_time:

2016-04-07 	09:17:59 	0 	[DEBUG] 	memory_limit:

2016-04-07 	09:17:59 	0 	[DEBUG] 	=========================

2016-04-07 	09:17:59 	0 	[DEBUG] 	Export field: País

2016-04-07 	09:17:59 	0 	[DEBUG] 	Export field: Bultos

2016-04-07 	09:17:59 	0 	[DEBUG] 	Export field: Nº Pedido

2016-04-07 	09:17:59 	0 	[DEBUG] 	Export field: Nombre

2016-04-07 	09:17:59 	0 	[DEBUG] 	Export field: Referencia

2016-04-07 	09:17:59 	0 	[DEBUG] 	Export field: Cantidad

2016-04-07 	09:17:59 	0 	[DEBUG] 	Export field: Nota del comprador

2016-04-07 	09:17:59 	0 	[DEBUG] 	Export query

SELECT COALESCE(`user_info2`.`virtuemart_country_id`, `user_info1`.`virtuemart_country_id`) AS `virtuemart_country_id`,

`#__virtuemart_shipmentmethods`.`shipment_element`,

`#__virtuemart_orders`.`virtuemart_order_id`,

`order_number`,

COALESCE(`user_info2`.`first_name`, `user_info1`.`first_name`) AS `first_name`,

COALESCE(`user_info2`.`last_name`, `user_info1`.`last_name`) AS `last_name`,

`order_item_sku`,

`product_attribute`,

`order_item_name`,

`product_quantity`,

`user_info1`.`customer_note`

FROM `#__virtuemart_orders`

LEFT JOIN `#__virtuemart_order_items` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_order_items`.`virtuemart_order_id`

LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info1` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info1`.`virtuemart_order_id`

LEFT JOIN `#__virtuemart_order_userinfos` AS `user_info2` ON `#__virtuemart_orders`.`virtuemart_order_id` = `user_info2`.`virtuemart_order_id` AND `user_info2`.`address_type` = 'ST'

LEFT JOIN `#__virtuemart_orderstates` ON `#__virtuemart_orders`.`order_status` = `#__virtuemart_orderstates`.`order_status_code`

LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_order_items`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`

LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`

LEFT JOIN `#__users` ON `#__users`.`id` = `user_info1`.`virtuemart_user_id`

LEFT JOIN `#__virtuemart_countries` ON `#__virtuemart_countries`.`virtuemart_country_id` = `user_info1`.`virtuemart_country_id`

LEFT JOIN `#__virtuemart_invoices` ON `#__virtuemart_orders`.`virtuemart_order_id` = `#__virtuemart_invoices`.`virtuemart_order_id`

LEFT JOIN `#__virtuemart_paymentmethods_es_es` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_es_es`.`virtuemart_paymentmethod_id`

LEFT JOIN `#__virtuemart_shipmentmethods` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id`

WHERE `#__virtuemart_orders`.`order_status` IN ('Z') AND `user_info1`.`address_type` = 'BT' 

BTW version in downloads is 6.5.4 in the file where vm plugin is 6.5.5

I reinstalled and now it creates the csv file again to download, however we have the original issue posted here about the emails.

Regards

Patch solved it, damm you are fast!

Thanks

PD: Message was shown in csvipro after running export.

Hi Roland with "websitename" I meant it shows the name of my website or the SMTP host dont really know, cause they are the same.

Regards

Hello,

The attached patch should fix your error as well.

Hello,

The error you get is perfectly fine. The word "Websitename" is not a valid email address. Where did you enter this information?