# # #Date: 2015-10-29 14:57:31 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2015-10-29 14:57:31 0 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs 2015-10-29 14:57:31 0 [QUERY] SELECT csvi_log_id FROM zlto4_csvi_logs ORDER BY csvi_log_id 2015-10-29 14:57:40 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2015-10-29 14:57:40 0 [QUERY] SELECT csvi_log_id FROM zlto4_csvi_logs ORDER BY csvi_log_id 2015-10-29 14:57:41 0 [DEBUG] Found text enclosure " 2015-10-29 14:57:41 0 [DEBUG] Found field delimiter: , 2015-10-29 14:57:41 0 [DEBUG] Loading the supported fields for com_virtuemart, operation media and action import 2015-10-29 14:57:41 0 [QUERY] SELECT `a`.`csvi_name` FROM `xxxx_csvi_availablefields` AS `a` LEFT JOIN `xxxx_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` = 'media' AND `a`.`action` = 'import' AND `t`.`action` = 'import' 2015-10-29 14:57:41 0 [DEBUG] Load the fields to process 2015-10-29 14:57:41 0 [DEBUG] Setup field: product_sku 2015-10-29 14:57:41 0 [DEBUG] Setup field: file_url 2015-10-29 14:57:41 0 [DEBUG] Setup field: file_url_thumb 2015-10-29 14:57:41 0 [DEBUG] Setup field: file_title 2015-10-29 14:57:41 0 [DEBUG] Setup field: file_description 2015-10-29 14:57:41 0 [DEBUG] Setup field: file_meta 2015-10-29 14:57:41 0 [DEBUG] Use the file for configuration 2015-10-29 14:57:41 0 [DEBUG] ========== 2015-10-29 14:57:41 0 [DEBUG] CSVI Pro Version: 6.3.0 2015-10-29 14:57:41 0 [DEBUG] PHP version: 5.5.29 2015-10-29 14:57:41 0 [DEBUG] Action: import 2015-10-29 14:57:41 0 [DEBUG] Component: com_virtuemart 2015-10-29 14:57:41 0 [DEBUG] Operation: media 2015-10-29 14:57:41 0 [DEBUG] Source: fromupload 2015-10-29 14:57:41 0 [DEBUG] Load from computer: /home/public_html/tmp/com_csvi/1446130657/import multiple images.txt 2015-10-29 14:57:41 0 [DEBUG] Load from server: 2015-10-29 14:57:41 0 [DEBUG] Delete after import: No 2015-10-29 14:57:41 0 [DEBUG] Load from URL: 2015-10-29 14:57:41 0 [DEBUG] FTP Host: 2015-10-29 14:57:41 0 [DEBUG] FTP Port: 2015-10-29 14:57:41 0 [DEBUG] FTP Root Folder: 2015-10-29 14:57:41 0 [DEBUG] FTP Filename: 2015-10-29 14:57:41 0 [DEBUG] Autodetect delimiters: Yes 2015-10-29 14:57:41 0 [DEBUG] Field Delimiter: comma 2015-10-29 14:57:41 0 [DEBUG] Text Enclosure: " 2015-10-29 14:57:41 0 [DEBUG] Use file extension: 2015-10-29 14:57:41 0 [DEBUG] I'm Mac: No 2015-10-29 14:57:41 0 [DEBUG] Use file for configuration: Yes 2015-10-29 14:57:41 0 [DEBUG] Add extra fields: No 2015-10-29 14:57:41 0 [DEBUG] Skip first line: No 2015-10-29 14:57:41 0 [DEBUG] Overwrite existing data: Yes 2015-10-29 14:57:41 0 [DEBUG] Skip new items: No 2015-10-29 14:57:41 0 [DEBUG] Record name: 2015-10-29 14:57:41 0 [DEBUG] Process images: Yes 2015-10-29 14:57:41 0 [DEBUG] Location product files: images/stories/virtuemart/product/ 2015-10-29 14:57:41 0 [DEBUG] Location category images: 2015-10-29 14:57:41 0 [DEBUG] Change case: none 2015-10-29 14:57:41 0 [DEBUG] Fill media fields: No 2015-10-29 14:57:41 0 [DEBUG] Keep original file: Yes 2015-10-29 14:57:41 0 [DEBUG] Convert image type: none 2015-10-29 14:57:41 0 [DEBUG] Save images on server: No 2015-10-29 14:57:41 0 [DEBUG] Re-download image: No 2015-10-29 14:57:41 0 [DEBUG] Resize large image: No 2015-10-29 14:57:41 0 [DEBUG] Full image width: 2015-10-29 14:57:41 0 [DEBUG] Full image height: 2015-10-29 14:57:41 0 [DEBUG] Check filetype: Yes 2015-10-29 14:57:41 0 [DEBUG] Automatic thumbnail creation: Yes 2015-10-29 14:57:41 0 [DEBUG] Thumbnail type: none 2015-10-29 14:57:41 0 [DEBUG] Thumbnail width: 256 2015-10-29 14:57:41 0 [DEBUG] Thumbnail height: 285 2015-10-29 14:57:41 0 [DEBUG] Maximum width resize: 1024 2015-10-29 14:57:41 0 [DEBUG] Maximum height resize: 768 2015-10-29 14:57:41 0 [DEBUG] Watermark: No 2015-10-29 14:57:41 0 [DEBUG] Right margin: 2015-10-29 14:57:41 0 [DEBUG] Bottom margin: 2015-10-29 14:57:41 0 [DEBUG] Image: 2015-10-29 14:57:41 0 [DEBUG] Lines per import: 1000 2015-10-29 14:57:41 0 [DEBUG] Time between imports: 5 2015-10-29 14:57:41 0 [DEBUG] Override system limits?: No 2015-10-29 14:57:41 0 [DEBUG] Maximum execution time: 2015-10-29 14:57:41 0 [DEBUG] Maximum amount of memory: 2015-10-29 14:57:41 0 [DEBUG] Maximum size of POST data in megabytes: 2015-10-29 14:57:41 0 [DEBUG] Maximum allowed size for uploaded files in megabytes: 2015-10-29 14:57:41 0 [DEBUG] ========== 2015-10-29 14:57:41 1 [DEBUG] Use field value for field product_sku 2015-10-29 14:57:41 1 [DEBUG] Use field value for field file_url 2015-10-29 14:57:41 1 [DEBUG] Use field value for field file_url_thumb 2015-10-29 14:57:41 1 [DEBUG] Use field value for field file_title 2015-10-29 14:57:41 1 [DEBUG] Use default value for field file_description 2015-10-29 14:57:41 1 [DEBUG] Use field value for field file_meta 2015-10-29 14:57:41 1 [DEBUG] Process line 1 2015-10-29 14:57:41 1 [DEBUG] Check if the vendor exists 2015-10-29 14:57:41 1 [QUERY] SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `xxxx_virtuemart_products` WHERE `product_sku` = 'alf259bp' 2015-10-29 14:57:41 1 [DEBUG] COM_CSVI_CREATED_FILE_URL 2015-10-29 14:57:41 1 [QUERY] SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `xxxx_virtuemart_products` WHERE `product_sku` = 'alf259bp' 2015-10-29 14:57:41 1 [DEBUG] Load a row 2015-10-29 14:57:41 1 [DEBUG] COM_CSVI_CREATED_FILE_URL 2015-10-29 14:57:41 1 [QUERY] SELECT * FROM xxxx_virtuemart_medias WHERE `virtuemart_media_id` = '27682' 2015-10-29 14:57:41 1 [DEBUG] Process file: /home/public_html/images/stories/virtuemart/product/Silver.jpg 2015-10-29 14:57:41 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101012c012c0000 2015-10-29 14:57:41 1 [DEBUG] Process image file 2015-10-29 14:57:41 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101012c012c0000 2015-10-29 14:57:41 1 [DEBUG] Mime type found: image/jpeg 2015-10-29 14:57:41 1 [DEBUG] Full name original: /home/public_html/images/stories/virtuemart/product/Silver.jpg 2015-10-29 14:57:41 1 [DEBUG] Full name target: images/stories/virtuemart/product/Silver.jpg 2015-10-29 14:57:41 1 [DEBUG] Check original file: /home/public_html/images/stories/virtuemart/product/Silver.jpg 2015-10-29 14:57:41 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101012c012c0000 2015-10-29 14:57:41 1 [DEBUG] Create thumbnail from /home/public_html/images/stories/virtuemart/product/Silver.jpg to /home/public_html/images/stories/virtuemart/product/resized/Silver-thumb.jpg 2015-10-29 14:57:41 1 [DEBUG] Save the new image 2015-10-29 14:57:41 1 [DEBUG] File out extension: jpg 2015-10-29 14:57:41 1 [DEBUG] File out: /home/public_html/images/stories/virtuemart/product/resized/Silver-thumb.jpg 2015-10-29 14:57:41 1 [DEBUG] Thumbnail created 2015-10-29 14:57:41 1 [DEBUG] Query for Media 2015-10-29 14:57:41 1 [QUERY] UPDATE `xxxx_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='Silver',`file_description`='images/stories/virtuemart/product/Silver.jpg',`file_meta`='Silver - Zilver - Argent - Silber',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/Silver.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/Silver-thumb.jpg',`file_is_product_image`='0',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='2015-10-29 14:57:41',`created_by`='62',`modified_on`='2015-10-29 14:57:41',`modified_by`='62',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id`='27682' 2015-10-29 14:57:41 1 [DEBUG] Find product ID based on product SKU 2015-10-29 14:57:41 1 [QUERY] SELECT `virtuemart_product_id` FROM `xxxx_virtuemart_products` WHERE `product_sku` = 'alf259bp' 2015-10-29 14:57:41 1 [DEBUG] Query for ProductMedia 2015-10-29 14:57:41 1 [QUERY] INSERT INTO `xxxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('2210','27682','0') 2015-10-29 14:57:41 2 [DEBUG] Use field value for field product_sku 2015-10-29 14:57:41 2 [DEBUG] Use field value for field file_url 2015-10-29 14:57:41 2 [DEBUG] Use field value for field file_url_thumb 2015-10-29 14:57:41 2 [DEBUG] Use field value for field file_title 2015-10-29 14:57:41 2 [DEBUG] Use default value for field file_description 2015-10-29 14:57:41 2 [DEBUG] Use field value for field file_meta 2015-10-29 14:57:41 2 [DEBUG] Process line 2 2015-10-29 14:57:41 2 [DEBUG] COM_CSVI_CREATED_FILE_URL 2015-10-29 14:57:41 2 [QUERY] SELECT `enabled` FROM `xxxx_extensions` WHERE `folder` = 'csvirules' AND `type` = 'plugin' AND `element` = 'replace' 2015-10-29 14:57:41 2 [DEBUG] Load a row 2015-10-29 14:57:41 2 [DEBUG] COM_CSVI_CREATED_FILE_URL 2015-10-29 14:57:41 2 [QUERY] SELECT * FROM xxxx_virtuemart_medias WHERE `virtuemart_media_id` = '27683' 2015-10-29 14:57:41 2 [DEBUG] Process file: /home/public_html/images/stories/virtuemart/product/Carbon.jpg 2015-10-29 14:57:41 2 [DEBUG] Identity string: ffd8ffe000104a46494600010101012c012c0000 2015-10-29 14:57:41 2 [DEBUG] Process image file 2015-10-29 14:57:41 2 [DEBUG] Identity string: ffd8ffe000104a46494600010101012c012c0000 2015-10-29 14:57:41 2 [DEBUG] Mime type found: image/jpeg 2015-10-29 14:57:41 2 [DEBUG] Full name original: /home/public_html/images/stories/virtuemart/product/Carbon.jpg 2015-10-29 14:57:41 2 [DEBUG] Full name target: images/stories/virtuemart/product/Carbon.jpg 2015-10-29 14:57:41 2 [DEBUG] Check original file: /home/public_html/images/stories/virtuemart/product/Carbon.jpg 2015-10-29 14:57:41 2 [DEBUG] Identity string: ffd8ffe000104a46494600010101012c012c0000 2015-10-29 14:57:41 2 [DEBUG] Create thumbnail from /home/public_html/images/stories/virtuemart/product/Carbon.jpg to /home/public_html/images/stories/virtuemart/product/resized/Carbon-thumb.jpg 2015-10-29 14:57:41 2 [DEBUG] Save the new image 2015-10-29 14:57:41 2 [DEBUG] File out extension: jpg 2015-10-29 14:57:41 2 [DEBUG] File out: /home/public_html/images/stories/virtuemart/product/resized/Carbon-thumb.jpg 2015-10-29 14:57:41 2 [DEBUG] Thumbnail created 2015-10-29 14:57:41 2 [DEBUG] Query for Media 2015-10-29 14:57:41 2 [QUERY] UPDATE `xxxx_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='Carbon',`file_description`='images/stories/virtuemart/product/Carbon.jpg',`file_meta`='Carbon',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='',`file_url`='images/stories/virtuemart/product/Carbon.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/Carbon-thumb.jpg',`file_is_product_image`='0',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='2015-10-29 14:57:41',`created_by`='62',`modified_on`='2015-10-29 14:57:41',`modified_by`='62',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id`='27683' 2015-10-29 14:57:41 2 [DEBUG] Find product ID based on product SKU 2015-10-29 14:57:41 2 [QUERY] SELECT `virtuemart_product_id` FROM `xxxx_virtuemart_products` WHERE `product_sku` = 'alf259bp' 2015-10-29 14:57:41 2 [DEBUG] Query for ProductMedia 2015-10-29 14:57:41 2 [QUERY] INSERT INTO `xxxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('2210','27683','0') 2015-10-29 14:57:41 3 [DEBUG] Use field value for field product_sku 2015-10-29 14:57:41 3 [DEBUG] Use field value for field file_url 2015-10-29 14:57:41 3 [DEBUG] Use field value for field file_url_thumb 2015-10-29 14:57:41 3 [DEBUG] Use field value for field file_title 2015-10-29 14:57:41 3 [DEBUG] Use default value for field file_description 2015-10-29 14:57:41 3 [DEBUG] Use field value for field file_meta 2015-10-29 14:57:41 3 [DEBUG] Process line 3 2015-10-29 14:57:41 3 [DEBUG] COM_CSVI_CREATED_FILE_URL 2015-10-29 14:57:41 3 [QUERY] SELECT `enabled` FROM `xxxx_extensions` WHERE `folder` = 'csvirules' AND `type` = 'plugin' AND `element` = 'replace' 2015-10-29 14:57:41 3 [DEBUG] Load a row 2015-10-29 14:57:41 3 [DEBUG] COM_CSVI_CREATED_FILE_URL 2015-10-29 14:57:41 3 [QUERY] SELECT * FROM xxxx_virtuemart_medias WHERE `virtuemart_media_id` = '27684' 2015-10-29 14:57:41 3 [DEBUG] Process file: /home/public_html/images/stories/virtuemart/product/Alloy.jpg 2015-10-29 14:57:41 3 [DEBUG] Identity string: ffd8ffe000104a46494600010101012c012c0000 2015-10-29 14:57:41 3 [DEBUG] Process image file 2015-10-29 14:57:41 3 [DEBUG] Identity string: ffd8ffe000104a46494600010101012c012c0000 2015-10-29 14:57:41 3 [DEBUG] Mime type found: image/jpeg 2015-10-29 14:57:41 3 [DEBUG] Full name original: /home/public_html/images/stories/virtuemart/product/Alloy.jpg 2015-10-29 14:57:41 3 [DEBUG] Full name target: images/stories/virtuemart/product/Alloy.jpg 2015-10-29 14:57:41 3 [DEBUG] Check original file: /home/public_html/images/stories/virtuemart/product/Alloy.jpg 2015-10-29 14:57:41 3 [DEBUG] Identity string: ffd8ffe000104a46494600010101012c012c0000 2015-10-29 14:57:41 3 [DEBUG] Create thumbnail from /home/public_html/images/stories/virtuemart/product/Alloy.jpg to /home/public_html/images/stories/virtuemart/product/resized/Alloy-thumb.jpg 2015-10-29 14:57:41 3 [DEBUG] Save the new image 2015-10-29 14:57:41 3 [DEBUG] File out extension: jpg 2015-10-29 14:57:41 3 [DEBUG] File out: /home/public_html/images/stories/virtuemart/product/resized/Alloy-thumb.jpg 2015-10-29 14:57:41 3 [DEBUG] Thumbnail created 2015-10-29 14:57:41 3 [DEBUG] Query for Media 2015-10-29 14:57:41 3 [QUERY] UPDATE `xxxx_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='Alloy',`file_description`='images/stories/virtuemart/product/Alloy.jpg',`file_meta`='Alloy',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='',`file_url`='images/stories/virtuemart/product/Alloy.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/Alloy-thumb.jpg',`file_is_product_image`='0',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='2015-10-29 14:57:41',`created_by`='62',`modified_on`='2015-10-29 14:57:41',`modified_by`='62',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id`='27684' 2015-10-29 14:57:41 3 [DEBUG] Find product ID based on product SKU 2015-10-29 14:57:41 3 [QUERY] SELECT `virtuemart_product_id` FROM `xxxx_virtuemart_products` WHERE `product_sku` = 'alf259bp' 2015-10-29 14:57:41 3 [DEBUG] Query for ProductMedia 2015-10-29 14:57:41 3 [QUERY] INSERT INTO `xxxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('2210','27684','0')