I have a timeout error in the "Advanced XML export order."
I've only 4 orders.
Below you can see the list of debugging.
Where am I wrong?
Tks.
Details
Date 2016-01-21 14:49:11 UTC
Software Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date Time Line Action Comment
Processed 120 lines
2016-01-21 14:49:11 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-01-21 14:49:11 0 [QUERY] SELECT csvi_log_id FROM mfg9e_csvi_logs ORDER BY csvi_log_id
2016-01-21 14:49:11 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-01-21 14:49:11 0 [QUERY] SELECT csvi_log_id FROM mfg9e_csvi_logs ORDER BY csvi_log_id
2016-01-21 14:49:11 0 [DEBUG] CSVI Pro Version: 6.4.3
2016-01-21 14:49:11 0 [DEBUG] Joomla! version: 3.4.5
2016-01-21 14:49:11 0 [DEBUG] PHP version: 5.5.31
2016-01-21 14:49:11 0 [DEBUG] =========================
2016-01-21 14:49:11 0 [DEBUG] action: export
2016-01-21 14:49:11 0 [DEBUG] component: com_virtuemart
2016-01-21 14:49:11 0 [DEBUG] operation: orderadvanced
2016-01-21 14:49:11 0 [DEBUG] localpath: /web/htdocs/http://www.suades.it/home/testmafrat
2016-01-21 14:49:11 0 [DEBUG] ftphost:
2016-01-21 14:49:11 0 [DEBUG] ftpport:
2016-01-21 14:49:11 0 [DEBUG] ftproot:
2016-01-21 14:49:11 0 [DEBUG] ftpfile:
2016-01-21 14:49:11 0 [DEBUG] export_email_subject:
2016-01-21 14:49:11 0 [DEBUG] export_email_body:
2016-01-21 14:49:11 0 [DEBUG] export_filename:
2016-01-21 14:49:11 0 [DEBUG] export_file: csv
2016-01-21 14:49:11 0 [DEBUG] export_site: orderadvanced
2016-01-21 14:49:11 0 [DEBUG] publish_state:
2016-01-21 14:49:11 0 [DEBUG] recordstart:
2016-01-21 14:49:11 0 [DEBUG] recordend:
2016-01-21 14:49:11 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-01-21 14:49:11 0 [DEBUG] export_price_format_decimal: 2
2016-01-21 14:49:11 0 [DEBUG] export_price_format_decsep: .
2016-01-21 14:49:11 0 [DEBUG] export_price_format_thousep:
2016-01-21 14:49:11 0 [DEBUG] add_currency_to_price: No
2016-01-21 14:49:11 0 [DEBUG] language: it-IT
2016-01-21 14:49:11 0 [DEBUG] splitorderline: No
2016-01-21 14:49:11 0 [DEBUG] ordernostart:
2016-01-21 14:49:11 0 [DEBUG] ordernoend:
2016-01-21 14:49:11 0 [DEBUG] orderlist:
2016-01-21 14:49:11 0 [DEBUG] orderdaterange:
2016-01-21 14:49:11 0 [DEBUG] orderdatestart:
2016-01-21 14:49:11 0 [DEBUG] orderdateend:
2016-01-21 14:49:11 0 [DEBUG] ordermdatestart:
2016-01-21 14:49:11 0 [DEBUG] ordermdateend:
2016-01-21 14:49:11 0 [DEBUG] order_address:
2016-01-21 14:49:11 0 [DEBUG] orderpricestart:
2016-01-21 14:49:11 0 [DEBUG] orderpriceend:
2016-01-21 14:49:11 0 [DEBUG] header:
2016-01-21 14:49:11 0 [DEBUG] order:
[full_name]
[address_1]
[zip]
[city]
[country_2_code]
[phone_1]
[phone_2]
[fax]
[email]
[created_on]
[order_number]
[customer_note]
[orderlines]
2016-01-21 14:49:11 0 [DEBUG] orderline:
[order_item_name]
[product_quantity]
[product_item_price]
2016-01-21 14:49:11 0 [DEBUG] footer:
2016-01-21 14:49:11 0 [DEBUG] groupbyfields:
2016-01-21 14:49:11 0 [DEBUG] sortfields:
2016-01-21 14:49:11 0 [DEBUG] use_system_limits: No
2016-01-21 14:49:11 0 [DEBUG] max_execution_time:
2016-01-21 14:49:11 0 [DEBUG] memory_limit:
2016-01-21 14:49:11 0 [DEBUG] =========================
2016-01-21 14:49:11 0 [DEBUG] Export field: full_name
2016-01-21 14:49:11 0 [DEBUG] Export field: address_1
2016-01-21 14:49:11 0 [DEBUG] Export field: zip
2016-01-21 14:49:11 0 [DEBUG] Export field: city
2016-01-21 14:49:11 0 [DEBUG] Export field: country_2_code
2016-01-21 14:49:11 0 [DEBUG] Export field: phone_1
2016-01-21 14:49:11 0 [DEBUG] Export field: phone_2
2016-01-21 14:49:11 0 [DEBUG] Export field: fax
2016-01-21 14:49:11 0 [DEBUG] Export field: email
2016-01-21 14:49:11 0 [DEBUG] Export field: created_on
2016-01-21 14:49:11 0 [DEBUG] Export field: order_number
2016-01-21 14:49:11 0 [DEBUG] Export field: customer_note
2016-01-21 14:49:11 0 [DEBUG] Export field: order_item_name
2016-01-21 14:49:11 0 [DEBUG] Export field: product_quantity
2016-01-21 14:49:11 0 [DEBUG] Export field: product_item_price
2016-01-21 14:49:11 0 [DEBUG] Export query
SELECT `#__virtuemart_orders`.`virtuemart_order_id`,
`user_info1`.`first_name`,
`user_info1`.`middle_name`,
`user_info1`.`last_name`,
`address_1`,
`zip`,
`city`,
`user_info1`.`virtuemart_country_id`,
`phone_1`,
`phone_2`,
`fax`,
`user_info1`.`email`,
`#__virtuemart_orders`.`created_on`,
`order_number`,
`customer_note`,
`order_item_name`,
`product_quantity`,
`product_item_price`
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_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_it_it` ON `#__virtuemart_orders`.`virtuemart_paymentmethod_id` = `#__virtuemart_paymentmethods_it_it`.`virtuemart_paymentmethod_id`
LEFT JOIN `#__virtuemart_shipmentmethods_it_it` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods_it_it`.`virtuemart_shipmentmethod_id`
