# # #Date: 2015-11-04 12:53:33 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2015-11-04 12:53:33 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2015-11-04 12:53:33 0 [QUERY] SELECT csvi_log_id FROM zlto4_csvi_logs ORDER BY csvi_log_id 2015-11-04 12:53:34 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2015-11-04 12:53:34 0 [QUERY] SELECT csvi_log_id FROM zlto4_csvi_logs ORDER BY csvi_log_id 2015-11-04 12:53:35 0 [DEBUG] Setting system limits: 2015-11-04 12:53:35 0 [DEBUG] Setting max_execution_time to 60 seconds 2015-11-04 12:53:35 0 [DEBUG] CSVI Pro Version: 6.3.0 2015-11-04 12:53:35 0 [DEBUG] Joomla! version: 3.4.5 2015-11-04 12:53:35 0 [DEBUG] PHP version: 5.5.29 2015-11-04 12:53:35 0 [DEBUG] ========================= 2015-11-04 12:53:35 0 [DEBUG] action: export 2015-11-04 12:53:35 0 [DEBUG] component: com_virtuemart 2015-11-04 12:53:35 0 [DEBUG] operation: product 2015-11-04 12:53:35 0 [DEBUG] localpath: /home/public_html 2015-11-04 12:53:35 0 [DEBUG] ftphost: 2015-11-04 12:53:35 0 [DEBUG] ftpport: 2015-11-04 12:53:35 0 [DEBUG] ftproot: 2015-11-04 12:53:35 0 [DEBUG] ftpfile: 2015-11-04 12:53:35 0 [DEBUG] export_email_subject: 2015-11-04 12:53:35 0 [DEBUG] export_email_body: 2015-11-04 12:53:35 0 [DEBUG] export_filename: product_export-EN-unpublished.txt 2015-11-04 12:53:35 0 [DEBUG] export_file: csv 2015-11-04 12:53:35 0 [DEBUG] field_delimiter: ; 2015-11-04 12:53:35 0 [DEBUG] text_enclosure: " 2015-11-04 12:53:35 0 [DEBUG] include_column_headers: Yes 2015-11-04 12:53:35 0 [DEBUG] signature: Yes 2015-11-04 12:53:35 0 [DEBUG] publish_state: Yes 2015-11-04 12:53:35 0 [DEBUG] recordstart: 2015-11-04 12:53:35 0 [DEBUG] recordend: 2015-11-04 12:53:35 0 [DEBUG] export_date_format: d/m/Y H:i:s 2015-11-04 12:53:35 0 [DEBUG] export_price_format_decimal: 2 2015-11-04 12:53:35 0 [DEBUG] export_price_format_decsep: , 2015-11-04 12:53:35 0 [DEBUG] export_price_format_thousep: 2015-11-04 12:53:35 0 [DEBUG] header: 2015-11-04 12:53:35 0 [DEBUG] body: 2015-11-04 12:53:35 0 [DEBUG] footer: 2015-11-04 12:53:35 0 [DEBUG] language: en-GB 2015-11-04 12:53:35 0 [DEBUG] exportsef: No 2015-11-04 12:53:35 0 [DEBUG] producturl_suffix: 2015-11-04 12:53:35 0 [DEBUG] vm_itemid: 2015-11-04 12:53:35 0 [DEBUG] picture_limit: 4 2015-11-04 12:53:35 0 [DEBUG] featured: No 2015-11-04 12:53:35 0 [DEBUG] category_separator: [ 2015-11-04 12:53:35 0 [DEBUG] publish_state_categories: 2015-11-04 12:53:35 0 [DEBUG] incl_subcategory: Yes 2015-11-04 12:53:35 0 [DEBUG] parent_only: No 2015-11-04 12:53:35 0 [DEBUG] child_only: No 2015-11-04 12:53:35 0 [DEBUG] productskufilter: 2015-11-04 12:53:35 0 [DEBUG] stocklevelstart: 2015-11-04 12:53:35 0 [DEBUG] stocklevelend: 2015-11-04 12:53:35 0 [DEBUG] shopper_group_price: none 2015-11-04 12:53:35 0 [DEBUG] priceoperator: gt 2015-11-04 12:53:35 0 [DEBUG] pricefrom: 2015-11-04 12:53:35 0 [DEBUG] priceto: 2015-11-04 12:53:35 0 [DEBUG] price_quantity_start: 2015-11-04 12:53:35 0 [DEBUG] price_quantity_end: 2015-11-04 12:53:35 0 [DEBUG] targetcurrency: 2015-11-04 12:53:35 0 [DEBUG] force_shopper_group_price: none 2015-11-04 12:53:35 0 [DEBUG] groupbyfields: 2015-11-04 12:53:35 0 [DEBUG] sortfields: 2015-11-04 12:53:35 0 [DEBUG] use_system_limits: Yes 2015-11-04 12:53:35 0 [DEBUG] max_execution_time: 60 2015-11-04 12:53:35 0 [DEBUG] memory_limit: 2015-11-04 12:53:35 0 [DEBUG] ========================= 2015-11-04 12:53:35 0 [DEBUG] Export field: product_sku 2015-11-04 12:53:35 0 [DEBUG] Export field: category_path 2015-11-04 12:53:35 0 [DEBUG] Export field: product_name 2015-11-04 12:53:35 0 [DEBUG] Export field: product_s_desc 2015-11-04 12:53:35 0 [DEBUG] Export field: product_desc 2015-11-04 12:53:35 0 [DEBUG] Export field: product_price 2015-11-04 12:53:35 0 [DEBUG] Export field: product_in_stock 2015-11-04 12:53:35 0 [DEBUG] Export field: file_title 2015-11-04 12:53:35 0 [DEBUG] Export field: file_description 2015-11-04 12:53:35 0 [DEBUG] Export field: file_meta 2015-11-04 12:53:35 0 [DEBUG] Export field: file_url 2015-11-04 12:53:35 0 [DEBUG] Export field: file_url_thumb 2015-11-04 12:53:35 0 [DEBUG] Export field: file_ordering 2015-11-04 12:53:35 0 [DEBUG] Export field: product_availability 2015-11-04 12:53:35 0 [DEBUG] Export field: product_in_stock 2015-11-04 12:53:35 0 [DEBUG] Export field: product_tax_id 2015-11-04 12:53:35 0 [DEBUG] Export field: product_weight 2015-11-04 12:53:35 0 [DEBUG] Export field: product_weight_uom 2015-11-04 12:53:35 0 [DEBUG] Export field: Spuitoptie 2015-11-04 12:53:35 0 [DEBUG] Export field: Select colour code 2015-11-04 12:53:35 0 [DEBUG] Export field: Beschikbare kleuren 2015-11-04 12:53:35 0 [DEBUG] Export field: COM_VIRTUEMART_PAINTEDINCOLOUR_SELECT_COLOUR 2015-11-04 12:53:35 0 [DEBUG] Export field: COM_VIRTUEMART_PAINTEDINCOLOUR_TITLE 2015-11-04 12:53:35 0 [DEBUG] Export field: COM_VIRTUEMART_PRODUCTDETAIL_BODY 2015-11-04 12:53:35 0 [DEBUG] Export field: COM_VIRTUEMART_PRODUCTDETAIL_COLOUR 2015-11-04 12:53:35 0 [DEBUG] Export field: COM_VIRTUEMART_PRODUCTDETAIL_DATE 2015-11-04 12:53:35 0 [DEBUG] Export field: published 2015-11-04 12:53:35 0 [DEBUG] COM_CSVI_EXPORT_QUERY 2015-11-04 12:53:35 0 [QUERY] SELECT p.virtuemart_product_id FROM zlto4_virtuemart_products p LEFT JOIN zlto4_virtuemart_product_categories x ON p.virtuemart_product_id = x.virtuemart_product_id WHERE x.virtuemart_category_id IN ('815') 2015-11-04 12:53:35 0 [DEBUG] COM_CSVI_EXPORT_QUERY 2015-11-04 12:53:35 0 [QUERY] SELECT p.virtuemart_product_id FROM zlto4_virtuemart_products p WHERE p.product_parent_id IN ('611','1037','1316','2221','2222') 2015-11-04 12:53:35 0 [DEBUG] Export query SELECT `#__virtuemart_products`.`virtuemart_product_id`, `#__virtuemart_products`.`product_parent_id`, `product_sku`, `#__virtuemart_product_categories`.`virtuemart_category_id`, `#__virtuemart_product_prices`.`product_price`, `#__virtuemart_product_prices`.`virtuemart_shoppergroup_id`, `#__virtuemart_currencies`.`currency_code_3`, `#__virtuemart_products`.`virtuemart_product_id` AS `main_product_id`, `product_in_stock`, `product_availability`, `product_tax_id`, `product_weight`, `product_weight_uom`, `#__virtuemart_products`.`published` FROM `#__virtuemart_products` LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`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 `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id` LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency` LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id` WHERE `#__virtuemart_product_categories`.`virtuemart_category_id` IN (815) AND #__virtuemart_products.virtuemart_product_id IN (611,1037,1316,2221,2222) AND #__virtuemart_products.published = 1 2015-11-04 12:53:35 1 [DEBUG] Get cat ID815 2015-11-04 12:53:35 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 815 2015-11-04 12:53:35 1 [DEBUG] Get cat ID2 2015-11-04 12:53:35 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 2 2015-11-04 12:53:35 1 [DEBUG] Get cat ID1133 2015-11-04 12:53:35 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1133 2015-11-04 12:53:35 1 [DEBUG] Get cat ID1120 2015-11-04 12:53:35 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1120 2015-11-04 12:53:35 2 [DEBUG] Get cat ID815 2015-11-04 12:53:35 2 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 815 2015-11-04 12:53:35 2 [DEBUG] Get cat ID2 2015-11-04 12:53:35 2 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 2 2015-11-04 12:53:35 2 [DEBUG] Get cat ID1128 2015-11-04 12:53:35 2 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1128 2015-11-04 12:53:35 2 [DEBUG] Get cat ID1120 2015-11-04 12:53:35 2 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1120 2015-11-04 12:53:35 3 [DEBUG] Get cat ID815 2015-11-04 12:53:35 3 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 815 2015-11-04 12:53:35 3 [DEBUG] Get cat ID2 2015-11-04 12:53:35 3 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 2 2015-11-04 12:53:35 3 [DEBUG] Get cat ID1130 2015-11-04 12:53:35 3 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1130 2015-11-04 12:53:35 3 [DEBUG] Get cat ID1120 2015-11-04 12:53:35 3 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1120 2015-11-04 12:53:35 4 [DEBUG] Get cat ID815 2015-11-04 12:53:35 4 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 815 2015-11-04 12:53:35 4 [DEBUG] Get cat ID2 2015-11-04 12:53:35 4 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 2 2015-11-04 12:53:35 4 [DEBUG] Get cat ID1128 2015-11-04 12:53:35 4 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1128 2015-11-04 12:53:35 4 [DEBUG] Get cat ID1120 2015-11-04 12:53:35 4 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1120 2015-11-04 12:53:35 5 [DEBUG] Get cat ID815 2015-11-04 12:53:35 5 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 815 2015-11-04 12:53:35 5 [DEBUG] Get cat ID2 2015-11-04 12:53:35 5 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 2 2015-11-04 12:53:35 5 [DEBUG] Get cat ID1128 2015-11-04 12:53:35 5 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1128 2015-11-04 12:53:35 5 [DEBUG] Get cat ID1120 2015-11-04 12:53:35 5 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `zlto4_virtuemart_category_categories` AS `x` LEFT JOIN `zlto4_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `zlto4_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 1120