# # #Date: 2017-05-09 03:03:55 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2017-05-09 03:03:55 0 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs 2017-05-09 03:04:00 0 [DEBUG] Found text enclosure " 2017-05-09 03:04:00 0 [DEBUG] Found field delimiter: , 2017-05-09 03:04:00 0 [DEBUG] Found text enclosure " 2017-05-09 03:04:00 0 [DEBUG] Found field delimiter: , 2017-05-09 03:04:00 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2017-05-09 03:04:00 0 [QUERY] SELECT `a`.`csvi_name` FROM `agaok_csvi_availablefields` AS `a` LEFT JOIN `agaok_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' 2017-05-09 03:04:00 0 [DEBUG] Load the fields to process 2017-05-09 03:04:00 0 [DEBUG] Field name: manufacturer_name 2017-05-09 03:04:00 0 [DEBUG] Field name: product_sku 2017-05-09 03:04:00 0 [DEBUG] Field name: product_name 2017-05-09 03:04:00 0 [DEBUG] Field name: product_desc 2017-05-09 03:04:00 0 [DEBUG] Field name: skip 2017-05-09 03:04:00 0 [DEBUG] Field name: skip 2017-05-09 03:04:00 0 [DEBUG] Field name: product_price 2017-05-09 03:04:00 0 [DEBUG] Field name: skip 2017-05-09 03:04:00 0 [DEBUG] Field name: category_path 2017-05-09 03:04:00 0 [DEBUG] Field name: skip 2017-05-09 03:04:00 0 [DEBUG] Field name: skip 2017-05-09 03:04:00 0 [DEBUG] Field name: file_url 2017-05-09 03:04:00 0 [DEBUG] Field name: product_url 2017-05-09 03:04:00 0 [DEBUG] Field name: published 2017-05-09 03:04:00 0 [DEBUG] Use field value for field manufacturer_name 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_sku 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_name 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_desc 2017-05-09 03:04:00 0 [DEBUG] Use field value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_price 2017-05-09 03:04:00 0 [DEBUG] Use field value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field category_path 2017-05-09 03:04:00 0 [DEBUG] Use default value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use default value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field file_url 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_url 2017-05-09 03:04:00 0 [DEBUG] Use default value for field published 2017-05-09 03:04:00 0 [DEBUG] Use field value for field manufacturer_name 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_sku 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_name 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_desc 2017-05-09 03:04:00 0 [DEBUG] Use field value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_price 2017-05-09 03:04:00 0 [DEBUG] Use field value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field category_path 2017-05-09 03:04:00 0 [DEBUG] Use default value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use default value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field file_url 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_url 2017-05-09 03:04:00 0 [DEBUG] Use default value for field published 2017-05-09 03:04:00 0 [DEBUG] Use field value for field manufacturer_name 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_sku 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_name 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_desc 2017-05-09 03:04:00 0 [DEBUG] Use field value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_price 2017-05-09 03:04:00 0 [DEBUG] Use field value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field category_path 2017-05-09 03:04:00 0 [DEBUG] Use default value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use default value for field skip 2017-05-09 03:04:00 0 [DEBUG] Use field value for field file_url 2017-05-09 03:04:00 0 [DEBUG] Use field value for field product_url 2017-05-09 03:04:00 0 [DEBUG] Use default value for field published 2017-05-09 03:04:01 0 [DEBUG] Found text enclosure " 2017-05-09 03:04:01 0 [DEBUG] Found field delimiter: , 2017-05-09 03:04:01 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2017-05-09 03:04:01 0 [QUERY] SELECT `a`.`csvi_name` FROM `agaok_csvi_availablefields` AS `a` LEFT JOIN `agaok_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' 2017-05-09 03:04:01 0 [DEBUG] Load the fields to process 2017-05-09 03:04:01 0 [DEBUG] Field name: manufacturer_name 2017-05-09 03:04:01 0 [DEBUG] Field name: product_sku 2017-05-09 03:04:01 0 [DEBUG] Field name: product_name 2017-05-09 03:04:01 0 [DEBUG] Field name: product_desc 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: product_price 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: category_path 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: file_url 2017-05-09 03:04:01 0 [DEBUG] Field name: product_url 2017-05-09 03:04:01 0 [DEBUG] Field name: published 2017-05-09 03:04:01 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2017-05-09 03:04:01 0 [DEBUG] Found text enclosure " 2017-05-09 03:04:01 0 [DEBUG] Found field delimiter: , 2017-05-09 03:04:01 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2017-05-09 03:04:01 0 [QUERY] SELECT `a`.`csvi_name` FROM `agaok_csvi_availablefields` AS `a` LEFT JOIN `agaok_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' 2017-05-09 03:04:01 0 [DEBUG] Load the fields to process 2017-05-09 03:04:01 0 [DEBUG] Field name: manufacturer_name 2017-05-09 03:04:01 0 [DEBUG] Field name: product_sku 2017-05-09 03:04:01 0 [DEBUG] Field name: product_name 2017-05-09 03:04:01 0 [DEBUG] Field name: product_desc 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: product_price 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: category_path 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: skip 2017-05-09 03:04:01 0 [DEBUG] Field name: file_url 2017-05-09 03:04:01 0 [DEBUG] Field name: product_url 2017-05-09 03:04:01 0 [DEBUG] Field name: published 2017-05-09 03:04:01 0 [DEBUG] ========== 2017-05-09 03:04:01 0 [DEBUG] CSVI Pro Version: 7.1.0 2017-05-09 03:04:01 0 [DEBUG] PHP version: 7.0.10 2017-05-09 03:04:01 0 [DEBUG] Action: import 2017-05-09 03:04:01 0 [DEBUG] Component: com_virtuemart 2017-05-09 03:04:01 0 [DEBUG] Operation: product 2017-05-09 03:04:01 0 [DEBUG] Override: 2017-05-09 03:04:01 0 [DEBUG] Source: fromupload 2017-05-09 03:04:01 0 [DEBUG] Load from your computer: /home/xxx/domains/xxx/public_html/tmp/com_csvi/3301591798/dealerpricelist_2.csv 2017-05-09 03:04:01 0 [DEBUG] Load from server: 2017-05-09 03:04:01 0 [DEBUG] Delete after import: No 2017-05-09 03:04:01 0 [DEBUG] Load from URL: http:// 2017-05-09 03:04:01 0 [DEBUG] URL Username: 2017-05-09 03:04:01 0 [DEBUG] Name of username field: user 2017-05-09 03:04:01 0 [DEBUG] URL Password: 2017-05-09 03:04:01 0 [DEBUG] Name of the password field: password 2017-05-09 03:04:01 0 [DEBUG] Retrieve method: get 2017-05-09 03:04:01 0 [DEBUG] FTP Host: 2017-05-09 03:04:01 0 [DEBUG] FTP Port: 2017-05-09 03:04:01 0 [DEBUG] FTP Root Folder: 2017-05-09 03:04:01 0 [DEBUG] FTP Filename: 2017-05-09 03:04:01 0 [DEBUG] Username: 2017-05-09 03:04:01 0 [DEBUG] Host: 2017-05-09 03:04:01 0 [DEBUG] Port: 2017-05-09 03:04:01 0 [DEBUG] Database name: 2017-05-09 03:04:01 0 [DEBUG] Database table: 2017-05-09 03:04:01 0 [DEBUG] Autodetect delimiters: Yes 2017-05-09 03:04:01 0 [DEBUG] Field Delimiter: comma 2017-05-09 03:04:01 0 [DEBUG] Text Enclosure: " 2017-05-09 03:04:01 0 [DEBUG] Use file extension: 2017-05-09 03:04:01 0 [DEBUG] I'm Mac: Yes 2017-05-09 03:04:01 0 [DEBUG] Use file for configuration: No 2017-05-09 03:04:01 0 [DEBUG] Add extra fields: No 2017-05-09 03:04:01 0 [DEBUG] Skip first line: Yes 2017-05-09 03:04:01 0 [DEBUG] Overwrite existing data: Yes 2017-05-09 03:04:01 0 [DEBUG] Skip new items: No 2017-05-09 03:04:01 0 [DEBUG] Record name: 2017-05-09 03:04:01 0 [DEBUG] Language: en-GB 2017-05-09 03:04:01 0 [DEBUG] Category separator: / 2017-05-09 03:04:01 0 [DEBUG] Append categories: No 2017-05-09 03:04:01 0 [DEBUG] Import based on: product_sku 2017-05-09 03:04:01 0 [DEBUG] Unpublish before import: No 2017-05-09 03:04:01 0 [DEBUG] Recreate alias: No 2017-05-09 03:04:01 0 [DEBUG] Delete custom fields relations: No 2017-05-09 03:04:01 0 [DEBUG] Use ICEcat data: No 2017-05-09 03:04:01 0 [DEBUG] Similar SKU search: No 2017-05-09 03:04:01 0 [DEBUG] Number of images: 2017-05-09 03:04:01 0 [DEBUG] Download PDF files: No 2017-05-09 03:04:01 0 [DEBUG] Location product files: images/stories/virtuemart/product/ 2017-05-09 03:04:01 0 [DEBUG] Delete image relations: Yes 2017-05-09 03:04:01 0 [DEBUG] Create image name: No 2017-05-09 03:04:01 0 [DEBUG] Image name based on: product_name 2017-05-09 03:04:01 0 [DEBUG] Image name format: jpg 2017-05-09 03:04:01 0 [DEBUG] Change case: lcase 2017-05-09 03:04:01 0 [DEBUG] Fill media fields: Yes 2017-05-09 03:04:01 0 [DEBUG] Update media link only: No 2017-05-09 03:04:01 0 [DEBUG] Process images: Yes 2017-05-09 03:04:01 0 [DEBUG] Keep original file: Yes 2017-05-09 03:04:01 0 [DEBUG] Convert image type: jpg 2017-05-09 03:04:01 0 [DEBUG] Save images on server: Yes 2017-05-09 03:04:01 0 [DEBUG] Re-download image: Yes 2017-05-09 03:04:01 0 [DEBUG] Resize large image: Yes 2017-05-09 03:04:01 0 [DEBUG] Full image width: 800 2017-05-09 03:04:01 0 [DEBUG] Full image height: 600 2017-05-09 03:04:01 0 [DEBUG] Check filetype: No 2017-05-09 03:04:01 0 [DEBUG] Automatic thumbnail creation: Yes 2017-05-09 03:04:01 0 [DEBUG] Thumbnail type: jpg 2017-05-09 03:04:01 0 [DEBUG] Thumbnail width: 200 2017-05-09 03:04:01 0 [DEBUG] Thumbnail height: 200 2017-05-09 03:04:01 0 [DEBUG] Maximum width resize: 1024 2017-05-09 03:04:01 0 [DEBUG] Maximum height resize: 768 2017-05-09 03:04:01 0 [DEBUG] Watermark: No 2017-05-09 03:04:01 0 [DEBUG] Right margin: 2017-05-09 03:04:01 0 [DEBUG] Bottom margin: 2017-05-09 03:04:01 0 [DEBUG] Image: 2017-05-09 03:04:01 0 [DEBUG] Lines per import: 1000 2017-05-09 03:04:01 0 [DEBUG] Time between imports: 5 2017-05-09 03:04:01 0 [DEBUG] Override system limits?: No 2017-05-09 03:04:01 0 [DEBUG] Maximum execution time: 2017-05-09 03:04:01 0 [DEBUG] Maximum amount of memory: 2017-05-09 03:04:01 0 [DEBUG] Maximum size of POST data in megabytes: 2017-05-09 03:04:01 0 [DEBUG] Maximum allowed size for uploaded files in megabytes: 2017-05-09 03:04:01 0 [DEBUG] Template ID: 2 2017-05-09 03:04:01 0 [DEBUG] Tags: 2017-05-09 03:04:01 0 [DEBUG] ========== 2017-05-09 03:04:01 0 [DEBUG] Get all CF4All custom field title 2017-05-09 03:04:01 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`,TRIM(`custom_title`) AS `title`,`custom_parent_id`,`field_type`,`ordering` FROM `agaok_virtuemart_customs` WHERE `custom_element` = 'customfieldsforall' 2017-05-09 03:04:01 0 [DEBUG] Load the custom fields 2017-05-09 03:04:01 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`,TRIM(`custom_title`) AS `title`,`custom_parent_id`,`field_type`,`ordering` FROM `agaok_virtuemart_customs` WHERE `custom_element` = 'customfieldsforall' 2017-05-09 03:04:01 1 [DEBUG] Use field value for field manufacturer_name 2017-05-09 03:04:01 1 [DEBUG] Use field value for field product_sku 2017-05-09 03:04:01 1 [DEBUG] Use field value for field product_name 2017-05-09 03:04:01 1 [DEBUG] Use field value for field product_desc 2017-05-09 03:04:01 1 [DEBUG] Use field value for field skip 2017-05-09 03:04:01 1 [DEBUG] Use field value for field skip 2017-05-09 03:04:01 1 [DEBUG] Use field value for field product_price 2017-05-09 03:04:01 1 [DEBUG] Use field value for field skip 2017-05-09 03:04:01 1 [DEBUG] Use field value for field category_path 2017-05-09 03:04:01 1 [DEBUG] Use default value for field skip 2017-05-09 03:04:01 1 [DEBUG] Use default value for field skip 2017-05-09 03:04:01 1 [DEBUG] Use field value for field file_url 2017-05-09 03:04:01 1 [DEBUG] Use field value for field product_url 2017-05-09 03:04:01 1 [DEBUG] Use default value for field published 2017-05-09 03:04:01 1 [DEBUG] Process line 1 2017-05-09 03:04:01 1 [DEBUG] Check if the vendor exists 2017-05-09 03:04:01 1 [QUERY] SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `agaok_virtuemart_products` WHERE `product_sku` = '90-YAA0Q1-0AAN0BZ' 2017-05-09 03:04:01 1 [DEBUG] Load a row 2017-05-09 03:04:01 1 [DEBUG] Processing item: 90-YAA0Q1-0AAN0BZ 2017-05-09 03:04:01 1 [DEBUG] Product tax: 2017-05-09 03:04:01 1 [DEBUG] Query for Product 2017-05-09 03:04:01 1 [QUERY] INSERT INTO `agaok_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','0','90-YAA0Q1-0AAN0BZ','0','KG','0','0','0','M','http://www.dove.co.nz/jump/9716','0','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2017-05-09 03:04:01','473','2017-05-09 03:04:01','473','0000-00-00 00:00:00','0') 2017-05-09 03:04:01 1 [DEBUG] Check product language entry 2017-05-09 03:04:01 1 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `agaok_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 5040 2017-05-09 03:04:01 1 [DEBUG] Check if the product slug exists 2017-05-09 03:04:01 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM agaok_virtuemart_products_en_gb WHERE `slug` = 'asus-xonar-dgx-5-1-channel-pcie-gaming-audio-card' AND `virtuemart_product_id` != 5040 2017-05-09 03:04:01 1 [DEBUG] Check if the product slug exists 2017-05-09 03:04:01 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM agaok_virtuemart_products_en_gb WHERE `slug` = 'asus-xonar-dgx-5-1-channel-pcie-gaming-audio-card' AND `virtuemart_product_id` != 5040 2017-05-09 03:04:01 1 [DEBUG] Insert the dummy entry for the product language 2017-05-09 03:04:01 1 [QUERY] INSERT INTO `agaok_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (5040, 'asus-xonar-dgx-5-1-channel-pcie-gaming-audio-card') 2017-05-09 03:04:01 1 [DEBUG] Query for ProductLang 2017-05-09 03:04:01 1 [QUERY] UPDATE `agaok_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='Hear all, dominate all !\nBuilt-in amplifier for an optimal driving power for your headset\n- Dolby Headphone for an immersive 5.1 surround imaging \n- GX2.5 for realistic 3D audio effects\n- Automatic jack-sensing front-panel output\n- Bundled low-profile bracket for mini chassis\nSNR (dB) Higher = Better Up to 105dB (front-panel)\nTHDN Lower = Better 0.0025%\nHeadphone output power 2vrms',`product_name`='ASUS Xonar DGX 5.1 Channel PCIe Gaming Audio Card',`metadesc`='',`metakey`='',`customtitle`='',`slug`='asus-xonar-dgx-5-1-channel-pcie-gaming-audio-card' WHERE `virtuemart_product_id`='5040' 2017-05-09 03:04:01 1 [DEBUG] Delete images 2017-05-09 03:04:01 1 [QUERY] DELETE FROM `agaok_virtuemart_product_medias` WHERE `virtuemart_product_id`=5040 2017-05-09 03:04:01 1 [DEBUG] Process remote file: http://www.dove.co.nz/images/products/9716-48121411.jpg 2017-05-09 03:04:01 1 [DEBUG] URL:http://www.dove.co.nz/images/products/9716-48121411.jpg 2017-05-09 03:04:01 1 [DEBUG] Opening socket to www.dove.co.nz at port 80 2017-05-09 03:04:02 1 [DEBUG] HTTP response:HTTP/1.1 200 OK 2017-05-09 03:04:02 1 [DEBUG] Identity string: 89504e470d0a1a0a0000000d494844520000012c 2017-05-09 03:04:02 1 [DEBUG] Process image file 2017-05-09 03:04:02 1 [DEBUG] Current file: /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9716-48121411.jpg 2017-05-09 03:04:02 1 [DEBUG] Remote file stored: http://www.dove.co.nz/images/products/9716-48121411.jpg --> /home/xxx/domains/xxx/public_html/tmp/com_csvi/9716-48121411.jpg 2017-05-09 03:04:02 1 [DEBUG] Identity string: 89504e470d0a1a0a0000000d494844520000012c 2017-05-09 03:04:02 1 [DEBUG] Mime type found: image/png 2017-05-09 03:04:02 1 [DEBUG] Source extension is png and target extension is jpg 2017-05-09 03:04:02 1 [DEBUG] Renaming full image because bad extension: /home/xxx/domains/xxx/public_html/tmp/com_csvi/9716-48121411.jpg --> /home/xxx/domains/xxx/public_html/tmp/com_csvi/9716-48121411..png 2017-05-09 03:04:02 1 [DEBUG] Full name original: /home/xxx/domains/xxx/public_html/tmp/com_csvi/9716-48121411..png 2017-05-09 03:04:02 1 [DEBUG] Full name target: images/stories/virtuemart/product/9716-48121411.jpg 2017-05-09 03:04:02 1 [DEBUG] Store remote file on server /home/xxx/domains/xxx/public_html/tmp/com_csvi/9716-48121411..png --> /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9716-48121411.jpg 2017-05-09 03:04:02 1 [DEBUG] Check original file: /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9716-48121411.jpg 2017-05-09 03:04:02 1 [DEBUG] Identity string: 89504e470d0a1a0a0000000d494844520000012c 2017-05-09 03:04:02 1 [DEBUG] Create thumbnail from /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9716-48121411.jpg to /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/resized/9716-48121411.jpg 2017-05-09 03:04:02 1 [DEBUG] Save the new image 2017-05-09 03:04:02 1 [DEBUG] File out extension: jpg 2017-05-09 03:04:02 1 [DEBUG] File out: /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/resized/9716-48121411.jpg 2017-05-09 03:04:02 1 [DEBUG] Thumbnail created 2017-05-09 03:04:02 1 [DEBUG] Checking if the file_url exists 2017-05-09 03:04:02 1 [QUERY] SELECT `virtuemart_media_id` FROM `agaok_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/9716-48121411.jpg' 2017-05-09 03:04:02 1 [DEBUG] Query for Media 2017-05-09 03:04:02 1 [QUERY] UPDATE `agaok_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='9716-48121411.jpg',`file_description`='9716-48121411.jpg',`file_meta`='9716-48121411.jpg',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/9716-48121411.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/9716-48121411.jpg',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id`='2545' 2017-05-09 03:04:02 1 [DEBUG] Query for ProductMedia 2017-05-09 03:04:02 1 [QUERY] INSERT INTO `agaok_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('5040','2545','1') 2017-05-09 03:04:02 1 [DEBUG] Store product image relation 2017-05-09 03:04:02 1 [DEBUG] Finding a product_price_id 2017-05-09 03:04:02 1 [QUERY] SELECT `virtuemart_product_price_id` FROM `agaok_virtuemart_product_prices` WHERE `virtuemart_product_id` = 5040 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 107 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-05-09 03:04:02 1 [DEBUG] Query for ProductPrice 2017-05-09 03:04:02 1 [QUERY] INSERT INTO `agaok_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('5040','0','39','0','107','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2017-05-09 03:04:02 1 [DEBUG] Checking manufacturer 2017-05-09 03:04:02 1 [DEBUG] Delete product manufacturer references 2017-05-09 03:04:02 1 [QUERY] DELETE FROM `agaok_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = 5040 2017-05-09 03:04:02 1 [DEBUG] Manufacturer exists 2017-05-09 03:04:02 1 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `agaok_virtuemart_manufacturers_en_gb` WHERE `mf_name` = 'ASUS' 2017-05-09 03:04:02 1 [DEBUG] Load a row 2017-05-09 03:04:02 1 [DEBUG] Query for ManufacturerLang 2017-05-09 03:04:02 1 [QUERY] UPDATE `agaok_virtuemart_manufacturers_en_gb` SET `mf_name`='ASUS',`mf_email`='',`mf_desc`='',`mf_url`='',`metadesc`='',`metakey`='',`customtitle`='',`slug`='asus' WHERE `virtuemart_manufacturer_id`='1' 2017-05-09 03:04:02 1 [DEBUG] Manufacturer exists 2017-05-09 03:04:02 1 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `agaok_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 1 2017-05-09 03:04:02 1 [DEBUG] Query for ProductManufacturer 2017-05-09 03:04:02 1 [QUERY] INSERT INTO `agaok_virtuemart_product_manufacturers` (`virtuemart_product_id`,`virtuemart_manufacturer_id`) VALUES ('5040','1') 2017-05-09 03:04:02 1 [DEBUG] No custom available fields found 2017-05-09 03:04:02 1 [QUERY] INSERT INTO `agaok_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (45,1,'Product manufacturer reference added','Success','Added','Product manufacturer relations') 2017-05-09 03:04:02 1 [DEBUG] Checking category 2017-05-09 03:04:02 1 [DEBUG] Check if category path exists: Sound Cards 2017-05-09 03:04:02 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `agaok_virtuemart_categories` AS `c` LEFT JOIN `agaok_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `agaok_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Sound Cards' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0 2017-05-09 03:04:02 1 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF 2017-05-09 03:04:02 1 [QUERY] DELETE FROM `agaok_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5040 2017-05-09 03:04:02 1 [DEBUG] Check if a category reference already exists 2017-05-09 03:04:02 1 [QUERY] SELECT COUNT(*) AS total FROM `agaok_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5040 AND `virtuemart_category_id` = 117 2017-05-09 03:04:02 1 [DEBUG] Category reference does not exist yet 2017-05-09 03:04:02 1 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES 2017-05-09 03:04:02 1 [QUERY] INSERT INTO `agaok_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('5040','117') 2017-05-09 03:04:02 1 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED 2017-05-09 03:04:02 1 [QUERY] INSERT INTO `agaok_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('5040','117') 2017-05-09 03:04:02 2 [DEBUG] Use field value for field manufacturer_name 2017-05-09 03:04:02 2 [DEBUG] Use field value for field product_sku 2017-05-09 03:04:02 2 [DEBUG] Use field value for field product_name 2017-05-09 03:04:02 2 [DEBUG] Use field value for field product_desc 2017-05-09 03:04:02 2 [DEBUG] Use field value for field skip 2017-05-09 03:04:02 2 [DEBUG] Use field value for field skip 2017-05-09 03:04:02 2 [DEBUG] Use field value for field product_price 2017-05-09 03:04:02 2 [DEBUG] Use field value for field skip 2017-05-09 03:04:02 2 [DEBUG] Use field value for field category_path 2017-05-09 03:04:02 2 [DEBUG] Use default value for field skip 2017-05-09 03:04:02 2 [DEBUG] Use default value for field skip 2017-05-09 03:04:02 2 [DEBUG] Use field value for field file_url 2017-05-09 03:04:02 2 [DEBUG] Use field value for field product_url 2017-05-09 03:04:02 2 [DEBUG] Use default value for field published 2017-05-09 03:04:02 2 [DEBUG] Process line 2 2017-05-09 03:04:02 2 [DEBUG] Load a row 2017-05-09 03:04:02 2 [DEBUG] Processing item: 90-YAA0P1-0AAN0BZ 2017-05-09 03:04:02 2 [DEBUG] Product tax: 2017-05-09 03:04:02 2 [DEBUG] Query for Product 2017-05-09 03:04:02 2 [QUERY] INSERT INTO `agaok_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','0','90-YAA0P1-0AAN0BZ','0','KG','0','0','0','M','http://www.dove.co.nz/jump/9717','0','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2017-05-09 03:04:01','473','2017-05-09 03:04:01','473','0000-00-00 00:00:00','0') 2017-05-09 03:04:02 2 [DEBUG] Check product language entry 2017-05-09 03:04:02 2 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `agaok_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 5041 2017-05-09 03:04:02 2 [DEBUG] Check if the product slug exists 2017-05-09 03:04:02 2 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM agaok_virtuemart_products_en_gb WHERE `slug` = 'asus-xonar-dsx-7-1-channel-pcie-audio-card' AND `virtuemart_product_id` != 5041 2017-05-09 03:04:02 2 [DEBUG] Check if the product slug exists 2017-05-09 03:04:02 2 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM agaok_virtuemart_products_en_gb WHERE `slug` = 'asus-xonar-dsx-7-1-channel-pcie-audio-card' AND `virtuemart_product_id` != 5041 2017-05-09 03:04:02 2 [DEBUG] Insert the dummy entry for the product language 2017-05-09 03:04:02 2 [QUERY] INSERT INTO `agaok_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (5041, 'asus-xonar-dsx-7-1-channel-pcie-audio-card') 2017-05-09 03:04:02 2 [DEBUG] Query for ProductLang 2017-05-09 03:04:02 2 [QUERY] UPDATE `agaok_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='Hi-Fi spirit in your games, movies and music\n- DS3D GX 2.5 emulates EAX5\n- DTS connect brings theatre to your desktop\n- Eliminates 90% noisupgrading from on-board\n- Swappable Opamp socket\nSNR (dB) Higher = Better Front: >107\nTHDN Lower = Better 0.0017%\nHeadphone output power 2vrms',`product_name`='ASUS Xonar DSX 7.1 Channel PCIe Audio Card',`metadesc`='',`metakey`='',`customtitle`='',`slug`='asus-xonar-dsx-7-1-channel-pcie-audio-card' WHERE `virtuemart_product_id`='5041' 2017-05-09 03:04:02 2 [DEBUG] Delete images 2017-05-09 03:04:02 2 [QUERY] DELETE FROM `agaok_virtuemart_product_medias` WHERE `virtuemart_product_id`=5041 2017-05-09 03:04:02 2 [DEBUG] Process remote file: http://www.dove.co.nz/images/products/9717-2131411.jpg 2017-05-09 03:04:02 2 [DEBUG] URL:http://www.dove.co.nz/images/products/9717-2131411.jpg 2017-05-09 03:04:02 2 [DEBUG] Opening socket to www.dove.co.nz at port 80 2017-05-09 03:04:03 2 [DEBUG] HTTP response:HTTP/1.1 200 OK 2017-05-09 03:04:03 2 [DEBUG] Identity string: 89504e470d0a1a0a0000000d494844520000012c 2017-05-09 03:04:03 2 [DEBUG] Process image file 2017-05-09 03:04:03 2 [DEBUG] Current file: /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9717-2131411.jpg 2017-05-09 03:04:03 2 [DEBUG] Remote file stored: http://www.dove.co.nz/images/products/9717-2131411.jpg --> /home/xxx/domains/xxx/public_html/tmp/com_csvi/9717-2131411.jpg 2017-05-09 03:04:03 2 [DEBUG] Identity string: 89504e470d0a1a0a0000000d494844520000012c 2017-05-09 03:04:03 2 [DEBUG] Mime type found: image/png 2017-05-09 03:04:03 2 [DEBUG] Source extension is png and target extension is jpg 2017-05-09 03:04:03 2 [DEBUG] Renaming full image because bad extension: /home/xxx/domains/xxx/public_html/tmp/com_csvi/9717-2131411.jpg --> /home/xxx/domains/xxx/public_html/tmp/com_csvi/9717-2131411..png 2017-05-09 03:04:03 2 [DEBUG] Full name original: /home/xxx/domains/xxx/public_html/tmp/com_csvi/9717-2131411..png 2017-05-09 03:04:03 2 [DEBUG] Full name target: images/stories/virtuemart/product/9717-2131411.jpg 2017-05-09 03:04:03 2 [DEBUG] Store remote file on server /home/xxx/domains/xxx/public_html/tmp/com_csvi/9717-2131411..png --> /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9717-2131411.jpg 2017-05-09 03:04:03 2 [DEBUG] Check original file: /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9717-2131411.jpg 2017-05-09 03:04:03 2 [DEBUG] Identity string: 89504e470d0a1a0a0000000d494844520000012c 2017-05-09 03:04:03 2 [DEBUG] Create thumbnail from /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9717-2131411.jpg to /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/resized/9717-2131411.jpg 2017-05-09 03:04:03 2 [DEBUG] Save the new image 2017-05-09 03:04:03 2 [DEBUG] File out extension: jpg 2017-05-09 03:04:03 2 [DEBUG] File out: /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/resized/9717-2131411.jpg 2017-05-09 03:04:03 2 [DEBUG] Thumbnail created 2017-05-09 03:04:03 2 [DEBUG] Checking if the file_url exists 2017-05-09 03:04:03 2 [QUERY] SELECT `virtuemart_media_id` FROM `agaok_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/9717-2131411.jpg' 2017-05-09 03:04:03 2 [DEBUG] Query for Media 2017-05-09 03:04:03 2 [QUERY] UPDATE `agaok_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='9717-2131411.jpg',`file_description`='9717-2131411.jpg',`file_meta`='9717-2131411.jpg',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/9717-2131411.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/9717-2131411.jpg',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id`='2546' 2017-05-09 03:04:03 2 [DEBUG] Query for ProductMedia 2017-05-09 03:04:03 2 [QUERY] INSERT INTO `agaok_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('5041','2546','1') 2017-05-09 03:04:03 2 [DEBUG] Store product image relation 2017-05-09 03:04:03 2 [DEBUG] Finding a product_price_id 2017-05-09 03:04:03 2 [QUERY] SELECT `virtuemart_product_price_id` FROM `agaok_virtuemart_product_prices` WHERE `virtuemart_product_id` = 5041 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 107 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-05-09 03:04:03 2 [DEBUG] Query for ProductPrice 2017-05-09 03:04:03 2 [QUERY] INSERT INTO `agaok_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('5041','0','59','0','107','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2017-05-09 03:04:03 2 [DEBUG] Checking manufacturer 2017-05-09 03:04:03 2 [DEBUG] Delete product manufacturer references 2017-05-09 03:04:03 2 [QUERY] DELETE FROM `agaok_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = 5041 2017-05-09 03:04:03 2 [DEBUG] Manufacturer exists 2017-05-09 03:04:03 2 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `agaok_virtuemart_manufacturers_en_gb` WHERE `mf_name` = 'ASUS' 2017-05-09 03:04:03 2 [DEBUG] Load a row 2017-05-09 03:04:03 2 [DEBUG] Query for ManufacturerLang 2017-05-09 03:04:03 2 [QUERY] UPDATE `agaok_virtuemart_manufacturers_en_gb` SET `mf_name`='ASUS',`mf_email`='',`mf_desc`='',`mf_url`='',`metadesc`='',`metakey`='',`customtitle`='',`slug`='asus' WHERE `virtuemart_manufacturer_id`='1' 2017-05-09 03:04:03 2 [DEBUG] Manufacturer exists 2017-05-09 03:04:03 2 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `agaok_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 1 2017-05-09 03:04:03 2 [DEBUG] Query for ProductManufacturer 2017-05-09 03:04:03 2 [QUERY] INSERT INTO `agaok_virtuemart_product_manufacturers` (`virtuemart_product_id`,`virtuemart_manufacturer_id`) VALUES ('5041','1') 2017-05-09 03:04:03 2 [DEBUG] No custom available fields found 2017-05-09 03:04:03 2 [QUERY] INSERT INTO `agaok_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (45,2,'Product manufacturer reference added','Success','Added','Product manufacturer relations') 2017-05-09 03:04:03 2 [DEBUG] Checking category 2017-05-09 03:04:03 2 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF 2017-05-09 03:04:03 2 [QUERY] DELETE FROM `agaok_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5041 2017-05-09 03:04:03 2 [DEBUG] Check if a category reference already exists 2017-05-09 03:04:03 2 [QUERY] SELECT COUNT(*) AS total FROM `agaok_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5041 AND `virtuemart_category_id` = 117 2017-05-09 03:04:03 2 [DEBUG] Category reference does not exist yet 2017-05-09 03:04:03 2 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES 2017-05-09 03:04:03 2 [QUERY] INSERT INTO `agaok_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('5041','117','0') 2017-05-09 03:04:03 2 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED 2017-05-09 03:04:03 2 [QUERY] INSERT INTO `agaok_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('5041','117','0') 2017-05-09 03:04:03 3 [DEBUG] Use field value for field manufacturer_name 2017-05-09 03:04:03 3 [DEBUG] Use field value for field product_sku 2017-05-09 03:04:03 3 [DEBUG] Use field value for field product_name 2017-05-09 03:04:03 3 [DEBUG] Use field value for field product_desc 2017-05-09 03:04:03 3 [DEBUG] Use field value for field skip 2017-05-09 03:04:03 3 [DEBUG] Use field value for field skip 2017-05-09 03:04:03 3 [DEBUG] Use field value for field product_price 2017-05-09 03:04:03 3 [DEBUG] Use field value for field skip 2017-05-09 03:04:03 3 [DEBUG] Use field value for field category_path 2017-05-09 03:04:03 3 [DEBUG] Use default value for field skip 2017-05-09 03:04:03 3 [DEBUG] Use default value for field skip 2017-05-09 03:04:03 3 [DEBUG] Use field value for field file_url 2017-05-09 03:04:03 3 [DEBUG] Use field value for field product_url 2017-05-09 03:04:03 3 [DEBUG] Use default value for field published 2017-05-09 03:04:03 3 [DEBUG] Process line 3 2017-05-09 03:04:03 3 [DEBUG] Load a row 2017-05-09 03:04:03 3 [DEBUG] Processing item: 90-YAA060-1UAN0BZ 2017-05-09 03:04:03 3 [DEBUG] Product tax: 2017-05-09 03:04:03 3 [DEBUG] Query for Product 2017-05-09 03:04:03 3 [QUERY] INSERT INTO `agaok_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`product_stockhandle`,`low_stock_notification`,`product_available_date`,`product_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`pordering`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','0','90-YAA060-1UAN0BZ','0','KG','0','0','0','M','http://www.dove.co.nz/jump/9718','0','0','0','0','0000-00-00 00:00:00','','0','0','KG','0','min_order_level=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','1','0','2017-05-09 03:04:01','473','2017-05-09 03:04:01','473','0000-00-00 00:00:00','0') 2017-05-09 03:04:03 3 [DEBUG] Check product language entry 2017-05-09 03:04:03 3 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `agaok_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 5042 2017-05-09 03:04:03 3 [DEBUG] Check if the product slug exists 2017-05-09 03:04:03 3 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM agaok_virtuemart_products_en_gb WHERE `slug` = 'asus-xonar-dx-7-1-channel-pcie-audio-card' AND `virtuemart_product_id` != 5042 2017-05-09 03:04:03 3 [DEBUG] Check if the product slug exists 2017-05-09 03:04:03 3 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM agaok_virtuemart_products_en_gb WHERE `slug` = 'asus-xonar-dx-7-1-channel-pcie-audio-card' AND `virtuemart_product_id` != 5042 2017-05-09 03:04:03 3 [DEBUG] Insert the dummy entry for the product language 2017-05-09 03:04:03 3 [QUERY] INSERT INTO `agaok_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (5042, 'asus-xonar-dx-7-1-channel-pcie-audio-card') 2017-05-09 03:04:03 3 [DEBUG] Query for ProductLang 2017-05-09 03:04:03 3 [QUERY] UPDATE `agaok_virtuemart_products_en_gb` SET `product_s_desc`='',`product_desc`='Great Sound with EAX5 Support\n- Complete Dolby technologies\n- DS3D GX 2.0 emulates EAX5\n- ~35 times cleaner audio quality\nSNR (dB) Higher = Better Front: 116 Side: 112 \nTHDN Lower = Better Ultra High Fidelity 0.00056%\nHeadphone output power 2vrms',`product_name`='ASUS Xonar DX 7.1 Channel PCIe Audio Card',`metadesc`='',`metakey`='',`customtitle`='',`slug`='asus-xonar-dx-7-1-channel-pcie-audio-card' WHERE `virtuemart_product_id`='5042' 2017-05-09 03:04:03 3 [DEBUG] Delete images 2017-05-09 03:04:03 3 [QUERY] DELETE FROM `agaok_virtuemart_product_medias` WHERE `virtuemart_product_id`=5042 2017-05-09 03:04:03 3 [DEBUG] Process remote file: http://www.dove.co.nz/images/products/9718-13131411.jpg 2017-05-09 03:04:03 3 [DEBUG] URL:http://www.dove.co.nz/images/products/9718-13131411.jpg 2017-05-09 03:04:03 3 [DEBUG] Opening socket to www.dove.co.nz at port 80 2017-05-09 03:04:04 3 [DEBUG] HTTP response:HTTP/1.1 200 OK 2017-05-09 03:04:04 3 [DEBUG] Identity string: 89504e470d0a1a0a0000000d494844520000012c 2017-05-09 03:04:04 3 [DEBUG] Process image file 2017-05-09 03:04:04 3 [DEBUG] Current file: /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9718-13131411.jpg 2017-05-09 03:04:04 3 [DEBUG] Remote file stored: http://www.dove.co.nz/images/products/9718-13131411.jpg --> /home/xxx/domains/xxx/public_html/tmp/com_csvi/9718-13131411.jpg 2017-05-09 03:04:04 3 [DEBUG] Identity string: 89504e470d0a1a0a0000000d494844520000012c 2017-05-09 03:04:04 3 [DEBUG] Mime type found: image/png 2017-05-09 03:04:04 3 [DEBUG] Source extension is png and target extension is jpg 2017-05-09 03:04:04 3 [DEBUG] Renaming full image because bad extension: /home/xxx/domains/xxx/public_html/tmp/com_csvi/9718-13131411.jpg --> /home/xxx/domains/xxx/public_html/tmp/com_csvi/9718-13131411..png 2017-05-09 03:04:04 3 [DEBUG] Full name original: /home/xxx/domains/xxx/public_html/tmp/com_csvi/9718-13131411..png 2017-05-09 03:04:04 3 [DEBUG] Full name target: images/stories/virtuemart/product/9718-13131411.jpg 2017-05-09 03:04:04 3 [DEBUG] Store remote file on server /home/xxx/domains/xxx/public_html/tmp/com_csvi/9718-13131411..png --> /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9718-13131411.jpg 2017-05-09 03:04:04 3 [DEBUG] Check original file: /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9718-13131411.jpg 2017-05-09 03:04:04 3 [DEBUG] Identity string: 89504e470d0a1a0a0000000d494844520000012c 2017-05-09 03:04:04 3 [DEBUG] Create thumbnail from /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/9718-13131411.jpg to /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/resized/9718-13131411.jpg 2017-05-09 03:04:04 3 [DEBUG] Save the new image 2017-05-09 03:04:04 3 [DEBUG] File out extension: jpg 2017-05-09 03:04:04 3 [DEBUG] File out: /home/xxx/domains/xxx/public_html/images/stories/virtuemart/product/resized/9718-13131411.jpg 2017-05-09 03:04:04 3 [DEBUG] Thumbnail created 2017-05-09 03:04:04 3 [DEBUG] Checking if the file_url exists 2017-05-09 03:04:04 3 [QUERY] SELECT `virtuemart_media_id` FROM `agaok_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/9718-13131411.jpg' 2017-05-09 03:04:04 3 [DEBUG] Query for Media 2017-05-09 03:04:04 3 [QUERY] UPDATE `agaok_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='9718-13131411.jpg',`file_description`='9718-13131411.jpg',`file_meta`='9718-13131411.jpg',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/9718-13131411.jpg',`file_url_thumb`='images/stories/virtuemart/product/resized/9718-13131411.jpg',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='0000-00-00 00:00:00',`modified_by`='0',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_media_id`='2547' 2017-05-09 03:04:04 3 [DEBUG] Query for ProductMedia 2017-05-09 03:04:04 3 [QUERY] INSERT INTO `agaok_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('5042','2547','1') 2017-05-09 03:04:04 3 [DEBUG] Store product image relation 2017-05-09 03:04:04 3 [DEBUG] Finding a product_price_id 2017-05-09 03:04:04 3 [QUERY] SELECT `virtuemart_product_price_id` FROM `agaok_virtuemart_product_prices` WHERE `virtuemart_product_id` = 5042 AND (`price_quantity_start` = 0 OR `price_quantity_start` IS NULL) AND (`price_quantity_end` = 0 OR `price_quantity_end` IS NULL) AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 107 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00' 2017-05-09 03:04:04 3 [DEBUG] Query for ProductPrice 2017-05-09 03:04:04 3 [QUERY] INSERT INTO `agaok_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`product_price_publish_up`,`product_price_publish_down`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('5042','0','89','0','107','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2017-05-09 03:04:04 3 [DEBUG] Checking manufacturer 2017-05-09 03:04:04 3 [DEBUG] Delete product manufacturer references 2017-05-09 03:04:04 3 [QUERY] DELETE FROM `agaok_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = 5042 2017-05-09 03:04:04 3 [DEBUG] Manufacturer exists 2017-05-09 03:04:04 3 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `agaok_virtuemart_manufacturers_en_gb` WHERE `mf_name` = 'ASUS' 2017-05-09 03:04:04 3 [DEBUG] Load a row 2017-05-09 03:04:04 3 [DEBUG] Query for ManufacturerLang 2017-05-09 03:04:04 3 [QUERY] UPDATE `agaok_virtuemart_manufacturers_en_gb` SET `mf_name`='ASUS',`mf_email`='',`mf_desc`='',`mf_url`='',`metadesc`='',`metakey`='',`customtitle`='',`slug`='asus' WHERE `virtuemart_manufacturer_id`='1' 2017-05-09 03:04:04 3 [DEBUG] Manufacturer exists 2017-05-09 03:04:04 3 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `agaok_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 1 2017-05-09 03:04:04 3 [DEBUG] Query for ProductManufacturer 2017-05-09 03:04:04 3 [QUERY] INSERT INTO `agaok_virtuemart_product_manufacturers` (`virtuemart_product_id`,`virtuemart_manufacturer_id`) VALUES ('5042','1') 2017-05-09 03:04:04 3 [DEBUG] No custom available fields found 2017-05-09 03:04:04 3 [QUERY] INSERT INTO `agaok_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (45,3,'Product manufacturer reference added','Success','Added','Product manufacturer relations') 2017-05-09 03:04:04 3 [DEBUG] Checking category 2017-05-09 03:04:04 3 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF 2017-05-09 03:04:04 3 [QUERY] DELETE FROM `agaok_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5042 2017-05-09 03:04:04 3 [DEBUG] Check if a category reference already exists 2017-05-09 03:04:04 3 [QUERY] SELECT COUNT(*) AS total FROM `agaok_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5042 AND `virtuemart_category_id` = 117 2017-05-09 03:04:04 3 [DEBUG] Category reference does not exist yet 2017-05-09 03:04:04 3 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES 2017-05-09 03:04:04 3 [QUERY] INSERT INTO `agaok_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('5042','117','0') 2017-05-09 03:04:04 3 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED 2017-05-09 03:04:04 3 [QUERY] INSERT INTO `agaok_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('5042','117','0')