1. roman5555
  2. RO CSVI
  3. Friday, 12 February 2016
  4.  Subscribe via email
Good day . Suddenly I have a problem with importing pictures. The problem arose after I switched to the https version of the site and CSVI updated to version 6.5.2. I do not know where the problem lies for so long import works well. My log is here.
thanks

[spoiler]#
#<?php die('Forbidden.'); ?>
#Date: 2016-02-12 09:49:22 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

#Fields: date time line_nr action comment
2016-02-12 09:49:22 0 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs
2016-02-12 09:49:22 0 [QUERY] SELECT csvi_log_id FROM dilima_csvi_logs ORDER BY csvi_log_id
2016-02-12 09:49:36 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs
2016-02-12 09:49:36 0 [QUERY] SELECT csvi_log_id FROM dilima_csvi_logs ORDER BY csvi_log_id
2016-02-12 09:49:37 0 [DEBUG] Found field delimiter: ,
2016-02-12 09:49:37 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import
2016-02-12 09:49:37 0 [QUERY] SELECT `a`.`csvi_name` FROM `dilima_csvi_availablefields` AS `a` LEFT JOIN `dilima_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'
2016-02-12 09:49:37 0 [DEBUG] Load the fields to process
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_sku
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_gtin
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_name
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_desc
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_s_desc
2016-02-12 09:49:37 0 [DEBUG] Setup field: manufacturer_name
2016-02-12 09:49:37 0 [DEBUG] Setup field: category_path
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_weight
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_price
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_tax_id
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_discount_id
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_in_stock
2016-02-12 09:49:37 0 [DEBUG] Setup field: product_availability
2016-02-12 09:49:37 0 [DEBUG] Setup field: published
2016-02-12 09:49:37 0 [DEBUG] Setup field: file_url
2016-02-12 09:49:37 0 [DEBUG] Setup field: file_title
2016-02-12 09:49:37 0 [DEBUG] Use the file for configuration
2016-02-12 09:49:37 0 [DEBUG] ==========
2016-02-12 09:49:37 0 [DEBUG] CSVI Pro Version: 6.5.2
2016-02-12 09:49:37 0 [DEBUG] PHP version: 5.6.5
2016-02-12 09:49:37 0 [DEBUG] Action: import
2016-02-12 09:49:37 0 [DEBUG] Component: com_virtuemart
2016-02-12 09:49:37 0 [DEBUG] Operation: product
2016-02-12 09:49:37 0 [DEBUG] Source: fromupload
2016-02-12 09:49:37 0 [DEBUG] Load from your computer: /nfsmnt/hosting2_2/6/6/66274bc3-cfad-418f-a995-c5782aecd631/http://svetbabatka.sk/web/tmp/com_csvi/1455270568/import_product.csv
2016-02-12 09:49:37 0 [DEBUG] Load from server:
2016-02-12 09:49:37 0 [DEBUG] Delete after import: No
2016-02-12 09:49:37 0 [DEBUG] Load from URL: http://
2016-02-12 09:49:37 0 [DEBUG] FTP Host:
2016-02-12 09:49:37 0 [DEBUG] FTP Port:
2016-02-12 09:49:37 0 [DEBUG] FTP Root Folder:
2016-02-12 09:49:37 0 [DEBUG] FTP Filename:
2016-02-12 09:49:37 0 [DEBUG] Autodetect delimiters: Yes
2016-02-12 09:49:37 0 [DEBUG] Field Delimiter: comma
2016-02-12 09:49:37 0 [DEBUG] Text Enclosure:
2016-02-12 09:49:37 0 [DEBUG] Use file extension:
2016-02-12 09:49:37 0 [DEBUG] I'm Mac: No
2016-02-12 09:49:37 0 [DEBUG] Use file for configuration: Yes
2016-02-12 09:49:37 0 [DEBUG] Add extra fields: No
2016-02-12 09:49:37 0 [DEBUG] Skip first line: No
2016-02-12 09:49:37 0 [DEBUG] Overwrite existing data: Yes
2016-02-12 09:49:37 0 [DEBUG] Skip new items: No
2016-02-12 09:49:37 0 [DEBUG] Record name:
2016-02-12 09:49:37 0 [DEBUG] Language: sk-SK
2016-02-12 09:49:37 0 [DEBUG] Category separator: /
2016-02-12 09:49:37 0 [DEBUG] Append categories: No
2016-02-12 09:49:37 0 [DEBUG] Import based on: product_sku
2016-02-12 09:49:37 0 [DEBUG] Unpublish before import: No
2016-02-12 09:49:37 0 [DEBUG] Recreate alias: No
2016-02-12 09:49:37 0 [DEBUG] Delete custom fields relations: No
2016-02-12 09:49:37 0 [DEBUG] Use ICEcat data: No
2016-02-12 09:49:37 0 [DEBUG] Similar SKU search: No
2016-02-12 09:49:37 0 [DEBUG] Process images: Yes
2016-02-12 09:49:37 0 [DEBUG] Location product files: images/stories/virtuemart/product/
2016-02-12 09:49:37 0 [DEBUG] Delete image relations: No
2016-02-12 09:49:37 0 [DEBUG] Create image name: No
2016-02-12 09:49:37 0 [DEBUG] Image name based on: product_sku
2016-02-12 09:49:37 0 [DEBUG] Image name format: jpg
2016-02-12 09:49:37 0 [DEBUG] Change case: none
2016-02-12 09:49:37 0 [DEBUG] Fill media fields: Yes
2016-02-12 09:49:37 0 [DEBUG] Keep original file: No
2016-02-12 09:49:37 0 [DEBUG] Convert image type: none
2016-02-12 09:49:37 0 [DEBUG] Save images on server: Yes
2016-02-12 09:49:37 0 [DEBUG] Re-download image: Yes
2016-02-12 09:49:37 0 [DEBUG] Resize large image: No
2016-02-12 09:49:37 0 [DEBUG] Full image width:
2016-02-12 09:49:37 0 [DEBUG] Full image height:
2016-02-12 09:49:37 0 [DEBUG] Check filetype: No
2016-02-12 09:49:37 0 [DEBUG] Automatic thumbnail creation: Yes
2016-02-12 09:49:37 0 [DEBUG] Thumbnail type: none
2016-02-12 09:49:37 0 [DEBUG] Thumbnail width: No
2016-02-12 09:49:37 0 [DEBUG] Thumbnail height: 400
2016-02-12 09:49:37 0 [DEBUG] Maximum width resize: 1024
2016-02-12 09:49:37 0 [DEBUG] Maximum height resize: 768
2016-02-12 09:49:37 0 [DEBUG] Watermark: No
2016-02-12 09:49:37 0 [DEBUG] Right margin:
2016-02-12 09:49:37 0 [DEBUG] Bottom margin:
2016-02-12 09:49:37 0 [DEBUG] Image:
2016-02-12 09:49:37 0 [DEBUG] Lines per import: 1000
2016-02-12 09:49:37 0 [DEBUG] Time between imports: 5
2016-02-12 09:49:37 0 [DEBUG] Override system limits?: No
2016-02-12 09:49:37 0 [DEBUG] Maximum execution time:
2016-02-12 09:49:37 0 [DEBUG] Maximum amount of memory:
2016-02-12 09:49:37 0 [DEBUG] Maximum size of POST data in megabytes:
2016-02-12 09:49:37 0 [DEBUG] Maximum allowed size for uploaded files in megabytes:
2016-02-12 09:49:37 0 [DEBUG] ==========
2016-02-12 09:49:37 0 [DEBUG] Load the custom fields
2016-02-12 09:49:37 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`,`custom_parent_id`,`field_type`,TRIM(`custom_title`) AS `title`,`ordering` FROM `dilima_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X') ORDER BY `ordering`
2016-02-12 09:49:37 1 [DEBUG] Use field value for field product_sku
2016-02-12 09:49:37 1 [DEBUG] Use default value for field product_gtin
2016-02-12 09:49:37 1 [DEBUG] Use field value for field product_name
2016-02-12 09:49:37 1 [DEBUG] Use field value for field product_desc
2016-02-12 09:49:37 1 [DEBUG] Use field value for field product_s_desc
2016-02-12 09:49:37 1 [DEBUG] Use field value for field manufacturer_name
2016-02-12 09:49:37 1 [DEBUG] Use field value for field category_path
2016-02-12 09:49:37 1 [DEBUG] Use field value for field product_weight
2016-02-12 09:49:37 1 [DEBUG] Use field value for field product_price
2016-02-12 09:49:37 1 [DEBUG] Use field value for field product_tax_id
2016-02-12 09:49:37 1 [DEBUG] Use field value for field product_discount_id
2016-02-12 09:49:37 1 [DEBUG] Use field value for field product_in_stock
2016-02-12 09:49:37 1 [DEBUG] Use default value for field product_availability
2016-02-12 09:49:37 1 [DEBUG] Use field value for field published
2016-02-12 09:49:37 1 [DEBUG] Use field value for field file_url
2016-02-12 09:49:37 1 [DEBUG] Use field value for field file_title
2016-02-12 09:49:37 1 [DEBUG] Process line 1
2016-02-12 09:49:37 1 [DEBUG] Check if the vendor exists
2016-02-12 09:49:37 1 [QUERY] SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `dilima_virtuemart_products` WHERE `product_sku` = '2547'
2016-02-12 09:49:37 1 [DEBUG] Load a row
2016-02-12 09:49:37 1 [DEBUG] Product tax:
2016-02-12 09:49:37 1 [DEBUG] Query for Product
2016-02-12 09:49:37 1 [QUERY] UPDATE `dilima_virtuemart_products` SET `virtuemart_product_id`='393',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_weight`='0.070000',`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`='19',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`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`='2016-02-12 08:59:24',`created_by`='338',`modified_on`='2016-02-12 09:49:37',`modified_by`='338',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='2547'
2016-02-12 09:49:37 1 [DEBUG] Check product language entry
2016-02-12 09:49:37 1 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `dilima_virtuemart_products_sk_sk` WHERE `virtuemart_product_id` = 393
2016-02-12 09:49:37 1 [DEBUG] Load a row
2016-02-12 09:49:37 1 [DEBUG] Check if the product slug exists
2016-02-12 09:49:37 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM dilima_virtuemart_products_sk_sk WHERE `slug` = 'dojcenske-polodupacky-new-baby-bezove-62-3-6m' AND `virtuemart_product_id` != 393
2016-02-12 09:49:37 1 [DEBUG] Query for ProductLang
2016-02-12 09:49:37 1 [QUERY] UPDATE `dilima_virtuemart_products_sk_sk` SET `product_s_desc`='Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko.',`product_desc`='<p>Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko. Zloženie: 100% bavlna. Rozmer: obvod okolo pásu cca 28 cm, obvod cez boky cca 46 cm, dĺžka od pása cca 39 cm, dĺžka od rozkroku cca 17 cm.</p>',`product_name`='Dojčenské polodupačky New Baby béžové 62 (3-6m)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='dojcenske-polodupacky-new-baby-bezove-62-3-6m' WHERE `virtuemart_product_id`='393'
2016-02-12 09:49:37 1 [DEBUG] Process remote file: http://www.velkoobchod.carero.sk/IMGCACHE/_0/126_0a.jpg
2016-02-12 09:49:37 1 [DEBUG] URL:http://www.velkoobchod.carero.sk/IMGCACHE/_0/126_0a.jpg
2016-02-12 09:49:37 1 [DEBUG] Opening socket to http://www.velkoobchod.carero.sk at port 80
2016-02-12 09:49:37 1 [DEBUG] HTTP response:HTTP/1.1 301 Moved Perma
2016-02-12 09:49:37 1 [DEBUG] Remote file does not exist: http://www.velkoobchod.carero.sk/IMGCACHE/_0/126_0a.jpg
2016-02-12 09:49:37 1 [DEBUG] Finding a product_price_id
2016-02-12 09:49:37 1 [QUERY] SELECT `virtuemart_product_price_id` FROM `dilima_virtuemart_product_prices` WHERE `virtuemart_product_id` = 393 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
2016-02-12 09:49:37 1 [DEBUG] Load a row
2016-02-12 09:49:37 1 [DEBUG] Query for ProductPrice
2016-02-12 09:49:37 1 [QUERY] UPDATE `dilima_virtuemart_product_prices` SET `virtuemart_product_id`='393',`virtuemart_shoppergroup_id`='0',`product_price`='3.35',`override`='0',`product_tax_id`='-1',`product_discount_id`='-1',`product_currency`='47',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`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_product_price_id`='383'
2016-02-12 09:49:37 1 [DEBUG] Checking manufacturer
2016-02-12 09:49:37 1 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 1 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers_sk_sk` WHERE `mf_name` = 'NEW BABY'
2016-02-12 09:49:37 1 [DEBUG] Load a row
2016-02-12 09:49:37 1 [DEBUG] Query for ManufacturerLang
2016-02-12 09:49:37 1 [QUERY] UPDATE `dilima_virtuemart_manufacturers_sk_sk` SET `mf_name`='NEW BABY',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='new-baby' WHERE `virtuemart_manufacturer_id`='24'
2016-02-12 09:49:37 1 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 1 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 24
2016-02-12 09:49:37 1 [DEBUG] Processing custom available field: Dojčenské topánky
2016-02-12 09:49:37 1 [DEBUG] Checking category
2016-02-12 09:49:37 1 [DEBUG] Check if category path exists: Eshop
2016-02-12 09:49:37 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `dilima_virtuemart_categories` AS `c` LEFT JOIN `dilima_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `dilima_virtuemart_categories_sk_sk` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Eshop' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0
2016-02-12 09:49:37 1 [DEBUG] Check if category path exists: Detský tovar
2016-02-12 09:49:37 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `dilima_virtuemart_categories` AS `c` LEFT JOIN `dilima_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `dilima_virtuemart_categories_sk_sk` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Detský tovar' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 259
2016-02-12 09:49:37 1 [DEBUG] Check if category path exists: Dojčenské potreby
2016-02-12 09:49:37 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `dilima_virtuemart_categories` AS `c` LEFT JOIN `dilima_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `dilima_virtuemart_categories_sk_sk` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Dojčenské potreby' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 256
2016-02-12 09:49:37 1 [DEBUG] Check if category path exists: Dojčenské oblečenie
2016-02-12 09:49:37 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `dilima_virtuemart_categories` AS `c` LEFT JOIN `dilima_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `dilima_virtuemart_categories_sk_sk` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Dojčenské oblečenie' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 257
2016-02-12 09:49:37 1 [DEBUG] Check if category path exists: Dojčenské dupačky
2016-02-12 09:49:37 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `dilima_virtuemart_categories` AS `c` LEFT JOIN `dilima_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `dilima_virtuemart_categories_sk_sk` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Dojčenské dupačky' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 255
2016-02-12 09:49:37 1 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF
2016-02-12 09:49:37 1 [QUERY] DELETE FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 393
2016-02-12 09:49:37 1 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 1 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 393 AND `virtuemart_category_id` = 259
2016-02-12 09:49:37 1 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 1 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('393','259')
2016-02-12 09:49:37 1 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('393','259')
2016-02-12 09:49:37 1 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 1 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 393 AND `virtuemart_category_id` = 256
2016-02-12 09:49:37 1 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 1 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('393','256','0')
2016-02-12 09:49:37 1 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('393','256','0')
2016-02-12 09:49:37 1 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 1 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 393 AND `virtuemart_category_id` = 257
2016-02-12 09:49:37 1 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 1 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('393','257','0')
2016-02-12 09:49:37 1 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('393','257','0')
2016-02-12 09:49:37 1 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 1 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 393 AND `virtuemart_category_id` = 255
2016-02-12 09:49:37 1 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 1 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('393','255','0')
2016-02-12 09:49:37 1 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('393','255','0')
2016-02-12 09:49:37 1 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 1 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 393 AND `virtuemart_category_id` = 282
2016-02-12 09:49:37 1 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 1 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('393','282','0')
2016-02-12 09:49:37 1 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 1 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('393','282','0')
2016-02-12 09:49:37 2 [DEBUG] Use field value for field product_sku
2016-02-12 09:49:37 2 [DEBUG] Use default value for field product_gtin
2016-02-12 09:49:37 2 [DEBUG] Use field value for field product_name
2016-02-12 09:49:37 2 [DEBUG] Use field value for field product_desc
2016-02-12 09:49:37 2 [DEBUG] Use field value for field product_s_desc
2016-02-12 09:49:37 2 [DEBUG] Use field value for field manufacturer_name
2016-02-12 09:49:37 2 [DEBUG] Use field value for field category_path
2016-02-12 09:49:37 2 [DEBUG] Use field value for field product_weight
2016-02-12 09:49:37 2 [DEBUG] Use field value for field product_price
2016-02-12 09:49:37 2 [DEBUG] Use field value for field product_tax_id
2016-02-12 09:49:37 2 [DEBUG] Use field value for field product_discount_id
2016-02-12 09:49:37 2 [DEBUG] Use field value for field product_in_stock
2016-02-12 09:49:37 2 [DEBUG] Use default value for field product_availability
2016-02-12 09:49:37 2 [DEBUG] Use field value for field published
2016-02-12 09:49:37 2 [DEBUG] Use field value for field file_url
2016-02-12 09:49:37 2 [DEBUG] Use field value for field file_title
2016-02-12 09:49:37 2 [DEBUG] Process line 2
2016-02-12 09:49:37 2 [DEBUG] Load a row
2016-02-12 09:49:37 2 [DEBUG] Product tax:
2016-02-12 09:49:37 2 [DEBUG] Query for Product
2016-02-12 09:49:37 2 [QUERY] UPDATE `dilima_virtuemart_products` SET `virtuemart_product_id`='394',`virtuemart_vendor_id`='1',`product_parent_id`='393',`product_weight`='0.070000',`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`='19',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`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`='2016-02-12 08:59:24',`created_by`='338',`modified_on`='2016-02-12 09:49:37',`modified_by`='338',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='2548'
2016-02-12 09:49:37 2 [DEBUG] Check product language entry
2016-02-12 09:49:37 2 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `dilima_virtuemart_products_sk_sk` WHERE `virtuemart_product_id` = 394
2016-02-12 09:49:37 2 [DEBUG] Load a row
2016-02-12 09:49:37 2 [DEBUG] Check if the product slug exists
2016-02-12 09:49:37 2 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM dilima_virtuemart_products_sk_sk WHERE `slug` = 'dojcenske-polodupacky-new-baby-modre-62-3-6m' AND `virtuemart_product_id` != 394
2016-02-12 09:49:37 2 [DEBUG] Query for ProductLang
2016-02-12 09:49:37 2 [QUERY] UPDATE `dilima_virtuemart_products_sk_sk` SET `product_s_desc`='Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko.',`product_desc`='<p>Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko. Zloženie: 100% bavlna. Rozmer: obvod okolo pásu cca 28 cm, obvod cez boky cca 46 cm, dĺžka od pása cca 39 cm, dĺžka od rozkroku cca 17 cm.</p>',`product_name`='Dojčenské polodupačky New Baby modré 62 (3-6m)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='dojcenske-polodupacky-new-baby-modre-62-3-6m' WHERE `virtuemart_product_id`='394'
2016-02-12 09:49:37 2 [DEBUG] Process remote file: http://www.velkoobchod.carero.sk/IMGCACHE/_0/127_0a.jpg
2016-02-12 09:49:37 2 [DEBUG] URL:http://www.velkoobchod.carero.sk/IMGCACHE/_0/127_0a.jpg
2016-02-12 09:49:37 2 [DEBUG] Opening socket to http://www.velkoobchod.carero.sk at port 80
2016-02-12 09:49:37 2 [DEBUG] HTTP response:HTTP/1.1 301 Moved Perma
2016-02-12 09:49:37 2 [DEBUG] Remote file does not exist: http://www.velkoobchod.carero.sk/IMGCACHE/_0/127_0a.jpg
2016-02-12 09:49:37 2 [DEBUG] Finding a product_price_id
2016-02-12 09:49:37 2 [QUERY] SELECT `virtuemart_product_price_id` FROM `dilima_virtuemart_product_prices` WHERE `virtuemart_product_id` = 394 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
2016-02-12 09:49:37 2 [DEBUG] Load a row
2016-02-12 09:49:37 2 [DEBUG] Query for ProductPrice
2016-02-12 09:49:37 2 [QUERY] UPDATE `dilima_virtuemart_product_prices` SET `virtuemart_product_id`='394',`virtuemart_shoppergroup_id`='0',`product_price`='3.35',`override`='0',`product_tax_id`='-1',`product_discount_id`='-1',`product_currency`='47',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`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_product_price_id`='384'
2016-02-12 09:49:37 2 [DEBUG] Checking manufacturer
2016-02-12 09:49:37 2 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 2 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers_sk_sk` WHERE `mf_name` = 'NEW BABY'
2016-02-12 09:49:37 2 [DEBUG] Load a row
2016-02-12 09:49:37 2 [DEBUG] Query for ManufacturerLang
2016-02-12 09:49:37 2 [QUERY] UPDATE `dilima_virtuemart_manufacturers_sk_sk` SET `mf_name`='NEW BABY',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='new-baby' WHERE `virtuemart_manufacturer_id`='24'
2016-02-12 09:49:37 2 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 2 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 24
2016-02-12 09:49:37 2 [DEBUG] Processing custom available field: Dojčenské topánky
2016-02-12 09:49:37 2 [DEBUG] Checking category
2016-02-12 09:49:37 2 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF
2016-02-12 09:49:37 2 [QUERY] DELETE FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 394
2016-02-12 09:49:37 2 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 2 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 394 AND `virtuemart_category_id` = 259
2016-02-12 09:49:37 2 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 2 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','259','0')
2016-02-12 09:49:37 2 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','259','0')
2016-02-12 09:49:37 2 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 2 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 394 AND `virtuemart_category_id` = 256
2016-02-12 09:49:37 2 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 2 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','256','0')
2016-02-12 09:49:37 2 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','256','0')
2016-02-12 09:49:37 2 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 2 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 394 AND `virtuemart_category_id` = 257
2016-02-12 09:49:37 2 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 2 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','257','0')
2016-02-12 09:49:37 2 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','257','0')
2016-02-12 09:49:37 2 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 2 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 394 AND `virtuemart_category_id` = 255
2016-02-12 09:49:37 2 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 2 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','255','0')
2016-02-12 09:49:37 2 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','255','0')
2016-02-12 09:49:37 2 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 2 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 394 AND `virtuemart_category_id` = 282
2016-02-12 09:49:37 2 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 2 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','282','0')
2016-02-12 09:49:37 2 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 2 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('394','282','0')
2016-02-12 09:49:37 3 [DEBUG] Use field value for field product_sku
2016-02-12 09:49:37 3 [DEBUG] Use default value for field product_gtin
2016-02-12 09:49:37 3 [DEBUG] Use field value for field product_name
2016-02-12 09:49:37 3 [DEBUG] Use field value for field product_desc
2016-02-12 09:49:37 3 [DEBUG] Use field value for field product_s_desc
2016-02-12 09:49:37 3 [DEBUG] Use field value for field manufacturer_name
2016-02-12 09:49:37 3 [DEBUG] Use field value for field category_path
2016-02-12 09:49:37 3 [DEBUG] Use field value for field product_weight
2016-02-12 09:49:37 3 [DEBUG] Use field value for field product_price
2016-02-12 09:49:37 3 [DEBUG] Use field value for field product_tax_id
2016-02-12 09:49:37 3 [DEBUG] Use field value for field product_discount_id
2016-02-12 09:49:37 3 [DEBUG] Use field value for field product_in_stock
2016-02-12 09:49:37 3 [DEBUG] Use default value for field product_availability
2016-02-12 09:49:37 3 [DEBUG] Use field value for field published
2016-02-12 09:49:37 3 [DEBUG] Use field value for field file_url
2016-02-12 09:49:37 3 [DEBUG] Use field value for field file_title
2016-02-12 09:49:37 3 [DEBUG] Process line 3
2016-02-12 09:49:37 3 [DEBUG] Load a row
2016-02-12 09:49:37 3 [DEBUG] Product tax:
2016-02-12 09:49:37 3 [DEBUG] Query for Product
2016-02-12 09:49:37 3 [QUERY] UPDATE `dilima_virtuemart_products` SET `virtuemart_product_id`='395',`virtuemart_vendor_id`='1',`product_parent_id`='393',`product_weight`='0.070000',`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`='4',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`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`='2016-02-12 08:59:24',`created_by`='338',`modified_on`='2016-02-12 09:49:37',`modified_by`='338',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='2551'
2016-02-12 09:49:37 3 [DEBUG] Check product language entry
2016-02-12 09:49:37 3 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `dilima_virtuemart_products_sk_sk` WHERE `virtuemart_product_id` = 395
2016-02-12 09:49:37 3 [DEBUG] Load a row
2016-02-12 09:49:37 3 [DEBUG] Check if the product slug exists
2016-02-12 09:49:37 3 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM dilima_virtuemart_products_sk_sk WHERE `slug` = 'dojcenske-polodupacky-new-baby-zlte-62-3-6m' AND `virtuemart_product_id` != 395
2016-02-12 09:49:37 3 [DEBUG] Query for ProductLang
2016-02-12 09:49:37 3 [QUERY] UPDATE `dilima_virtuemart_products_sk_sk` SET `product_s_desc`='Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko.',`product_desc`='<p>Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko. Zloženie: 100% bavlna. Rozmer: obvod okolo pásu cca 28 cm, obvod cez boky cca 46 cm, dĺžka od pása cca 39 cm, dĺžka od rozkroku cca 17 cm.</p>',`product_name`='Dojčenské polodupačky New Baby žlté 62 (3-6m)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='dojcenske-polodupacky-new-baby-zlte-62-3-6m' WHERE `virtuemart_product_id`='395'
2016-02-12 09:49:37 3 [DEBUG] Process remote file: http://www.velkoobchod.carero.sk/IMGCACHE/_0/130_0a.jpg
2016-02-12 09:49:37 3 [DEBUG] URL:http://www.velkoobchod.carero.sk/IMGCACHE/_0/130_0a.jpg
2016-02-12 09:49:37 3 [DEBUG] Opening socket to http://www.velkoobchod.carero.sk at port 80
2016-02-12 09:49:37 3 [DEBUG] HTTP response:HTTP/1.1 301 Moved Perma
2016-02-12 09:49:37 3 [DEBUG] Remote file does not exist: http://www.velkoobchod.carero.sk/IMGCACHE/_0/130_0a.jpg
2016-02-12 09:49:37 3 [DEBUG] Finding a product_price_id
2016-02-12 09:49:37 3 [QUERY] SELECT `virtuemart_product_price_id` FROM `dilima_virtuemart_product_prices` WHERE `virtuemart_product_id` = 395 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
2016-02-12 09:49:37 3 [DEBUG] Load a row
2016-02-12 09:49:37 3 [DEBUG] Query for ProductPrice
2016-02-12 09:49:37 3 [QUERY] UPDATE `dilima_virtuemart_product_prices` SET `virtuemart_product_id`='395',`virtuemart_shoppergroup_id`='0',`product_price`='3.35',`override`='0',`product_tax_id`='-1',`product_discount_id`='-1',`product_currency`='47',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`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_product_price_id`='385'
2016-02-12 09:49:37 3 [DEBUG] Checking manufacturer
2016-02-12 09:49:37 3 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 3 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers_sk_sk` WHERE `mf_name` = 'NEW BABY'
2016-02-12 09:49:37 3 [DEBUG] Load a row
2016-02-12 09:49:37 3 [DEBUG] Query for ManufacturerLang
2016-02-12 09:49:37 3 [QUERY] UPDATE `dilima_virtuemart_manufacturers_sk_sk` SET `mf_name`='NEW BABY',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='new-baby' WHERE `virtuemart_manufacturer_id`='24'
2016-02-12 09:49:37 3 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 3 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 24
2016-02-12 09:49:37 3 [DEBUG] Processing custom available field: Dojčenské topánky
2016-02-12 09:49:37 3 [DEBUG] Checking category
2016-02-12 09:49:37 3 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF
2016-02-12 09:49:37 3 [QUERY] DELETE FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 395
2016-02-12 09:49:37 3 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 3 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 395 AND `virtuemart_category_id` = 259
2016-02-12 09:49:37 3 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 3 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','259','0')
2016-02-12 09:49:37 3 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','259','0')
2016-02-12 09:49:37 3 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 3 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 395 AND `virtuemart_category_id` = 256
2016-02-12 09:49:37 3 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 3 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','256','0')
2016-02-12 09:49:37 3 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','256','0')
2016-02-12 09:49:37 3 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 3 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 395 AND `virtuemart_category_id` = 257
2016-02-12 09:49:37 3 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 3 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','257','0')
2016-02-12 09:49:37 3 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','257','0')
2016-02-12 09:49:37 3 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 3 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 395 AND `virtuemart_category_id` = 255
2016-02-12 09:49:37 3 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 3 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','255','0')
2016-02-12 09:49:37 3 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','255','0')
2016-02-12 09:49:37 3 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 3 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 395 AND `virtuemart_category_id` = 282
2016-02-12 09:49:37 3 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 3 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','282','0')
2016-02-12 09:49:37 3 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 3 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('395','282','0')
2016-02-12 09:49:37 4 [DEBUG] Use field value for field product_sku
2016-02-12 09:49:37 4 [DEBUG] Use default value for field product_gtin
2016-02-12 09:49:37 4 [DEBUG] Use field value for field product_name
2016-02-12 09:49:37 4 [DEBUG] Use field value for field product_desc
2016-02-12 09:49:37 4 [DEBUG] Use field value for field product_s_desc
2016-02-12 09:49:37 4 [DEBUG] Use field value for field manufacturer_name
2016-02-12 09:49:37 4 [DEBUG] Use field value for field category_path
2016-02-12 09:49:37 4 [DEBUG] Use field value for field product_weight
2016-02-12 09:49:37 4 [DEBUG] Use field value for field product_price
2016-02-12 09:49:37 4 [DEBUG] Use field value for field product_tax_id
2016-02-12 09:49:37 4 [DEBUG] Use field value for field product_discount_id
2016-02-12 09:49:37 4 [DEBUG] Use field value for field product_in_stock
2016-02-12 09:49:37 4 [DEBUG] Use default value for field product_availability
2016-02-12 09:49:37 4 [DEBUG] Use field value for field published
2016-02-12 09:49:37 4 [DEBUG] Use field value for field file_url
2016-02-12 09:49:37 4 [DEBUG] Use field value for field file_title
2016-02-12 09:49:37 4 [DEBUG] Process line 4
2016-02-12 09:49:37 4 [DEBUG] Load a row
2016-02-12 09:49:37 4 [DEBUG] Product tax:
2016-02-12 09:49:37 4 [DEBUG] Query for Product
2016-02-12 09:49:37 4 [QUERY] UPDATE `dilima_virtuemart_products` SET `virtuemart_product_id`='396',`virtuemart_vendor_id`='1',`product_parent_id`='393',`product_weight`='0.070000',`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`='2',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`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`='2016-02-12 08:59:24',`created_by`='338',`modified_on`='2016-02-12 09:49:37',`modified_by`='338',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='2552'
2016-02-12 09:49:37 4 [DEBUG] Check product language entry
2016-02-12 09:49:37 4 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `dilima_virtuemart_products_sk_sk` WHERE `virtuemart_product_id` = 396
2016-02-12 09:49:37 4 [DEBUG] Load a row
2016-02-12 09:49:37 4 [DEBUG] Check if the product slug exists
2016-02-12 09:49:37 4 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM dilima_virtuemart_products_sk_sk WHERE `slug` = 'dojcenske-polodupacky-new-baby-tyrkysove-62-3-6m' AND `virtuemart_product_id` != 396
2016-02-12 09:49:37 4 [DEBUG] Query for ProductLang
2016-02-12 09:49:37 4 [QUERY] UPDATE `dilima_virtuemart_products_sk_sk` SET `product_s_desc`='Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko.',`product_desc`='<p>Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko. Zloženie: 100% bavlna. Rozmer: obvod okolo pásu cca 28 cm, obvod cez boky cca 46 cm, dĺžka od pása cca 39 cm, dĺžka od rozkroku cca 17 cm.</p>',`product_name`='Dojčenské polodupačky New Baby tyrkysové 62 (3-6m)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='dojcenske-polodupacky-new-baby-tyrkysove-62-3-6m' WHERE `virtuemart_product_id`='396'
2016-02-12 09:49:37 4 [DEBUG] Process remote file: http://www.velkoobchod.carero.sk/IMGCACHE/_0/131_0a.jpg
2016-02-12 09:49:37 4 [DEBUG] URL:http://www.velkoobchod.carero.sk/IMGCACHE/_0/131_0a.jpg
2016-02-12 09:49:37 4 [DEBUG] Opening socket to http://www.velkoobchod.carero.sk at port 80
2016-02-12 09:49:37 4 [DEBUG] HTTP response:HTTP/1.1 301 Moved Perma
2016-02-12 09:49:37 4 [DEBUG] Remote file does not exist: http://www.velkoobchod.carero.sk/IMGCACHE/_0/131_0a.jpg
2016-02-12 09:49:37 4 [DEBUG] Finding a product_price_id
2016-02-12 09:49:37 4 [QUERY] SELECT `virtuemart_product_price_id` FROM `dilima_virtuemart_product_prices` WHERE `virtuemart_product_id` = 396 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
2016-02-12 09:49:37 4 [DEBUG] Load a row
2016-02-12 09:49:37 4 [DEBUG] Query for ProductPrice
2016-02-12 09:49:37 4 [QUERY] UPDATE `dilima_virtuemart_product_prices` SET `virtuemart_product_id`='396',`virtuemart_shoppergroup_id`='0',`product_price`='3.35',`override`='0',`product_tax_id`='-1',`product_discount_id`='-1',`product_currency`='47',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`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_product_price_id`='386'
2016-02-12 09:49:37 4 [DEBUG] Checking manufacturer
2016-02-12 09:49:37 4 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 4 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers_sk_sk` WHERE `mf_name` = 'NEW BABY'
2016-02-12 09:49:37 4 [DEBUG] Load a row
2016-02-12 09:49:37 4 [DEBUG] Query for ManufacturerLang
2016-02-12 09:49:37 4 [QUERY] UPDATE `dilima_virtuemart_manufacturers_sk_sk` SET `mf_name`='NEW BABY',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='new-baby' WHERE `virtuemart_manufacturer_id`='24'
2016-02-12 09:49:37 4 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 4 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 24
2016-02-12 09:49:37 4 [DEBUG] Processing custom available field: Dojčenské topánky
2016-02-12 09:49:37 4 [DEBUG] Checking category
2016-02-12 09:49:37 4 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF
2016-02-12 09:49:37 4 [QUERY] DELETE FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 396
2016-02-12 09:49:37 4 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 4 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 396 AND `virtuemart_category_id` = 259
2016-02-12 09:49:37 4 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 4 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','259','0')
2016-02-12 09:49:37 4 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','259','0')
2016-02-12 09:49:37 4 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 4 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 396 AND `virtuemart_category_id` = 256
2016-02-12 09:49:37 4 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 4 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','256','0')
2016-02-12 09:49:37 4 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','256','0')
2016-02-12 09:49:37 4 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 4 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 396 AND `virtuemart_category_id` = 257
2016-02-12 09:49:37 4 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 4 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','257','0')
2016-02-12 09:49:37 4 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','257','0')
2016-02-12 09:49:37 4 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 4 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 396 AND `virtuemart_category_id` = 255
2016-02-12 09:49:37 4 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 4 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','255','0')
2016-02-12 09:49:37 4 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','255','0')
2016-02-12 09:49:37 4 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 4 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 396 AND `virtuemart_category_id` = 282
2016-02-12 09:49:37 4 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 4 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','282','0')
2016-02-12 09:49:37 4 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 4 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('396','282','0')
2016-02-12 09:49:37 5 [DEBUG] Use field value for field product_sku
2016-02-12 09:49:37 5 [DEBUG] Use default value for field product_gtin
2016-02-12 09:49:37 5 [DEBUG] Use field value for field product_name
2016-02-12 09:49:37 5 [DEBUG] Use field value for field product_desc
2016-02-12 09:49:37 5 [DEBUG] Use field value for field product_s_desc
2016-02-12 09:49:37 5 [DEBUG] Use field value for field manufacturer_name
2016-02-12 09:49:37 5 [DEBUG] Use field value for field category_path
2016-02-12 09:49:37 5 [DEBUG] Use field value for field product_weight
2016-02-12 09:49:37 5 [DEBUG] Use field value for field product_price
2016-02-12 09:49:37 5 [DEBUG] Use field value for field product_tax_id
2016-02-12 09:49:37 5 [DEBUG] Use field value for field product_discount_id
2016-02-12 09:49:37 5 [DEBUG] Use field value for field product_in_stock
2016-02-12 09:49:37 5 [DEBUG] Use default value for field product_availability
2016-02-12 09:49:37 5 [DEBUG] Use field value for field published
2016-02-12 09:49:37 5 [DEBUG] Use field value for field file_url
2016-02-12 09:49:37 5 [DEBUG] Use field value for field file_title
2016-02-12 09:49:37 5 [DEBUG] Process line 5
2016-02-12 09:49:37 5 [DEBUG] Load a row
2016-02-12 09:49:37 5 [DEBUG] Product tax:
2016-02-12 09:49:37 5 [DEBUG] Query for Product
2016-02-12 09:49:37 5 [QUERY] UPDATE `dilima_virtuemart_products` SET `virtuemart_product_id`='397',`virtuemart_vendor_id`='1',`product_parent_id`='393',`product_weight`='0.070000',`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`='23',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`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`='2016-02-12 08:59:24',`created_by`='338',`modified_on`='2016-02-12 09:49:37',`modified_by`='338',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='2553'
2016-02-12 09:49:37 5 [DEBUG] Check product language entry
2016-02-12 09:49:37 5 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `dilima_virtuemart_products_sk_sk` WHERE `virtuemart_product_id` = 397
2016-02-12 09:49:37 5 [DEBUG] Load a row
2016-02-12 09:49:37 5 [DEBUG] Check if the product slug exists
2016-02-12 09:49:37 5 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM dilima_virtuemart_products_sk_sk WHERE `slug` = 'dojcenske-polodupacky-new-baby-bezove-68-4-6m' AND `virtuemart_product_id` != 397
2016-02-12 09:49:37 5 [DEBUG] Query for ProductLang
2016-02-12 09:49:37 5 [QUERY] UPDATE `dilima_virtuemart_products_sk_sk` SET `product_s_desc`='Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko.',`product_desc`='<p>Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko. Zloženie: 100% bavlna. Rozmer: obvod okolo pásu cca 29 cm, obvod cez boky cca 48 cm, dĺžka od pása cca 42 cm, dĺžka od rozkroku cca 19 cm.</p>',`product_name`='Dojčenské polodupačky New Baby béžové 68 (4-6m)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='dojcenske-polodupacky-new-baby-bezove-68-4-6m' WHERE `virtuemart_product_id`='397'
2016-02-12 09:49:37 5 [DEBUG] Process remote file: http://www.velkoobchod.carero.sk/IMGCACHE/_0/132_0a.jpg
2016-02-12 09:49:37 5 [DEBUG] URL:http://www.velkoobchod.carero.sk/IMGCACHE/_0/132_0a.jpg
2016-02-12 09:49:37 5 [DEBUG] Opening socket to http://www.velkoobchod.carero.sk at port 80
2016-02-12 09:49:37 5 [DEBUG] HTTP response:HTTP/1.1 301 Moved Perma
2016-02-12 09:49:37 5 [DEBUG] Remote file does not exist: http://www.velkoobchod.carero.sk/IMGCACHE/_0/132_0a.jpg
2016-02-12 09:49:37 5 [DEBUG] Finding a product_price_id
2016-02-12 09:49:37 5 [QUERY] SELECT `virtuemart_product_price_id` FROM `dilima_virtuemart_product_prices` WHERE `virtuemart_product_id` = 397 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
2016-02-12 09:49:37 5 [DEBUG] Load a row
2016-02-12 09:49:37 5 [DEBUG] Query for ProductPrice
2016-02-12 09:49:37 5 [QUERY] UPDATE `dilima_virtuemart_product_prices` SET `virtuemart_product_id`='397',`virtuemart_shoppergroup_id`='0',`product_price`='3.5',`override`='0',`product_tax_id`='-1',`product_discount_id`='-1',`product_currency`='47',`product_price_publish_up`='0000-00-00 00:00:00',`product_price_publish_down`='0000-00-00 00:00:00',`price_quantity_start`='0',`price_quantity_end`='0',`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_product_price_id`='387'
2016-02-12 09:49:37 5 [DEBUG] Checking manufacturer
2016-02-12 09:49:37 5 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 5 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers_sk_sk` WHERE `mf_name` = 'NEW BABY'
2016-02-12 09:49:37 5 [DEBUG] Load a row
2016-02-12 09:49:37 5 [DEBUG] Query for ManufacturerLang
2016-02-12 09:49:37 5 [QUERY] UPDATE `dilima_virtuemart_manufacturers_sk_sk` SET `mf_name`='NEW BABY',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='new-baby' WHERE `virtuemart_manufacturer_id`='24'
2016-02-12 09:49:37 5 [DEBUG] Manufacturer exists
2016-02-12 09:49:37 5 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `dilima_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 24
2016-02-12 09:49:37 5 [DEBUG] Processing custom available field: Dojčenské topánky
2016-02-12 09:49:37 5 [DEBUG] Checking category
2016-02-12 09:49:37 5 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF
2016-02-12 09:49:37 5 [QUERY] DELETE FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 397
2016-02-12 09:49:37 5 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 5 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 397 AND `virtuemart_category_id` = 259
2016-02-12 09:49:37 5 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 5 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','259','0')
2016-02-12 09:49:37 5 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','259','0')
2016-02-12 09:49:37 5 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 5 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 397 AND `virtuemart_category_id` = 256
2016-02-12 09:49:37 5 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 5 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','256','0')
2016-02-12 09:49:37 5 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','256','0')
2016-02-12 09:49:37 5 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 5 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 397 AND `virtuemart_category_id` = 257
2016-02-12 09:49:37 5 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 5 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','257','0')
2016-02-12 09:49:37 5 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','257','0')
2016-02-12 09:49:37 5 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 5 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 397 AND `virtuemart_category_id` = 255
2016-02-12 09:49:37 5 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 5 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','255','0')
2016-02-12 09:49:37 5 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','255','0')
2016-02-12 09:49:37 5 [DEBUG] Check if a category reference already exists
2016-02-12 09:49:37 5 [QUERY] SELECT COUNT(*) AS total FROM `dilima_virtuemart_product_categories` WHERE `virtuemart_product_id` = 397 AND `virtuemart_category_id` = 282
2016-02-12 09:49:37 5 [DEBUG] Category reference does not exist yet
2016-02-12 09:49:37 5 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','282','0')
2016-02-12 09:49:37 5 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
2016-02-12 09:49:37 5 [QUERY] INSERT INTO `dilima_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES ('397','282','0')
2016-02-12 09:49:37 6 [DEBUG] Use field value for field product_sku
2016-02-12 09:49:37 6 [DEBUG] Use default value for field product_gtin
2016-02-12 09:49:37 6 [DEBUG] Use field value for field product_name
2016-02-12 09:49:37 6 [DEBUG] Use field value for field product_desc
2016-02-12 09:49:37 6 [DEBUG] Use field value for field product_s_desc
2016-02-12 09:49:37 6 [DEBUG] Use field value for field manufacturer_name
2016-02-12 09:49:37 6 [DEBUG] Use field value for field category_path
2016-02-12 09:49:37 6 [DEBUG] Use field value for field product_weight
2016-02-12 09:49:37 6 [DEBUG] Use field value for field product_price
2016-02-12 09:49:37 6 [DEBUG] Use field value for field product_tax_id
2016-02-12 09:49:37 6 [DEBUG] Use field value for field product_discount_id
2016-02-12 09:49:37 6 [DEBUG] Use field value for field product_in_stock
2016-02-12 09:49:37 6 [DEBUG] Use default value for field product_availability
2016-02-12 09:49:37 6 [DEBUG] Use field value for field published
2016-02-12 09:49:37 6 [DEBUG] Use field value for field file_url
2016-02-12 09:49:37 6 [DEBUG] Use field value for field file_title
2016-02-12 09:49:37 6 [DEBUG] Process line 6
2016-02-12 09:49:37 6 [DEBUG] Load a row
2016-02-12 09:49:37 6 [DEBUG] Product tax:
2016-02-12 09:49:37 6 [DEBUG] Query for Product
2016-02-12 09:49:37 6 [QUERY] UPDATE `dilima_virtuemart_products` SET `virtuemart_product_id`='398',`virtuemart_vendor_id`='1',`product_parent_id`='393',`product_weight`='0.070000',`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`='19',`product_ordered`='0',`low_stock_notification`='0',`product_available_date`='0000-00-00 00:00:00',`product_availability`='',`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`='2016-02-12 08:59:24',`created_by`='338',`modified_on`='2016-02-12 09:49:37',`modified_by`='338',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `product_sku`='2555'
2016-02-12 09:49:37 6 [DEBUG] Check product language entry
2016-02-12 09:49:37 6 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `dilima_virtuemart_products_sk_sk` WHERE `virtuemart_product_id` = 398
2016-02-12 09:49:37 6 [DEBUG] Load a row
2016-02-12 09:49:37 6 [DEBUG] Check if the product slug exists
2016-02-12 09:49:37 6 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM dilima_virtuemart_products_sk_sk WHERE `slug` = 'dojcenske-polodupacky-new-baby-ruzove-68-4-6m' AND `virtuemart_product_id` != 398
2016-02-12 09:49:37 6 [DEBUG] Query for ProductLang
2016-02-12 09:49:37 6 [QUERY] UPDATE `dilima_virtuemart_products_sk_sk` SET `product_s_desc`='Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko.',`product_desc`='<p>Bavlnené polodupačky s sťahovacím pružným lemom v pastelových farbách pre Vaše bábätko. Zloženie: 100% bavlna. Rozmer: obvod okolo pásu cca 29 cm, obvod cez boky cca 48 cm, dĺžka od pása cca 42 cm, dĺžka od rozkroku cca 19 cm.</p>',`product_name`='Dojčenské polodupačky New Baby ružové 68 (4-6m)',`metadesc`='',`metakey`='',`customtitle`='',`slug`='dojcenske-polodupacky-new-baby-ruzove-68-4-6m' WHERE `virtuemart_product_id`='398'
2016-02-12 09:49:37 6 [DEBUG] Process remote file: http://www.velkoobchod.carero.sk/IMGCACHE/_0/134_0a.jpg
2016-02-12 09:49:37 6 [DEBUG] URL:http://www.velkoobchod.carero.sk/IMGCACHE/_0/134_0a.jpg
2016-02-12 09:49:37 6 [DEBUG] Opening socket to http://www.velkoobchod.carero.sk at port 80
2016-02-12 09:49:37 6 [DEBUG] HTTP response:HTTP/1.1 301 Moved Perma
2016-02-12 09:49:37 6 [DEBUG] Remote file does not exist: http://www.velkoobchod.carero.sk/IMGCACHE/_0/134_0a.jpg
2016-02-12 09:49:37 6 [DEBUG] Finding a product_price_id
2016-02-12 09:49:37 6 [QUERY] SELECT `virtuemart_product_price_id` FROM `dilima_virtuemart_product_prices` WHERE `virtuemart_product_id` = 398 AND `price_quantity_start` = 0 AND `price_quantity_end` = 0 AND `virtuemart_shoppergroup_id` = 0 AND `product_currency` = 47 AND `product_price_publish_up` = '0000-00-00 00:00:00' AND `product_price_publish_down` = '0000-00-00 00:00:00'
2016-02-12 09:49:37 6 [DEBUG] Load a row
2016-02-12 09:49:37 6 [DEBUG] Query for ProductPrice
2016-02-12 09:49:37 6 [QUERY] UPDATE `dilima_virtuemart_product_prices` SET [/spoiler]
Accepted Answer Pending Moderation
Hello,
The debug log shows that image URL is not valid because it is been redirected to another URL. Taking one example from the debug log, the actual URL is http://www.velkoobchod.carero.sk/IMGCACHE/_0/126_0a.jpg and its been redirected to http://velkoobchod.carero.sk/IMGCACHE/_0/126_0a.jpg, notice that the second URL has no www in it. So you need to remove www from your image URL to have it imported.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!