﻿
Details
Date	2015-07-04 19:11:03 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 155 lines
2015-07-04	19:11:03	0	[DEBUG]	Clean up old logs. Found 26 logs and threshold is 25 logs
2015-07-04	19:11:03	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-07-04	19:11:14	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2015-07-04	19:11:14	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-07-04	19:11:16	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation product and action import
2015-07-04	19:11:16	0	[QUERY]	SELECT `a`.`csvi_name` FROM `y9zak_csvi_availablefields` AS `a` LEFT JOIN `y9zak_csvi_availabletables` AS `t` ON `t`.`template_table` = `a`.`component_table` WHERE `a`.`component` = 'com_virtuemart' AND `t`.`component` = 'com_virtuemart' AND `t`.`task_name` = 'product' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2015-07-04	19:11:16	0	[DEBUG]	Load the fields to process
2015-07-04	19:11:16	0	[DEBUG]	Setup field: product_sku
2015-07-04	19:11:16	0	[DEBUG]	Setup field: product_name
2015-07-04	19:11:16	0	[DEBUG]	Setup field: product_desc
2015-07-04	19:11:16	0	[DEBUG]	Setup field: product_s_desc
2015-07-04	19:11:16	0	[DEBUG]	Setup field: metadesc
2015-07-04	19:11:16	0	[DEBUG]	Setup field: metakey
2015-07-04	19:11:16	0	[DEBUG]	Use the file for configuration
2015-07-04	19:11:16	0	[DEBUG]	==========
2015-07-04	19:11:16	0	[DEBUG]	CSVI Pro Version: 6.0rc1
2015-07-04	19:11:16	0	[DEBUG]	PHP version: 5.5.6
2015-07-04	19:11:16	0	[DEBUG]	Action: import
2015-07-04	19:11:16	0	[DEBUG]	Component: com_virtuemart
2015-07-04	19:11:16	0	[DEBUG]	Operation: product
2015-07-04	19:11:16	0	[DEBUG]	Source: fromupload
2015-07-04	19:11:16	0	[DEBUG]	Load from computer: /home/qttest/public_html/tmp/com_csvi/1436037069/greeoil.csv
2015-07-04	19:11:16	0	[DEBUG]	Load from server:
2015-07-04	19:11:16	0	[DEBUG]	Delete after import: No
2015-07-04	19:11:16	0	[DEBUG]	Load from URL:
2015-07-04	19:11:16	0	[DEBUG]	FTP Host:
2015-07-04	19:11:16	0	[DEBUG]	FTP Port:
2015-07-04	19:11:16	0	[DEBUG]	FTP Root Folder:
2015-07-04	19:11:16	0	[DEBUG]	FTP Filename:
2015-07-04	19:11:16	0	[DEBUG]	Auto detect delimiters: No
2015-07-04	19:11:16	0	[DEBUG]	Field Delimiter: ;
2015-07-04	19:11:16	0	[DEBUG]	Text Enclosure:
2015-07-04	19:11:16	0	[DEBUG]	Use file extension:
2015-07-04	19:11:16	0	[DEBUG]	I'm Mac: No
2015-07-04	19:11:16	0	[DEBUG]	Use file for configuration: Yes
2015-07-04	19:11:16	0	[DEBUG]	Add extra fields: No
2015-07-04	19:11:16	0	[DEBUG]	Skip first line: No
2015-07-04	19:11:16	0	[DEBUG]	Overwrite existing data: Yes
2015-07-04	19:11:16	0	[DEBUG]	Skip new items: No
2015-07-04	19:11:16	0	[DEBUG]	Record name:
2015-07-04	19:11:16	0	[DEBUG]	Language: el-GR
2015-07-04	19:11:16	0	[DEBUG]	Category separator: \
2015-07-04	19:11:16	0	[DEBUG]	Append categories: No
2015-07-04	19:11:16	0	[DEBUG]	Import based on: product_sku
2015-07-04	19:11:16	0	[DEBUG]	Unpublish before import: No
2015-07-04	19:11:16	0	[DEBUG]	Recreate alias: Yes
2015-07-04	19:11:16	0	[DEBUG]	Force stockable parent update: No
2015-07-04	19:11:16	0	[DEBUG]	Use ICEcat data: No
2015-07-04	19:11:16	0	[DEBUG]	Similar SKU search: No
2015-07-04	19:11:16	0	[DEBUG]	Process images: No
2015-07-04	19:11:16	0	[DEBUG]	Location product files:
2015-07-04	19:11:16	0	[DEBUG]	Delete image relations: No
2015-07-04	19:11:16	0	[DEBUG]	Create image name: No
2015-07-04	19:11:16	0	[DEBUG]	Image name based on: product_sku
2015-07-04	19:11:16	0	[DEBUG]	Image name format: jpg
2015-07-04	19:11:16	0	[DEBUG]	Change case: none
2015-07-04	19:11:16	0	[DEBUG]	Fill media fields: No
2015-07-04	19:11:16	0	[DEBUG]	Keep original file: No
2015-07-04	19:11:16	0	[DEBUG]	Convert image type: none
2015-07-04	19:11:16	0	[DEBUG]	Save images on server: No
2015-07-04	19:11:16	0	[DEBUG]	Re-download image: Yes
2015-07-04	19:11:16	0	[DEBUG]	Resize large image: No
2015-07-04	19:11:16	0	[DEBUG]	Full image width:
2015-07-04	19:11:16	0	[DEBUG]	Full image height:
2015-07-04	19:11:16	0	[DEBUG]	Check filetype: No
2015-07-04	19:11:16	0	[DEBUG]	Automatic thumbnail creation: No
2015-07-04	19:11:16	0	[DEBUG]	Thumbnail type: none
2015-07-04	19:11:16	0	[DEBUG]	Thumbnail width: 90
2015-07-04	19:11:16	0	[DEBUG]	Thumbnail height: 90
2015-07-04	19:11:16	0	[DEBUG]	Maximum width resize: 1024
2015-07-04	19:11:16	0	[DEBUG]	Maximum height resize: 768
2015-07-04	19:11:16	0	[DEBUG]	Watermark: No
2015-07-04	19:11:16	0	[DEBUG]	Right margin:
2015-07-04	19:11:16	0	[DEBUG]	Bottom margin:
2015-07-04	19:11:16	0	[DEBUG]	Image:
2015-07-04	19:11:16	0	[DEBUG]	Lines per import: 400
2015-07-04	19:11:16	0	[DEBUG]	Time between imports: 5
2015-07-04	19:11:16	0	[DEBUG]	Override system limits?: Yes
2015-07-04	19:11:16	0	[DEBUG]	Maximum execution time: 60
2015-07-04	19:11:16	0	[DEBUG]	Maximum amount of memory:
2015-07-04	19:11:16	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-07-04	19:11:16	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-07-04	19:11:16	0	[DEBUG]	==========
2015-07-04	19:11:16	0	[DEBUG]	Setting system limits:
2015-07-04	19:11:16	0	[QUERY]	SELECT `config` FROM `y9zak_virtuemart_configs` WHERE `virtuemart_config_id` = 1
2015-07-04	19:11:16	0	[DEBUG]	Setting max_execution_time to 60 seconds
2015-07-04	19:11:16	0	[QUERY]	SELECT `config` FROM `y9zak_virtuemart_configs` WHERE `virtuemart_config_id` = 1
2015-07-04	19:11:16	0	[DEBUG]	Load the custom fields
2015-07-04	19:11:16	0	[QUERY]	SELECT `virtuemart_custom_id` AS `id`, `field_type`, TRIM(`custom_title`) AS title FROM `y9zak_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X')
2015-07-04	19:11:16	1	[DEBUG]	Use field value for field product_sku
2015-07-04	19:11:16	1	[DEBUG]	Use field value for field product_name
2015-07-04	19:11:16	1	[DEBUG]	Use default value for field product_desc
2015-07-04	19:11:16	1	[DEBUG]	Use field value for field product_s_desc
2015-07-04	19:11:16	1	[DEBUG]	Use field value for field metadesc
2015-07-04	19:11:16	1	[DEBUG]	Use field value for field metakey
2015-07-04	19:11:16	1	[DEBUG]	Process line 1
2015-07-04	19:11:16	1	[DEBUG]	Check if the vendor exists
2015-07-04	19:11:16	1	[QUERY]	SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `y9zak_virtuemart_products` WHERE `product_sku` = 'K-AC-01'
2015-07-04	19:11:16	1	[DEBUG]	Load a row
2015-07-04	19:11:16	1	[DEBUG]	Product tax:
2015-07-04	19:11:16	1	[DEBUG]	Query for Product
2015-07-04	19:11:16	1	[QUERY]	UPDATE `y9zak_virtuemart_products` SET `virtuemart_product_id`='3157',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='5.0000',`product_weight_uom`='kg',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='14d.gif',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='noodp, noydir',`metaauthor`='Quality Tuning',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-23 20:06:56',`created_by`='937',`modified_on`='2015-07-04 19:11:16',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='K-AC-01'
2015-07-04	19:11:16	1	[DEBUG]	Check product language entry
2015-07-04	19:11:16	1	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `y9zak_virtuemart_products_el_gr` WHERE `virtuemart_product_id` = 3157
2015-07-04	19:11:16	1	[DEBUG]	Load a row
2015-07-04	19:11:16	1	[DEBUG]	Check if the product slug exists
2015-07-04	19:11:16	1	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM y9zak_virtuemart_products_el_gr WHERE `slug` = 'acura-cl-ya1-96-00-k-sport---coilover' AND `virtuemart_product_id` != 3157
2015-07-04	19:11:16	1	[DEBUG]	Query for ProductLang
2015-07-04	19:11:16	1	[QUERY]	UPDATE `y9zak_virtuemart_products_el_gr` SET `product_s_desc`='
Σετ 4 κομματιών (2 Μπροστά / 2 Πίσω)
Εγγύηση: 1 Χρόνος για διαρροή λαδιού από το γόνατο
',`product_desc`='',`product_name`='Acura CL YA1 96~00 K-Sport Ρυθμιζόμενες Αναρτήσεις-Αμορτισέρ Ελατηρίου (Coilover)',`metadesc`='Σετ 4 κομματιών (2 Μπροστά / 2 Πίσω),Εγγύηση: 1 Χρόνος για διαρροή λαδιού από το γόνατο',`metakey`='Σετ 4 κομματιών (2 Μπροστά / 2 Πίσω),Εγγύηση: 1 Χρόνος για διαρροή λαδιού από το γόνατο',`customtitle`='',`slug`='acura-cl-ya1-96-00-k-sport---coilover' WHERE `virtuemart_product_id`='3157'
2015-07-04	19:11:16	1	[DEBUG]	Checking manufacturer
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_MODELS
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: Size Chart
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: Body Style
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: Horsepower [PS/kW]
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: Video
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: Model
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: Engine
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: Year
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_CATEGORIES
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_FRONTMOUNT
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_REARMOUNT
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_INVERTED
2015-07-04	19:11:16	1	[DEBUG]	Processing custom available field: relarticle
2015-07-04	19:11:16	2	[DEBUG]	Use field value for field product_sku
2015-07-04	19:11:16	2	[DEBUG]	Use field value for field product_name
2015-07-04	19:11:16	2	[DEBUG]	Use default value for field product_desc
2015-07-04	19:11:16	2	[DEBUG]	Use field value for field product_s_desc
2015-07-04	19:11:16	2	[DEBUG]	Use field value for field metadesc
2015-07-04	19:11:16	2	[DEBUG]	Use field value for field metakey
2015-07-04	19:11:16	2	[DEBUG]	Process line 2
2015-07-04	19:11:16	2	[DEBUG]	Load a row
2015-07-04	19:11:16	2	[DEBUG]	Product tax:
2015-07-04	19:11:16	2	[DEBUG]	Query for Product
2015-07-04	19:11:16	2	[QUERY]	UPDATE `y9zak_virtuemart_products` SET `virtuemart_product_id`='3158',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`=NULL,`product_mpn`=NULL,`product_weight`='5.0000',`product_weight_uom`='kg',`product_length`='0.0000',`product_width`='0.0000',`product_height`='0.0000',`product_lwh_uom`='M',`product_url`='',`product_in_stock`='100',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='14d.gif',`product_special`='0',`product_sales`='0',`product_unit`='KG',`product_packaging`='0.0000',`product_params`='min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='noodp, noydir',`metaauthor`='Quality Tuning',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-04-23 20:06:56',`created_by`='937',`modified_on`='2015-07-04 19:11:16',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='K-AC-02'
2015-07-04	19:11:16	2	[DEBUG]	Check product language entry
2015-07-04	19:11:16	2	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `y9zak_virtuemart_products_el_gr` WHERE `virtuemart_product_id` = 3158
2015-07-04	19:11:16	2	[DEBUG]	Load a row
2015-07-04	19:11:16	2	[DEBUG]	Check if the product slug exists
2015-07-04	19:11:16	2	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM y9zak_virtuemart_products_el_gr WHERE `slug` = 'acura-cl-ya4-01-03-k-sport---coilover' AND `virtuemart_product_id` != 3158
2015-07-04	19:11:16	2	[DEBUG]	Query for ProductLang
2015-07-04	19:11:16	2	[QUERY]	UPDATE `y9zak_virtuemart_products_el_gr` SET `product_s_desc`='
Σετ 4 κομματιών (2 Μπροστά / 2 Πίσω)
Εγγύηση: 1 Χρόνος για διαρροή λαδιού από το γόνατο
',`product_desc`='',`product_name`='Acura CL YA4 01~03 K-Sport Ρυθμιζόμενες Αναρτήσεις-Αμορτισέρ Ελατηρίου (Coilover)',`metadesc`='Σετ 4 κομματιών (2 Μπροστά / 2 Πίσω),Εγγύηση: 1 Χρόνος για διαρροή λαδιού από το γόνατο',`metakey`='Σετ 4 κομματιών (2 Μπροστά / 2 Πίσω),Εγγύηση: 1 Χρόνος για διαρροή λαδιού από το γόνατο',`customtitle`='',`slug`='acura-cl-ya4-01-03-k-sport---coilover' WHERE `virtuemart_product_id`='3158'
2015-07-04	19:11:16	2	[DEBUG]	Checking manufacturer
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_MODELS
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: Size Chart
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: Body Style
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: Horsepower [PS/kW]
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: Video
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: Model
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: Engine
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: Year
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_CATEGORIES
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_FRONTMOUNT
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_REARMOUNT
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_INVERTED
2015-07-04	19:11:16	2	[DEBUG]	Processing custom available field: relarticle