Details
Date	2015-03-08 01:29:50 UTC
Software	Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
Date	Time	Line	Action	Comment
Processed 63 lines
2015-03-08	01:29:50	0	[DEBUG]	Clean up old logs. Found 16 logs and threshold is 25 logs
2015-03-08	01:29:50	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-03-08	01:30:06	0	[DEBUG]	Clean up old logs. Found 16 logs and threshold is 25 logs
2015-03-08	01:30:06	0	[QUERY]	SELECT csvi_log_id FROM y9zak_csvi_logs ORDER BY csvi_log_id
2015-03-08	01:30:08	0	[DEBUG]	Found field delimiter: ;
2015-03-08	01:30:08	0	[DEBUG]	Loading the supported fields for com_virtuemart, operation rating and action import
2015-03-08	01:30:08	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` = 'rating' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2015-03-08	01:30:08	0	[DEBUG]	Load the fields to process
2015-03-08	01:30:08	0	[DEBUG]	Setup field: product_sku
2015-03-08	01:30:08	0	[DEBUG]	Setup field: comment
2015-03-08	01:30:08	0	[DEBUG]	Setup field: published
2015-03-08	01:30:08	0	[DEBUG]	Setup field: vote
2015-03-08	01:30:08	0	[DEBUG]	Setup field: username
2015-03-08	01:30:08	0	[DEBUG]	Use the file for configuration
2015-03-08	01:30:08	0	[DEBUG]	==========
2015-03-08	01:30:08	0	[DEBUG]	CSVI Pro Version: 6.0
2015-03-08	01:30:08	0	[DEBUG]	PHP version: 5.5.6
2015-03-08	01:30:08	0	[DEBUG]	Action: import
2015-03-08	01:30:08	0	[DEBUG]	Component: com_virtuemart
2015-03-08	01:30:08	0	[DEBUG]	Operation: rating
2015-03-08	01:30:08	0	[DEBUG]	Source: fromupload
2015-03-08	01:30:08	0	[DEBUG]	Load from computer: /home/qttest/public_html/tmp/com_csvi/1425778199/rating.csv
2015-03-08	01:30:08	0	[DEBUG]	Load from server:
2015-03-08	01:30:08	0	[DEBUG]	Delete after import: No
2015-03-08	01:30:08	0	[DEBUG]	Load from URL:
2015-03-08	01:30:08	0	[DEBUG]	FTP Host:
2015-03-08	01:30:08	0	[DEBUG]	FTP Port:
2015-03-08	01:30:08	0	[DEBUG]	FTP Root Folder:
2015-03-08	01:30:08	0	[DEBUG]	FTP Filename:
2015-03-08	01:30:08	0	[DEBUG]	Auto detect delimiters: Yes
2015-03-08	01:30:08	0	[DEBUG]	Field Delimiter: comma
2015-03-08	01:30:08	0	[DEBUG]	Text Enclosure:
2015-03-08	01:30:08	0	[DEBUG]	Use file extension:
2015-03-08	01:30:08	0	[DEBUG]	I'm Mac: No
2015-03-08	01:30:08	0	[DEBUG]	Use file for configuration: Yes
2015-03-08	01:30:08	0	[DEBUG]	Add extra fields: No
2015-03-08	01:30:08	0	[DEBUG]	Skip first line: No
2015-03-08	01:30:08	0	[DEBUG]	Overwrite existing data: Yes
2015-03-08	01:30:08	0	[DEBUG]	Skip new items: No
2015-03-08	01:30:08	0	[DEBUG]	Record name:
2015-03-08	01:30:08	0	[DEBUG]	Lines per import: 1000
2015-03-08	01:30:08	0	[DEBUG]	Time between imports: 5
2015-03-08	01:30:08	0	[DEBUG]	Override system limits?: No
2015-03-08	01:30:08	0	[DEBUG]	Maximum execution time:
2015-03-08	01:30:08	0	[DEBUG]	Maximum amount of memory:
2015-03-08	01:30:08	0	[DEBUG]	Maximum size of POST data in megabytes:
2015-03-08	01:30:08	0	[DEBUG]	Maximum allowed size for uploaded files in megabytes:
2015-03-08	01:30:08	0	[DEBUG]	==========
2015-03-08	01:30:08	1	[DEBUG]	Use field value for field product_sku
2015-03-08	01:30:08	1	[DEBUG]	Use field value for field comment
2015-03-08	01:30:08	1	[DEBUG]	Use field value for field published
2015-03-08	01:30:08	1	[DEBUG]	Use field value for field vote
2015-03-08	01:30:08	1	[DEBUG]	Use field value for field username
2015-03-08	01:30:08	1	[DEBUG]	Process line 1
2015-03-08	01:30:08	1	[DEBUG]	Find product ID based on product SKU
2015-03-08	01:30:08	1	[QUERY]	SELECT `virtuemart_product_id` FROM `y9zak_virtuemart_products` WHERE `product_sku` = 'BL206'
2015-03-08	01:30:08	1	[DEBUG]	COM_CSVI_CHECK_RATING_REVIEW_EXISTS
2015-03-08	01:30:08	1	[QUERY]	SELECT `virtuemart_rating_review_id` FROM `y9zak_virtuemart_rating_reviews` WHERE `virtuemart_product_id` = 33 AND `created_by` = 937
2015-03-08	01:30:08	1	[DEBUG]	Load a row
2015-03-08	01:30:08	1	[DEBUG]	COM_CSVI_CHECK_RATING_VOTE_EXISTS
2015-03-08	01:30:08	1	[QUERY]	SELECT `virtuemart_rating_vote_id` FROM `y9zak_virtuemart_rating_votes` WHERE `virtuemart_product_id` = 33 AND `created_by` = 937
2015-03-08	01:30:08	1	[DEBUG]	COM_CSVI_CHECK_RATING_EXISTS
2015-03-08	01:30:08	1	[QUERY]	SELECT `virtuemart_rating_id` FROM `y9zak_virtuemart_ratings` WHERE `virtuemart_product_id` = 33 AND `created_by` = 937