﻿
Details
Date	2015-07-08 17:32:47 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 112 lines
2015-07-08	17:32:47	0	[DEBUG]	Clean up old logs. Found 26 logs and threshold is 25 logs
2015-07-08	17:32:47	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-07-08	17:33:02	0	[DEBUG]	Clean up old logs. Found 25 logs and threshold is 25 logs
2015-07-08	17:33:02	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-07-08	17:33:03	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation category and action import
2015-07-08	17:33:03	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` = 'category' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2015-07-08	17:33:03	0	[DEBUG]	Load the fields to process
2015-07-08	17:33:03	0	[DEBUG]	Setup field: category_path
2015-07-08	17:33:03	0	[DEBUG]	Setup field: category_template
2015-07-08	17:33:03	0	[DEBUG]	Setup field: products_per_row
2015-07-08	17:33:03	0	[DEBUG]	Setup field: metaauthor
2015-07-08	17:33:03	0	[DEBUG]	Setup field: category_description
2015-07-08	17:33:03	0	[DEBUG]	Setup field: metadesc
2015-07-08	17:33:03	0	[DEBUG]	Setup field: metakey
2015-07-08	17:33:03	0	[DEBUG]	Setup field: customtitle
2015-07-08	17:33:03	0	[DEBUG]	Setup field: slug
2015-07-08	17:33:03	0	[DEBUG]	Setup field: ordering
2015-07-08	17:33:03	0	[DEBUG]	Setup field: published
2015-07-08	17:33:03	0	[DEBUG]	Use the file for configuration
2015-07-08	17:33:03	0	[DEBUG]	==========
2015-07-08	17:33:03	0	[DEBUG]	CSVI Pro Version: 6.0rc1
2015-07-08	17:33:03	0	[DEBUG]	PHP version: 5.5.6
2015-07-08	17:33:03	0	[DEBUG]	Action: import
2015-07-08	17:33:03	0	[DEBUG]	Component: com_virtuemart
2015-07-08	17:33:03	0	[DEBUG]	Operation: category
2015-07-08	17:33:03	0	[DEBUG]	Source: fromupload
2015-07-08	17:33:03	0	[DEBUG]	Load from computer: /home/qttest/public_html/tmp/com_csvi/1436376773/cats2.csv
2015-07-08	17:33:03	0	[DEBUG]	Load from server:
2015-07-08	17:33:03	0	[DEBUG]	Delete after import: No
2015-07-08	17:33:03	0	[DEBUG]	Load from URL:
2015-07-08	17:33:03	0	[DEBUG]	FTP Host:
2015-07-08	17:33:03	0	[DEBUG]	FTP Port:
2015-07-08	17:33:03	0	[DEBUG]	FTP Root Folder:
2015-07-08	17:33:03	0	[DEBUG]	FTP Filename:
2015-07-08	17:33:03	0	[DEBUG]	Auto detect delimiters: No
2015-07-08	17:33:03	0	[DEBUG]	Field Delimiter: ;
2015-07-08	17:33:03	0	[DEBUG]	Text Enclosure:
2015-07-08	17:33:03	0	[DEBUG]	Use file extension:
2015-07-08	17:33:03	0	[DEBUG]	I'm Mac: No
2015-07-08	17:33:03	0	[DEBUG]	Use file for configuration: Yes
2015-07-08	17:33:03	0	[DEBUG]	Add extra fields: No
2015-07-08	17:33:03	0	[DEBUG]	Skip first line: No
2015-07-08	17:33:03	0	[DEBUG]	Overwrite existing data: Yes
2015-07-08	17:33:03	0	[DEBUG]	Skip new items: No
2015-07-08	17:33:03	0	[DEBUG]	Record name:
2015-07-08	17:33:03	0	[DEBUG]	Language: en-GB
2015-07-08	17:33:03	0	[DEBUG]	Translation language: en-GB
2015-07-08	17:33:03	0	[DEBUG]	Category separator: \
2015-07-08	17:33:03	0	[DEBUG]	Recreate alias: Yes
2015-07-08	17:33:03	0	[DEBUG]	Process images: No
2015-07-08	17:33:03	0	[DEBUG]	Location category images:
2015-07-08	17:33:03	0	[DEBUG]	Change case: none
2015-07-08	17:33:03	0	[DEBUG]	Fill media fields: No
2015-07-08	17:33:03	0	[DEBUG]	Keep original file: No
2015-07-08	17:33:03	0	[DEBUG]	Convert image type: none
2015-07-08	17:33:03	0	[DEBUG]	Save images on server: No
2015-07-08	17:33:03	0	[DEBUG]	Re-download image: Yes
2015-07-08	17:33:03	0	[DEBUG]	Resize large image: No
2015-07-08	17:33:03	0	[DEBUG]	Full image width:
2015-07-08	17:33:03	0	[DEBUG]	Full image height:
2015-07-08	17:33:03	0	[DEBUG]	Check filetype: No
2015-07-08	17:33:03	0	[DEBUG]	Automatic thumbnail creation: No
2015-07-08	17:33:03	0	[DEBUG]	Thumbnail type: none
2015-07-08	17:33:03	0	[DEBUG]	Thumbnail width: 90
2015-07-08	17:33:03	0	[DEBUG]	Thumbnail height: 90
2015-07-08	17:33:03	0	[DEBUG]	Maximum width resize: 1024
2015-07-08	17:33:03	0	[DEBUG]	Maximum height resize: 768
2015-07-08	17:33:03	0	[DEBUG]	Watermark: No
2015-07-08	17:33:03	0	[DEBUG]	Right margin:
2015-07-08	17:33:03	0	[DEBUG]	Bottom margin:
2015-07-08	17:33:03	0	[DEBUG]	Image:
2015-07-08	17:33:03	0	[DEBUG]	Lines per import: 500
2015-07-08	17:33:03	0	[DEBUG]	Time between imports: 5
2015-07-08	17:33:03	0	[DEBUG]	Override system limits?: Yes
2015-07-08	17:33:03	0	[DEBUG]	Maximum execution time: 60
2015-07-08	17:33:03	0	[DEBUG]	Maximum amount of memory:
2015-07-08	17:33:03	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-07-08	17:33:03	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-07-08	17:33:03	0	[DEBUG]	==========
2015-07-08	17:33:03	0	[DEBUG]	Setting system limits:
2015-07-08	17:33:03	0	[QUERY]	SELECT `config` FROM `y9zak_virtuemart_configs` WHERE `virtuemart_config_id` = 1
2015-07-08	17:33:03	0	[DEBUG]	Setting max_execution_time to 60 seconds
2015-07-08	17:33:03	0	[QUERY]	SELECT `config` FROM `y9zak_virtuemart_configs` WHERE `virtuemart_config_id` = 1
2015-07-08	17:33:03	1	[DEBUG]	Use field value for field category_path
2015-07-08	17:33:03	1	[DEBUG]	Use field value for field category_template
2015-07-08	17:33:03	1	[DEBUG]	Use field value for field products_per_row
2015-07-08	17:33:03	1	[DEBUG]	Use field value for field metaauthor
2015-07-08	17:33:03	1	[DEBUG]	Use field value for field category_description
2015-07-08	17:33:03	1	[DEBUG]	Use default value for field metadesc
2015-07-08	17:33:03	1	[DEBUG]	Use default value for field metakey
2015-07-08	17:33:03	1	[DEBUG]	Use default value for field customtitle
2015-07-08	17:33:03	1	[DEBUG]	Use field value for field slug
2015-07-08	17:33:03	1	[DEBUG]	Use default value for field ordering
2015-07-08	17:33:03	1	[DEBUG]	Use field value for field published
2015-07-08	17:33:03	1	[DEBUG]	Process line 1
2015-07-08	17:33:03	1	[DEBUG]	Check if category path exists: Cars
2015-07-08	17:33:03	1	[QUERY]	SELECT `c`.`virtuemart_category_id` FROM `y9zak_virtuemart_categories` AS `c` LEFT JOIN `y9zak_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `y9zak_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Cars' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0
2015-07-08	17:33:03	1	[DEBUG]	Check if category path exists: BMW
2015-07-08	17:33:03	1	[QUERY]	SELECT `c`.`virtuemart_category_id` FROM `y9zak_virtuemart_categories` AS `c` LEFT JOIN `y9zak_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `y9zak_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'BMW' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 1
2015-07-08	17:33:03	1	[DEBUG]	Check if category path exists: BMW 5 Series
2015-07-08	17:33:03	1	[QUERY]	SELECT `c`.`virtuemart_category_id` FROM `y9zak_virtuemart_categories` AS `c` LEFT JOIN `y9zak_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `y9zak_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'BMW 5 Series' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 102
2015-07-08	17:33:03	1	[DEBUG]	Check if category path exists: BMW 5 Series Mk4 (E39) '96-'03
2015-07-08	17:33:03	1	[QUERY]	SELECT `c`.`virtuemart_category_id` FROM `y9zak_virtuemart_categories` AS `c` LEFT JOIN `y9zak_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `y9zak_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'BMW 5 Series Mk4 (E39) \'96-\'03' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 116
2015-07-08	17:33:03	1	[DEBUG]	Query for Category
2015-07-08	17:33:03	1	[QUERY]	UPDATE `y9zak_virtuemart_categories` SET `virtuemart_vendor_id`='1',`category_template`='default',`category_layout`=NULL,`category_product_layout`=NULL,`products_per_row`='3',`limit_list_step`=NULL,`limit_list_initial`=NULL,`hits`='0',`metarobot`='',`metaauthor`='Quality Tuning',`ordering`='0',`shared`='0',`published`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='2015-07-08 17:33:03',`modified_by`='937',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_category_id`='119'
2015-07-08	17:33:03	1	[DEBUG]	Load a row
2015-07-08	17:33:03	1	[DEBUG]	Check the category language
2015-07-08	17:33:03	1	[QUERY]	SELECT `virtuemart_category_id` FROM `y9zak_virtuemart_categories_en_gb` WHERE `virtuemart_category_id` = 119
2015-07-08	17:33:03	1	[DEBUG]	Check the category slug
2015-07-08	17:33:03	1	[QUERY]	SELECT COUNT(`virtuemart_category_id`) FROM `y9zak_virtuemart_categories_en_gb` WHERE `slug` = 'bmw-5-series-mk4-e39-96--03' AND `virtuemart_category_id` != 119
2015-07-08	17:33:03	1	[DEBUG]	Query for CategoryLang
2015-07-08	17:33:03	1	[QUERY]	UPDATE `y9zak_virtuemart_categories_en_gb` SET `category_name`='BMW 5 Series Mk4 (E39) \'96-\'03',`category_description`='{module 165}',`metadesc`='',`metakey`='',`customtitle`='',`slug`='bmw-5-series-mk4-e39-96--03' WHERE `virtuemart_category_id`='119'