﻿
Details
Date	2015-07-15 21:25:10 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 115 lines
2015-07-15	21:25:10	0	[DEBUG]	Clean up old logs. Found 26 logs and threshold is 25 logs
2015-07-15	21:25:10	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-07-15	21:25:18	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2015-07-15	21:25:18	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-07-15	21:25:18	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation product and action import
2015-07-15	21:25:18	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-15	21:25:18	0	[DEBUG]	Load the fields to process
2015-07-15	21:25:18	0	[DEBUG]	Setup field: product_sku
2015-07-15	21:25:18	0	[DEBUG]	Setup field: product_name
2015-07-15	21:25:18	0	[DEBUG]	Use the file for configuration
2015-07-15	21:25:18	0	[DEBUG]	==========
2015-07-15	21:25:18	0	[DEBUG]	CSVI Pro Version: 6.0rc1
2015-07-15	21:25:18	0	[DEBUG]	PHP version: 5.5.6
2015-07-15	21:25:18	0	[DEBUG]	Action: import
2015-07-15	21:25:18	0	[DEBUG]	Component: com_virtuemart
2015-07-15	21:25:18	0	[DEBUG]	Operation: product
2015-07-15	21:25:18	0	[DEBUG]	Source: fromupload
2015-07-15	21:25:18	0	[DEBUG]	Load from computer: /home/qttest/public_html/tmp/com_csvi/1436995515/tst.csv
2015-07-15	21:25:18	0	[DEBUG]	Load from server:
2015-07-15	21:25:18	0	[DEBUG]	Delete after import: No
2015-07-15	21:25:18	0	[DEBUG]	Load from URL:
2015-07-15	21:25:18	0	[DEBUG]	FTP Host:
2015-07-15	21:25:18	0	[DEBUG]	FTP Port:
2015-07-15	21:25:18	0	[DEBUG]	FTP Root Folder:
2015-07-15	21:25:18	0	[DEBUG]	FTP Filename:
2015-07-15	21:25:18	0	[DEBUG]	Auto detect delimiters: No
2015-07-15	21:25:18	0	[DEBUG]	Field Delimiter: ;
2015-07-15	21:25:18	0	[DEBUG]	Text Enclosure: ^
2015-07-15	21:25:18	0	[DEBUG]	Use file extension:
2015-07-15	21:25:18	0	[DEBUG]	I'm Mac: No
2015-07-15	21:25:18	0	[DEBUG]	Use file for configuration: Yes
2015-07-15	21:25:18	0	[DEBUG]	Add extra fields: No
2015-07-15	21:25:18	0	[DEBUG]	Skip first line: No
2015-07-15	21:25:18	0	[DEBUG]	Overwrite existing data: Yes
2015-07-15	21:25:18	0	[DEBUG]	Skip new items: No
2015-07-15	21:25:18	0	[DEBUG]	Record name:
2015-07-15	21:25:18	0	[DEBUG]	Language: en-GB
2015-07-15	21:25:18	0	[DEBUG]	Category separator: \
2015-07-15	21:25:18	0	[DEBUG]	Append categories: No
2015-07-15	21:25:18	0	[DEBUG]	Import based on: product_sku
2015-07-15	21:25:18	0	[DEBUG]	Unpublish before import: No
2015-07-15	21:25:18	0	[DEBUG]	Recreate alias: Yes
2015-07-15	21:25:18	0	[DEBUG]	Force stockable parent update: No
2015-07-15	21:25:18	0	[DEBUG]	Use ICEcat data: No
2015-07-15	21:25:18	0	[DEBUG]	Similar SKU search: No
2015-07-15	21:25:18	0	[DEBUG]	Process images: No
2015-07-15	21:25:18	0	[DEBUG]	Location product files:
2015-07-15	21:25:18	0	[DEBUG]	Delete image relations: No
2015-07-15	21:25:18	0	[DEBUG]	Create image name: No
2015-07-15	21:25:18	0	[DEBUG]	Image name based on: product_sku
2015-07-15	21:25:18	0	[DEBUG]	Image name format: jpg
2015-07-15	21:25:18	0	[DEBUG]	Change case: none
2015-07-15	21:25:18	0	[DEBUG]	Fill media fields: No
2015-07-15	21:25:18	0	[DEBUG]	Keep original file: No
2015-07-15	21:25:18	0	[DEBUG]	Convert image type: none
2015-07-15	21:25:18	0	[DEBUG]	Save images on server: No
2015-07-15	21:25:18	0	[DEBUG]	Re-download image: Yes
2015-07-15	21:25:18	0	[DEBUG]	Resize large image: No
2015-07-15	21:25:18	0	[DEBUG]	Full image width:
2015-07-15	21:25:18	0	[DEBUG]	Full image height:
2015-07-15	21:25:18	0	[DEBUG]	Check filetype: No
2015-07-15	21:25:18	0	[DEBUG]	Automatic thumbnail creation: No
2015-07-15	21:25:18	0	[DEBUG]	Thumbnail type: none
2015-07-15	21:25:18	0	[DEBUG]	Thumbnail width: 90
2015-07-15	21:25:18	0	[DEBUG]	Thumbnail height: 90
2015-07-15	21:25:18	0	[DEBUG]	Maximum width resize: 1024
2015-07-15	21:25:18	0	[DEBUG]	Maximum height resize: 768
2015-07-15	21:25:18	0	[DEBUG]	Watermark: No
2015-07-15	21:25:18	0	[DEBUG]	Right margin:
2015-07-15	21:25:18	0	[DEBUG]	Bottom margin:
2015-07-15	21:25:18	0	[DEBUG]	Image:
2015-07-15	21:25:18	0	[DEBUG]	Lines per import: 400
2015-07-15	21:25:18	0	[DEBUG]	Time between imports: 5
2015-07-15	21:25:18	0	[DEBUG]	Override system limits?: Yes
2015-07-15	21:25:18	0	[DEBUG]	Maximum execution time: 60
2015-07-15	21:25:18	0	[DEBUG]	Maximum amount of memory:
2015-07-15	21:25:18	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-07-15	21:25:18	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-07-15	21:25:18	0	[DEBUG]	==========
2015-07-15	21:25:18	0	[DEBUG]	Setting system limits:
2015-07-15	21:25:18	0	[QUERY]	SELECT `config` FROM `y9zak_virtuemart_configs` WHERE `virtuemart_config_id` = 1
2015-07-15	21:25:18	0	[DEBUG]	Setting max_execution_time to 60 seconds
2015-07-15	21:25:18	0	[QUERY]	SELECT `config` FROM `y9zak_virtuemart_configs` WHERE `virtuemart_config_id` = 1
2015-07-15	21:25:18	0	[DEBUG]	Load the custom fields
2015-07-15	21:25:18	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-15	21:25:18	1	[DEBUG]	Use field value for field product_sku
2015-07-15	21:25:18	1	[DEBUG]	Use field value for field product_name
2015-07-15	21:25:18	1	[DEBUG]	Process line 1
2015-07-15	21:25:18	1	[DEBUG]	Check if the vendor exists
2015-07-15	21:25:18	1	[QUERY]	SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `y9zak_virtuemart_products` WHERE `product_sku` = 'FW-24'
2015-07-15	21:25:18	1	[DEBUG]	Load a row
2015-07-15	21:25:18	1	[DEBUG]	Product tax:
2015-07-15	21:25:18	1	[DEBUG]	Query for Product
2015-07-15	21:25:18	1	[QUERY]	UPDATE `y9zak_virtuemart_products` SET `virtuemart_product_id`='5939',`virtuemart_vendor_id`='1',`product_parent_id`='5632',`product_gtin`='',`product_mpn`='',`product_weight`='0.3000',`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`='24h.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`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-05-11 14:58:08',`created_by`='937',`modified_on`='2015-07-15 21:25:18',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='FW-24'
2015-07-15	21:25:18	1	[DEBUG]	Check product language entry
2015-07-15	21:25:18	1	[QUERY]	SELECT `virtuemart_product_id`,`slug` FROM `y9zak_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 5939
2015-07-15	21:25:18	1	[DEBUG]	Load a row
2015-07-15	21:25:18	1	[DEBUG]	Check if the product slug exists
2015-07-15	21:25:18	1	[QUERY]	SELECT COUNT(`virtuemart_product_id`) FROM y9zak_virtuemart_products_en_gb WHERE `slug` = 'twister-flat-wiper-blade-multi-fit-24-600mm' AND `virtuemart_product_id` != 5939
2015-07-15	21:25:18	1	[DEBUG]	Query for ProductLang
2015-07-15	21:25:18	1	[QUERY]	UPDATE `y9zak_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='',`product_name`='Twister Flat Wiper Blade-Multi Fit 24\" 600mm',`metadesc`='Brand New',`metakey`='brand,new',`customtitle`='',`slug`='twister-flat-wiper-blade-multi-fit-24-600mm' WHERE `virtuemart_product_id`='5939'
2015-07-15	21:25:18	1	[DEBUG]	Checking manufacturer
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_MODELS
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: Size Chart
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: Body Style
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: Horsepower [PS/kW]
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: Video
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: Model
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: Engine
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: Year
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_CATEGORIES
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_FRONTMOUNT
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_REARMOUNT
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: COM_VIRTUEMART_CF_INVERTED
2015-07-15	21:25:18	1	[DEBUG]	Processing custom available field: relarticle