# # #Date: 2016-02-16 11:06:42 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2016-02-16 11:06:42 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2016-02-16 11:06:42 0 [QUERY] SELECT csvi_log_id FROM tv_csvi_logs ORDER BY csvi_log_id 2016-02-16 11:06:42 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2016-02-16 11:06:42 0 [QUERY] SELECT csvi_log_id FROM tv_csvi_logs ORDER BY csvi_log_id 2016-02-16 11:06:42 0 [DEBUG] CSVI Pro Version: 6.5.2 2016-02-16 11:06:42 0 [DEBUG] Joomla! version: 3.4.8 2016-02-16 11:06:42 0 [DEBUG] PHP version: 5.6.17 2016-02-16 11:06:42 0 [DEBUG] ========================= 2016-02-16 11:06:42 0 [DEBUG] action: export 2016-02-16 11:06:42 0 [DEBUG] component: com_virtuemart 2016-02-16 11:06:42 0 [DEBUG] operation: order 2016-02-16 11:06:42 0 [DEBUG] localpath: /home/tvdemodm/public_html/2016 2016-02-16 11:06:42 0 [DEBUG] ftphost: 2016-02-16 11:06:42 0 [DEBUG] ftpport: 2016-02-16 11:06:42 0 [DEBUG] ftproot: 2016-02-16 11:06:42 0 [DEBUG] ftpfile: 2016-02-16 11:06:42 0 [DEBUG] export_email_subject: 2016-02-16 11:06:42 0 [DEBUG] export_email_body: 2016-02-16 11:06:42 0 [DEBUG] export_filename: ordini-del-[d]-[m]-[Y]-ore-[H]-[i]-[s].csv 2016-02-16 11:06:42 0 [DEBUG] export_file: csv 2016-02-16 11:06:42 0 [DEBUG] field_delimiter: ; 2016-02-16 11:06:42 0 [DEBUG] text_enclosure: " 2016-02-16 11:06:42 0 [DEBUG] include_column_headers: Sì 2016-02-16 11:06:42 0 [DEBUG] signature: No 2016-02-16 11:06:42 0 [DEBUG] publish_state: 2016-02-16 11:06:42 0 [DEBUG] recordstart: 2016-02-16 11:06:42 0 [DEBUG] recordend: 2016-02-16 11:06:42 0 [DEBUG] export_date_format: d/m/Y H:i:s 2016-02-16 11:06:42 0 [DEBUG] export_price_format_decimal: 2 2016-02-16 11:06:42 0 [DEBUG] export_price_format_decsep: , 2016-02-16 11:06:42 0 [DEBUG] export_price_format_thousep: . 2016-02-16 11:06:42 0 [DEBUG] header: 2016-02-16 11:06:42 0 [DEBUG] body: 2016-02-16 11:06:42 0 [DEBUG] footer: 2016-02-16 11:06:42 0 [DEBUG] language: it-IT 2016-02-16 11:06:42 0 [DEBUG] splitorderline: No 2016-02-16 11:06:42 0 [DEBUG] ordernostart: 2016-02-16 11:06:42 0 [DEBUG] ordernoend: 2016-02-16 11:06:42 0 [DEBUG] orderlist: 2016-02-16 11:06:42 0 [DEBUG] orderdaterange: thismonth 2016-02-16 11:06:42 0 [DEBUG] orderdatestart: 2016-02-16 11:06:42 0 [DEBUG] orderdateend: 2016-02-16 11:06:42 0 [DEBUG] ordermdatestart: 2016-02-16 11:06:42 0 [DEBUG] ordermdateend: 2016-02-16 11:06:42 0 [DEBUG] order_address: 2016-02-16 11:06:42 0 [DEBUG] orderpricestart: 2016-02-16 11:06:42 0 [DEBUG] orderpriceend: 2016-02-16 11:06:42 0 [DEBUG] groupbyfields: {"name":[]} 2016-02-16 11:06:42 0 [DEBUG] sortfields: {"name":["address_1"]} 2016-02-16 11:06:42 0 [DEBUG] use_system_limits: No 2016-02-16 11:06:42 0 [DEBUG] max_execution_time: 2016-02-16 11:06:42 0 [DEBUG] memory_limit: 2016-02-16 11:06:42 0 [DEBUG] ========================= 2016-02-16 11:06:42 0 [DEBUG] Export field: order_number 2016-02-16 11:06:42 0 [DEBUG] Export field: created_on 2016-02-16 11:06:42 0 [DEBUG] Export field: first_name 2016-02-16 11:06:42 0 [DEBUG] Export field: last_name 2016-02-16 11:06:42 0 [DEBUG] Export field: email 2016-02-16 11:06:42 0 [DEBUG] Export field: phone_1 2016-02-16 11:06:42 0 [DEBUG] Export field: address_1 2016-02-16 11:06:42 0 [DEBUG] Export field: address_2 2016-02-16 11:06:42 0 [DEBUG] Export field: address_type 2016-02-16 11:06:42 0 [DEBUG] Export field: address_type_name 2016-02-16 11:06:42 0 [DEBUG] Export field: zip 2016-02-16 11:06:42 0 [DEBUG] Export field: city 2016-02-16 11:06:42 0 [DEBUG] Export field: virtuemart_country_id 2016-02-16 11:06:42 0 [DEBUG] Export field: virtuemart_paymentmethod_id 2016-02-16 11:06:42 0 [DEBUG] Export field: order_item_sku 2016-02-16 11:06:42 0 [DEBUG] Export field: order_item_name 2016-02-16 11:06:42 0 [DEBUG] Export field: product_final_price 2016-02-16 11:06:42 0 [DEBUG] Export field: product_quantity 2016-02-16 11:06:42 0 [DEBUG] Export field: order_shipment 2016-02-16 11:06:42 0 [DEBUG] Export field: order_total 2016-02-16 11:06:42 0 [DEBUG] Export field: order_status 2016-02-16 11:06:42 0 [DEBUG] Export field: coupon_code 2016-02-16 11:06:42 0 [DEBUG] Export field: coupon_discount 2016-02-16 11:06:42 0 [DEBUG] Export field: customer_note 2016-02-16 11:06:42 0 [DEBUG] Export field: product_attribute 2016-02-16 11:06:42 0 [DEBUG] Export query SELECT `order_number`, `#__virtuemart_orders`.`created_on`, `user_info1`.`first_name`, `user_info1`.`last_name`, `user_info1`.`email`, `phone_1`, `address_1`, `address_2`, `address_type`, `address_type_name`, `zip`, `city`, `user_info1`.`virtuemart_country_id`, `company`, `#__virtuemart_orders`.`virtuemart_paymentmethod_id`, `order_item_sku`, `order_item_name`, `product_final_price`, `product_quantity`, `order_shipment`, `order_total`, `#__virtuemart_orders`.`order_status`, `coupon_code`, `coupon_discount`, `user_info1`.`customer_note`, `product_attribute` 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` ON `#__virtuemart_orders`.`virtuemart_shipmentmethod_id` = `#__virtuemart_shipmentmethods`.`virtuemart_shipmentmethod_id` LEFT JOIN `#__virtuemart_products` ON `#__virtuemart_products`.`product_sku` = `#__virtuemart_order_items`.`order_item_sku` WHERE DATE(`#__virtuemart_orders`.`created_on`) >= DATE_SUB(CURDATE(), INTERVAL 16 DAY) AND DATE(`#__virtuemart_orders`.`created_on`) <= CURDATE() ORDER BY `address_1`