Categories
View Replies (9)

Resolved Export to email fails after update to joomla 3.5.1

  1. Comenaranjas
    Comenaranjas
  2. RO CSVI
  3. Wednesday, 06 April 2016
  4.  Subscribe via email
Hi

After updating joomla to 3.5.1 the export fails with message Error

Invalid address: Websitename

Seems they have touched something related to SMTP mail security which affected VM also but I've applied fix for VM already

http://forum.virtuemart.net/index.php?topic=133760.0 however is failing to send the CSVIpro export by email.

Regards
0
Responses (9)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The error you get is perfectly fine. The word "Websitename" is not a valid email address. Where did you enter this information?
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
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The attached patch should fix your error as well.
Attachments (1)
patch_email_20160406.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. # 2
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 3
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
Patch solved it, damm you are fast!

Thanks

PD: Message was shown in csvipro after running export.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Attachments (1)
patch_export_20160407.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. # 6
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
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.
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. # 8
Comenaranjas
Comenaranjas
Accepted Answer Pending Moderation
Seems I skipped the first "view files",

Regards
  1. more than a month ago
  2. RO CSVI
  3. # 9
  • Page :
  • 1


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