# # #Date: 2016-07-27 17:18:35 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2016-07-27 17:18:35 0 [DEBUG] Clean up old logs. Found 30 logs and threshold is 30 logs 2016-07-27 17:18:35 0 [QUERY] SELECT csvi_log_id FROM xxx_csvi_logs ORDER BY csvi_log_id 2016-07-27 17:19:14 0 [DEBUG] Clean up old logs. Found 30 logs and threshold is 30 logs 2016-07-27 17:19:14 0 [QUERY] SELECT csvi_log_id FROM xxx_csvi_logs ORDER BY csvi_log_id 2016-07-27 17:19:15 0 [DEBUG] Found field delimiter: ; 2016-07-27 17:19:15 0 [DEBUG] Loading the supported fields for com_virtuemart, operation product and action import 2016-07-27 17:19:15 0 [QUERY] SELECT `a`.`csvi_name` FROM `xxx_csvi_availablefields` AS `a` LEFT JOIN `xxx_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-07-27 17:19:15 0 [DEBUG] Load the fields to process 2016-07-27 17:19:15 0 [DEBUG] Field name: product_sku 2016-07-27 17:19:15 0 [DEBUG] Field name: product_gtin 2016-07-27 17:19:15 0 [DEBUG] Field name: product_name 2016-07-27 17:19:15 0 [DEBUG] Field name: category_path 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: product_desc 2016-07-27 17:19:15 0 [DEBUG] Field name: product_s_desc 2016-07-27 17:19:15 0 [DEBUG] Field name: product_weight 2016-07-27 17:19:15 0 [DEBUG] Field name: manufacturer_name 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: product_price 2016-07-27 17:19:15 0 [DEBUG] Field name: discountamount 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: file_url 2016-07-27 17:19:15 0 [DEBUG] Field name: combine260 2016-07-27 17:19:15 0 [DEBUG] Field name: combine261 2016-07-27 17:19:15 0 [DEBUG] Field name: combine262 2016-07-27 17:19:15 0 [DEBUG] Field name: combine263 2016-07-27 17:19:15 0 [DEBUG] Field name: combine264 2016-07-27 17:19:15 0 [DEBUG] Field name: combine265 2016-07-27 17:19:15 0 [DEBUG] Field name: combine266 2016-07-27 17:19:15 0 [DEBUG] Field name: combine267 2016-07-27 17:19:15 0 [DEBUG] Field name: combine268 2016-07-27 17:19:15 0 [DEBUG] Field name: product_in_stock 2016-07-27 17:19:15 0 [DEBUG] Field name: product_available_date 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: product_length 2016-07-27 17:19:15 0 [DEBUG] Field name: skip 2016-07-27 17:19:15 0 [DEBUG] Field name: min_order_level 2016-07-27 17:19:15 0 [DEBUG] Field name: related_products 2016-07-27 17:19:15 0 [DEBUG] Field name: features 2016-07-27 17:19:15 0 [DEBUG] ========== 2016-07-27 17:19:15 0 [DEBUG] CSVI Pro Version: 6.6.2 2016-07-27 17:19:15 0 [DEBUG] PHP version: 5.5.31 2016-07-27 17:19:15 0 [DEBUG] Action: import 2016-07-27 17:19:15 0 [DEBUG] Component: com_virtuemart 2016-07-27 17:19:15 0 [DEBUG] Operation: product 2016-07-27 17:19:15 0 [DEBUG] Override: 2016-07-27 17:19:15 0 [DEBUG] Source: fromupload 2016-07-27 17:19:15 0 [DEBUG] Load from your computer: /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/1469639933/Importazione_ice_25-07-16_philips.csv 2016-07-27 17:19:15 0 [DEBUG] Load from server: /home/xyz/domains/mysite.it/public_html/shoponline/import/prova.csv 2016-07-27 17:19:15 0 [DEBUG] Delete after import: No 2016-07-27 17:19:15 0 [DEBUG] Load from URL: http://shoponline.mysite.it/import/prova.csv 2016-07-27 17:19:15 0 [DEBUG] URL Username: 2016-07-27 17:19:15 0 [DEBUG] Name of username field: user 2016-07-27 17:19:15 0 [DEBUG] URL Password: 2016-07-27 17:19:15 0 [DEBUG] Name of the password field: password 2016-07-27 17:19:15 0 [DEBUG] Retrieve method: get 2016-07-27 17:19:15 0 [DEBUG] FTP Host: 2016-07-27 17:19:15 0 [DEBUG] FTP Port: 2016-07-27 17:19:15 0 [DEBUG] FTP Root Folder: 2016-07-27 17:19:15 0 [DEBUG] FTP Filename: 2016-07-27 17:19:15 0 [DEBUG] Autodetect delimiters: Yes 2016-07-27 17:19:15 0 [DEBUG] Field Delimiter: comma 2016-07-27 17:19:15 0 [DEBUG] Text Enclosure: 2016-07-27 17:19:15 0 [DEBUG] Use file extension: 2016-07-27 17:19:15 0 [DEBUG] I'm Mac: No 2016-07-27 17:19:15 0 [DEBUG] Use file for configuration: No 2016-07-27 17:19:15 0 [DEBUG] Add extra fields: No 2016-07-27 17:19:15 0 [DEBUG] Skip first line: Yes 2016-07-27 17:19:15 0 [DEBUG] Overwrite existing data: Yes 2016-07-27 17:19:15 0 [DEBUG] Skip new items: No 2016-07-27 17:19:15 0 [DEBUG] Record name: 2016-07-27 17:19:15 0 [DEBUG] Language: en-GB 2016-07-27 17:19:15 0 [DEBUG] Category separator: > 2016-07-27 17:19:15 0 [DEBUG] Append categories: No 2016-07-27 17:19:15 0 [DEBUG] Import based on: product_sku 2016-07-27 17:19:15 0 [DEBUG] Unpublish before import: No 2016-07-27 17:19:15 0 [DEBUG] Recreate alias: No 2016-07-27 17:19:15 0 [DEBUG] Delete custom fields relations: No 2016-07-27 17:19:15 0 [DEBUG] Use ICEcat data: Yes 2016-07-27 17:19:15 0 [DEBUG] Similar SKU search: No 2016-07-27 17:19:15 0 [DEBUG] Number of images: 2016-07-27 17:19:15 0 [DEBUG] Location product files: 2016-07-27 17:19:15 0 [DEBUG] Delete image relations: No 2016-07-27 17:19:15 0 [DEBUG] Create image name: No 2016-07-27 17:19:15 0 [DEBUG] Image name based on: product_sku 2016-07-27 17:19:15 0 [DEBUG] Image name format: jpg 2016-07-27 17:19:15 0 [DEBUG] Change case: none 2016-07-27 17:19:15 0 [DEBUG] Fill media fields: No 2016-07-27 17:19:15 0 [DEBUG] Update media link only: No 2016-07-27 17:19:15 0 [DEBUG] Process images: Yes 2016-07-27 17:19:15 0 [DEBUG] Keep original file: No 2016-07-27 17:19:15 0 [DEBUG] Convert image type: none 2016-07-27 17:19:15 0 [DEBUG] Save images on server: Yes 2016-07-27 17:19:15 0 [DEBUG] Re-download image: Yes 2016-07-27 17:19:15 0 [DEBUG] Resize large image: No 2016-07-27 17:19:15 0 [DEBUG] Full image width: 2016-07-27 17:19:15 0 [DEBUG] Full image height: 2016-07-27 17:19:15 0 [DEBUG] Check filetype: No 2016-07-27 17:19:15 0 [DEBUG] Automatic thumbnail creation: No 2016-07-27 17:19:15 0 [DEBUG] Thumbnail type: none 2016-07-27 17:19:15 0 [DEBUG] Thumbnail width: 90 2016-07-27 17:19:15 0 [DEBUG] Thumbnail height: 90 2016-07-27 17:19:15 0 [DEBUG] Maximum width resize: 1024 2016-07-27 17:19:15 0 [DEBUG] Maximum height resize: 768 2016-07-27 17:19:15 0 [DEBUG] Watermark: No 2016-07-27 17:19:15 0 [DEBUG] Right margin: 2016-07-27 17:19:15 0 [DEBUG] Bottom margin: 2016-07-27 17:19:15 0 [DEBUG] Image: 2016-07-27 17:19:15 0 [DEBUG] Lines per import: 50 2016-07-27 17:19:15 0 [DEBUG] Time between imports: 5 2016-07-27 17:19:15 0 [DEBUG] Override system limits?: No 2016-07-27 17:19:15 0 [DEBUG] Maximum execution time: 2016-07-27 17:19:15 0 [DEBUG] Maximum amount of memory: 2016-07-27 17:19:15 0 [DEBUG] Maximum size of POST data in megabytes: 2016-07-27 17:19:15 0 [DEBUG] Maximum allowed size for uploaded files in megabytes: 2016-07-27 17:19:15 0 [DEBUG] COM_CSVI_JFORM_csvi_template_id_LABEL: 14 2016-07-27 17:19:15 0 [DEBUG] COM_CSVI_JFORM_tags_LABEL: 2016-07-27 17:19:15 0 [DEBUG] ========== 2016-07-27 17:19:15 0 [DEBUG] Load the custom fields 2016-07-27 17:19:15 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`,`custom_parent_id`,`field_type`,TRIM(`custom_title`) AS `title`,`ordering` FROM `xxx_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X') ORDER BY `ordering` 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat mpn reference: 7099930PH 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat manufacturer name: Philips 2016-07-27 17:19:16 1 [DEBUG] Find the ICEcat ID for manufacturer Philips and part number 7099930PH 2016-07-27 17:19:16 1 [QUERY] SELECT product_id FROM `xxx_csvi_icecat_index` AS `i` LEFT JOIN `xxx_csvi_icecat_suppliers` AS `s` ON `s`.`supplier_id` = `i`.`supplier_id` WHERE `i`.`prod_id` = '7099930PH' AND `s`.`supplier_name` = 'Philips' 2016-07-27 17:19:16 1 [DEBUG] Calling ICEcat URL: http://data.icecat.biz/export/freexml.int/IT/16676901.xml 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Numero di lampadine 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Tecnologia lampadina 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Watt lampadina inclusa 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Durata della lampadina 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Angolo proiezione 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Colore variabile 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Dimmerabile 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Telecomando 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Stile 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Effetto luce diffusa 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Tipo di prodotto 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Compatibile con SmartLink 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Colore del prodotto 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Materiale della cassa 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Ambiente di utilizzo 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Codice IP (Marchio Internazionale Protezione) 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Classe di protezione 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Tensione di ingresso AC 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Frequenza di ingresso AC 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Tipo batteria 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Larghezza 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Profondità 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Altezza 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Peso 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Larghezza imballo 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Profondità imballo 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Altezza imballo 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Peso incluso imballo 2016-07-27 17:19:16 1 [DEBUG] Found ICEcat feature: Telecomando 2016-07-27 17:19:16 1 [DEBUG] Use field value for field product_sku 2016-07-27 17:19:16 1 [DEBUG] Use default value for field product_gtin 2016-07-27 17:19:16 1 [DEBUG] Use ICEcat field 2016-07-27 17:19:16 1 [DEBUG] Use field value for field category_path 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use ICEcat field 2016-07-27 17:19:16 1 [DEBUG] Use ICEcat field 2016-07-27 17:19:16 1 [DEBUG] Use default value for field product_weight 2016-07-27 17:19:16 1 [DEBUG] Use ICEcat field 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use field value for field product_price 2016-07-27 17:19:16 1 [DEBUG] Use default value for field discountamount 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use ICEcat field 2016-07-27 17:19:16 1 [DEBUG] Use default value for field combine 2016-07-27 17:19:16 1 [DEBUG] Use default value for field combine 2016-07-27 17:19:16 1 [DEBUG] Use default value for field combine 2016-07-27 17:19:16 1 [DEBUG] Use default value for field combine 2016-07-27 17:19:16 1 [DEBUG] Use default value for field combine 2016-07-27 17:19:16 1 [DEBUG] Use default value for field combine 2016-07-27 17:19:16 1 [DEBUG] Use default value for field combine 2016-07-27 17:19:16 1 [DEBUG] Use default value for field combine 2016-07-27 17:19:16 1 [DEBUG] Use default value for field combine 2016-07-27 17:19:16 1 [DEBUG] Use field value for field product_in_stock 2016-07-27 17:19:16 1 [DEBUG] Use ICEcat field 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use default value for field product_length 2016-07-27 17:19:16 1 [DEBUG] Use default value for field skip 2016-07-27 17:19:16 1 [DEBUG] Use field value for field min_order_level 2016-07-27 17:19:16 1 [DEBUG] Use default value for field related_products 2016-07-27 17:19:16 1 [DEBUG] Use ICEcat field 2016-07-27 17:19:16 1 [DEBUG] Process line 1 2016-07-27 17:19:16 1 [DEBUG] Check if the vendor exists 2016-07-27 17:19:16 1 [QUERY] SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1, `virtuemart_vendor_id`) AS vendor_id FROM `xxx_virtuemart_products` WHERE `product_sku` = '7099930PH' 2016-07-27 17:19:16 1 [DEBUG] Load a row 2016-07-27 17:19:16 1 [DEBUG] Processing item: 7099930PH 2016-07-27 17:19:16 1 [DEBUG] Product tax: 2016-07-27 17:19:16 1 [DEBUG] Query for Product 2016-07-27 17:19:16 1 [QUERY] INSERT INTO `xxx_virtuemart_products` (`virtuemart_vendor_id`,`product_parent_id`,`product_sku`,`product_gtin`,`product_weight`,`product_weight_uom`,`product_length`,`product_width`,`product_height`,`product_lwh_uom`,`product_url`,`product_in_stock`,`product_ordered`,`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','7099930PH','','0','KG','0','0','0','M','','10','0','0','2012-09-02 22:00:00','','0','0','KG','0','min_order_level=\"1\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|','0','','','','0','0','0','2016-07-27 17:19:15','1','2016-07-27 17:19:15','1','0000-00-00 00:00:00','0') 2016-07-27 17:19:16 1 [DEBUG] Check product language entry 2016-07-27 17:19:16 1 [QUERY] SELECT `virtuemart_product_id`,`slug` FROM `xxx_virtuemart_products_en_gb` WHERE `virtuemart_product_id` = 19576 2016-07-27 17:19:16 1 [DEBUG] Check if the product slug exists 2016-07-27 17:19:16 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM xxx_virtuemart_products_en_gb WHERE `slug` = 'lampada-da-tavolo' AND `virtuemart_product_id` != 19576 2016-07-27 17:19:16 1 [DEBUG] Check if the product slug exists 2016-07-27 17:19:16 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM xxx_virtuemart_products_en_gb WHERE `slug` = 'lampada-da-tavolo' AND `virtuemart_product_id` != 19576 2016-07-27 17:19:16 1 [DEBUG] Insert the dummy entry for the product language 2016-07-27 17:19:16 1 [QUERY] INSERT INTO `xxx_virtuemart_products_en_gb` (`virtuemart_product_id`,`slug`) VALUES (19576, 'lampada-da-tavolo') 2016-07-27 17:19:16 1 [DEBUG] Query for ProductLang 2016-07-27 17:19:16 1 [QUERY] UPDATE `xxx_virtuemart_products_en_gb` SET `product_s_desc`='10 W, 120°, LED, IP20, 100-240 V, 50/60 Hz, AAA, materiale sintetico, nero',`product_desc`='Lampada LED Philips LivingColors Iris. Design esclusivo senza tempo che completa gli interni della tua casa. Scegli col telecomando uno dei 16 milioni di colori e ammira la luce d\'atmosfera.


scegli tra 16.000.000 colori

Scegli il tuo colore preferito con la lampada LED LivingColors. 16.000.000 di combinazioni diverse disponibili per la perfetta luce d\'atmosfera.

modalità di modifica automatica del colore

Gira la ghiera dei colori a 360° e premi il pulsante \"I\"; rilassati e lascia che i colori della lampada LED cambino automaticamente.

luminosità regolabile

Regola la luminosità della lampada LED Philips LivingColors a tuo piacimento tramite il telecomando.

intensità del colore regolabile

Aggiungi più bianco al colore usando il telecomando per ottenere sfumature pastello perfette.

Intensità luminosa pari a 210 lumen

LivingColors Iris ha l\'intensità luminosa più potente di tutta la gamma LivingColors (210 lumen). Basta posizionare LivingColors Iris dove preferisci e direzionarlo verso una parete colorata, così da ottenere l\'effetto migliore.

telecomando facile da usare

Ruotando la ghiera dei colori sul telecomando della lampada LED Philips LivingColors, potrai scegliere facilmente tutti i colori che preferisci per un\'illuminazione d\'atmosfera perfetta.

2 pulsanti per memorizzare i colori preferiti

Memorizza i tuoi 2 colori preferiti; potrai selezionarli facilmente dagli appositi pulsanti del telecomando. Per memorizzare il colore, basta selezionarlo e tenere premuto uno dei due pulsanti appositi.

bellissimo effetto luce diffusa

Grazie all\'effetto luce diffusa, avrai nella tua stanza tanti colori naturali diversi con la lampada LivingColors LED di Philips.
Prestazione
Numero di lampadine1
Tecnologia lampadinaLED
Watt lampadina inclusa10 W
Durata della lampadina20000 h
Angolo proiezione120°
Colore variabileSi
DimmerabileSi
TelecomandoSi
StileEspressivo
Effetto luce diffusaSi
Tipo di prodottoLampada da tavolo
Compatibile con SmartLinkSi
Design
Colore del prodottoNero
Materiale della cassaPlastica
Ambiente di utilizzoCamera da letto, Cameretta dei bambini, Soggiorno
Codice IP (Marchio Internazionale Protezione)IP20
Classe di protezioneII
Gestione energetica
Tensione di ingresso AC100-240 V
Frequenza di ingresso AC50/60 Hz
Tipo batteriaAAA
Dimensioni e peso
Larghezza18,8 cm
Profondità18,5 cm
Altezza20 cm
Peso874 g
Larghezza imballo21,8 cm
Profondità imballo21,8 cm
Altezza imballo22,5 cm
Peso incluso imballo1,2 kg
Contenuto dell\'imballo
TelecomandoSi
',`product_name`='Lampada da tavolo',`metadesc`='',`metakey`='',`customtitle`='',`slug`='lampada-da-tavolo' WHERE `virtuemart_product_id`='19576' 2016-07-27 17:19:16 1 [DEBUG] Process remote file: http://objects.icecat.biz/objects/16676901_1770.pdf 2016-07-27 17:19:16 1 [DEBUG] URL:http://objects.icecat.biz/objects/16676901_1770.pdf 2016-07-27 17:19:16 1 [DEBUG] Opening socket to objects.icecat.biz at port 80 2016-07-27 17:19:16 1 [DEBUG] HTTP response:HTTP/1.1 200 OK 2016-07-27 17:19:17 1 [DEBUG] Identity string: 255044462d312e350d25e2e3cfd30d0a31203020 2016-07-27 17:19:17 1 [DEBUG] COM_CSVI_DEBUG_FILE_IS_NOT_IMAGE 2016-07-27 17:19:17 1 [QUERY] INSERT INTO `xxx_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (179,1,'Product language updated','Success','Updated','Product translations') 2016-07-27 17:19:17 1 [DEBUG] COM_CSVI_DEBUG_PROCESS_NON_IMAGE 2016-07-27 17:19:17 1 [QUERY] INSERT INTO `xxx_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (179,1,'Product language updated','Success','Updated','Product translations') 2016-07-27 17:19:17 1 [DEBUG] Current file: /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_1770.pdf 2016-07-27 17:19:17 1 [DEBUG] Remote file stored: http://objects.icecat.biz/objects/16676901_1770.pdf --> /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_1770.pdf 2016-07-27 17:19:17 1 [DEBUG] Identity string: 255044462d312e350d25e2e3cfd30d0a31203020 2016-07-27 17:19:17 1 [DEBUG] Mime type found: application/pdf 2016-07-27 17:19:17 1 [DEBUG] Full name original: /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_1770.pdf 2016-07-27 17:19:17 1 [DEBUG] Full name target: images/stories/virtuemart/product/16676901_1770.pdf 2016-07-27 17:19:17 1 [DEBUG] Store remote file on server /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_1770.pdf --> /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_1770.pdf 2016-07-27 17:19:17 1 [DEBUG] Checking if the file_url exists 2016-07-27 17:19:17 1 [QUERY] SELECT `virtuemart_media_id` FROM `xxx_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/16676901_1770.pdf' 2016-07-27 17:19:17 1 [DEBUG] Query for Media 2016-07-27 17:19:17 1 [QUERY] INSERT INTO `xxx_virtuemart_medias` (`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`file_is_product_image`,`file_is_downloadable`,`file_is_forSale`,`file_params`,`file_lang`,`shared`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','','','','','application/pdf','product','images/stories/virtuemart/product/16676901_1770.pdf','','0','1','0','','','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2016-07-27 17:19:17 1 [DEBUG] Query for ProductMedia 2016-07-27 17:19:17 1 [QUERY] INSERT INTO `xxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('19576','17143','1') 2016-07-27 17:19:17 1 [DEBUG] Store product image relation 2016-07-27 17:19:17 1 [DEBUG] Process remote file: http://objects.icecat.biz/objects/16676901_3895.pdf 2016-07-27 17:19:17 1 [DEBUG] URL:http://objects.icecat.biz/objects/16676901_3895.pdf 2016-07-27 17:19:17 1 [DEBUG] Opening socket to objects.icecat.biz at port 80 2016-07-27 17:19:17 1 [DEBUG] HTTP response:HTTP/1.1 200 OK 2016-07-27 17:19:18 1 [DEBUG] Identity string: 255044462d312e340a25e2e3cfd30d0a38203020 2016-07-27 17:19:18 1 [DEBUG] COM_CSVI_DEBUG_FILE_IS_NOT_IMAGE 2016-07-27 17:19:18 1 [QUERY] INSERT INTO `xxx_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (179,1,'Image added','Success','Added','Product media relations') 2016-07-27 17:19:18 1 [DEBUG] COM_CSVI_DEBUG_PROCESS_NON_IMAGE 2016-07-27 17:19:18 1 [QUERY] INSERT INTO `xxx_csvi_logdetails` (`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES (179,1,'Image added','Success','Added','Product media relations') 2016-07-27 17:19:18 1 [DEBUG] Current file: /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_3895.pdf 2016-07-27 17:19:18 1 [DEBUG] Remote file stored: http://objects.icecat.biz/objects/16676901_3895.pdf --> /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_3895.pdf 2016-07-27 17:19:18 1 [DEBUG] Identity string: 255044462d312e340a25e2e3cfd30d0a38203020 2016-07-27 17:19:18 1 [DEBUG] Mime type found: application/pdf 2016-07-27 17:19:18 1 [DEBUG] Full name original: /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_3895.pdf 2016-07-27 17:19:18 1 [DEBUG] Full name target: images/stories/virtuemart/product/16676901_3895.pdf 2016-07-27 17:19:18 1 [DEBUG] Store remote file on server /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_3895.pdf --> /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_3895.pdf 2016-07-27 17:19:18 1 [DEBUG] Checking if the file_url exists 2016-07-27 17:19:18 1 [QUERY] SELECT `virtuemart_media_id` FROM `xxx_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/16676901_3895.pdf' 2016-07-27 17:19:18 1 [DEBUG] Query for Media 2016-07-27 17:19:18 1 [QUERY] INSERT INTO `xxx_virtuemart_medias` (`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`file_is_product_image`,`file_is_downloadable`,`file_is_forSale`,`file_params`,`file_lang`,`shared`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','16676901_3895.pdf','','','','application/pdf','product','images/stories/virtuemart/product/16676901_3895.pdf','','0','1','0','','','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2016-07-27 17:19:18 1 [DEBUG] Query for ProductMedia 2016-07-27 17:19:18 1 [QUERY] INSERT INTO `xxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('19576','17144','2') 2016-07-27 17:19:18 1 [DEBUG] Store product image relation 2016-07-27 17:19:18 1 [DEBUG] Process remote file: http://images.icecat.biz/img/norm/high/16676901-Philips.jpg 2016-07-27 17:19:18 1 [DEBUG] URL:http://images.icecat.biz/img/norm/high/16676901-Philips.jpg 2016-07-27 17:19:18 1 [DEBUG] Opening socket to images.icecat.biz at port 80 2016-07-27 17:19:18 1 [DEBUG] HTTP response:HTTP/1.1 200 OK 2016-07-27 17:19:19 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:19 1 [DEBUG] Process image file 2016-07-27 17:19:19 1 [DEBUG] Current file: /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901-Philips.jpg 2016-07-27 17:19:19 1 [DEBUG] Remote file stored: http://images.icecat.biz/img/norm/high/16676901-Philips.jpg --> /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901-Philips.jpg 2016-07-27 17:19:19 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:19 1 [DEBUG] Mime type found: image/jpeg 2016-07-27 17:19:19 1 [DEBUG] Full name original: /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901-Philips.jpg 2016-07-27 17:19:19 1 [DEBUG] Full name target: images/stories/virtuemart/product/16676901-Philips.jpg 2016-07-27 17:19:19 1 [DEBUG] Store remote file on server /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901-Philips.jpg --> /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901-Philips.jpg 2016-07-27 17:19:19 1 [DEBUG] Checking if the file_url exists 2016-07-27 17:19:19 1 [QUERY] SELECT `virtuemart_media_id` FROM `xxx_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/16676901-Philips.jpg' 2016-07-27 17:19:19 1 [DEBUG] Query for Media 2016-07-27 17:19:19 1 [QUERY] INSERT INTO `xxx_virtuemart_medias` (`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`file_is_product_image`,`file_is_downloadable`,`file_is_forSale`,`file_params`,`file_lang`,`shared`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','16676901-Philips.jpg','','','','image/jpeg','product','images/stories/virtuemart/product/16676901-Philips.jpg','images/stories/virtuemart/product/16676901-Philips.jpg','1','0','0','','','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2016-07-27 17:19:19 1 [DEBUG] Query for ProductMedia 2016-07-27 17:19:19 1 [QUERY] INSERT INTO `xxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('19576','17145','3') 2016-07-27 17:19:19 1 [DEBUG] Store product image relation 2016-07-27 17:19:19 1 [DEBUG] Process remote file: http://images.icecat.biz/img/gallery/16676901_4882.jpg 2016-07-27 17:19:19 1 [DEBUG] URL:http://images.icecat.biz/img/gallery/16676901_4882.jpg 2016-07-27 17:19:19 1 [DEBUG] Opening socket to images.icecat.biz at port 80 2016-07-27 17:19:19 1 [DEBUG] HTTP response:HTTP/1.1 200 OK 2016-07-27 17:19:19 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:19 1 [DEBUG] Process image file 2016-07-27 17:19:19 1 [DEBUG] Current file: /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_4882.jpg 2016-07-27 17:19:20 1 [DEBUG] Remote file stored: http://images.icecat.biz/img/gallery/16676901_4882.jpg --> /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_4882.jpg 2016-07-27 17:19:20 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:20 1 [DEBUG] Mime type found: image/jpeg 2016-07-27 17:19:20 1 [DEBUG] Full name original: /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_4882.jpg 2016-07-27 17:19:20 1 [DEBUG] Full name target: images/stories/virtuemart/product/16676901_4882.jpg 2016-07-27 17:19:20 1 [DEBUG] Store remote file on server /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_4882.jpg --> /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_4882.jpg 2016-07-27 17:19:20 1 [DEBUG] Checking if the file_url exists 2016-07-27 17:19:20 1 [QUERY] SELECT `virtuemart_media_id` FROM `xxx_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/16676901_4882.jpg' 2016-07-27 17:19:20 1 [DEBUG] Query for Media 2016-07-27 17:19:20 1 [QUERY] INSERT INTO `xxx_virtuemart_medias` (`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`file_is_product_image`,`file_is_downloadable`,`file_is_forSale`,`file_params`,`file_lang`,`shared`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','16676901_4882.jpg','','','','image/jpeg','product','images/stories/virtuemart/product/16676901_4882.jpg','images/stories/virtuemart/product/16676901_4882.jpg','1','0','0','','','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2016-07-27 17:19:20 1 [DEBUG] Query for ProductMedia 2016-07-27 17:19:20 1 [QUERY] INSERT INTO `xxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('19576','17146','4') 2016-07-27 17:19:20 1 [DEBUG] Store product image relation 2016-07-27 17:19:20 1 [DEBUG] Process remote file: http://images.icecat.biz/img/gallery/16676901-Philips-PID.jpg 2016-07-27 17:19:20 1 [DEBUG] URL:http://images.icecat.biz/img/gallery/16676901-Philips-PID.jpg 2016-07-27 17:19:20 1 [DEBUG] Opening socket to images.icecat.biz at port 80 2016-07-27 17:19:20 1 [DEBUG] HTTP response:HTTP/1.1 200 OK 2016-07-27 17:19:20 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:20 1 [DEBUG] Process image file 2016-07-27 17:19:20 1 [DEBUG] Current file: /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901-Philips-PID.jpg 2016-07-27 17:19:20 1 [DEBUG] Remote file stored: http://images.icecat.biz/img/gallery/16676901-Philips-PID.jpg --> /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901-Philips-PID.jpg 2016-07-27 17:19:20 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:20 1 [DEBUG] Mime type found: image/jpeg 2016-07-27 17:19:20 1 [DEBUG] Full name original: /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901-Philips-PID.jpg 2016-07-27 17:19:20 1 [DEBUG] Full name target: images/stories/virtuemart/product/16676901-Philips-PID.jpg 2016-07-27 17:19:20 1 [DEBUG] Store remote file on server /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901-Philips-PID.jpg --> /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901-Philips-PID.jpg 2016-07-27 17:19:20 1 [DEBUG] Checking if the file_url exists 2016-07-27 17:19:20 1 [QUERY] SELECT `virtuemart_media_id` FROM `xxx_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/16676901-Philips-PID.jpg' 2016-07-27 17:19:20 1 [DEBUG] Query for Media 2016-07-27 17:19:20 1 [QUERY] INSERT INTO `xxx_virtuemart_medias` (`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`file_is_product_image`,`file_is_downloadable`,`file_is_forSale`,`file_params`,`file_lang`,`shared`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','16676901-Philips-PID.jpg','','','','image/jpeg','product','images/stories/virtuemart/product/16676901-Philips-PID.jpg','images/stories/virtuemart/product/16676901-Philips-PID.jpg','1','0','0','','','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2016-07-27 17:19:20 1 [DEBUG] Query for ProductMedia 2016-07-27 17:19:20 1 [QUERY] INSERT INTO `xxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('19576','17147','5') 2016-07-27 17:19:20 1 [DEBUG] Store product image relation 2016-07-27 17:19:20 1 [DEBUG] Process remote file: http://images.icecat.biz/img/gallery/16676901_5411.jpg 2016-07-27 17:19:20 1 [DEBUG] URL:http://images.icecat.biz/img/gallery/16676901_5411.jpg 2016-07-27 17:19:20 1 [DEBUG] Opening socket to images.icecat.biz at port 80 2016-07-27 17:19:20 1 [DEBUG] HTTP response:HTTP/1.1 200 OK 2016-07-27 17:19:21 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:21 1 [DEBUG] Process image file 2016-07-27 17:19:21 1 [DEBUG] Current file: /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_5411.jpg 2016-07-27 17:19:21 1 [DEBUG] Remote file stored: http://images.icecat.biz/img/gallery/16676901_5411.jpg --> /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_5411.jpg 2016-07-27 17:19:21 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:21 1 [DEBUG] Mime type found: image/jpeg 2016-07-27 17:19:21 1 [DEBUG] Full name original: /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_5411.jpg 2016-07-27 17:19:21 1 [DEBUG] Full name target: images/stories/virtuemart/product/16676901_5411.jpg 2016-07-27 17:19:21 1 [DEBUG] Store remote file on server /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_5411.jpg --> /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_5411.jpg 2016-07-27 17:19:21 1 [DEBUG] Checking if the file_url exists 2016-07-27 17:19:21 1 [QUERY] SELECT `virtuemart_media_id` FROM `xxx_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/16676901_5411.jpg' 2016-07-27 17:19:21 1 [DEBUG] Query for Media 2016-07-27 17:19:21 1 [QUERY] INSERT INTO `xxx_virtuemart_medias` (`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`file_is_product_image`,`file_is_downloadable`,`file_is_forSale`,`file_params`,`file_lang`,`shared`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','16676901_5411.jpg','','','','image/jpeg','product','images/stories/virtuemart/product/16676901_5411.jpg','images/stories/virtuemart/product/16676901_5411.jpg','1','0','0','','','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2016-07-27 17:19:21 1 [DEBUG] Query for ProductMedia 2016-07-27 17:19:21 1 [QUERY] INSERT INTO `xxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('19576','17148','6') 2016-07-27 17:19:21 1 [DEBUG] Store product image relation 2016-07-27 17:19:21 1 [DEBUG] Process remote file: http://images.icecat.biz/img/gallery/16676901_9510.jpg 2016-07-27 17:19:21 1 [DEBUG] URL:http://images.icecat.biz/img/gallery/16676901_9510.jpg 2016-07-27 17:19:21 1 [DEBUG] Opening socket to images.icecat.biz at port 80 2016-07-27 17:19:21 1 [DEBUG] HTTP response:HTTP/1.1 200 OK 2016-07-27 17:19:21 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:21 1 [DEBUG] Process image file 2016-07-27 17:19:21 1 [DEBUG] Current file: /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_9510.jpg 2016-07-27 17:19:21 1 [DEBUG] Remote file stored: http://images.icecat.biz/img/gallery/16676901_9510.jpg --> /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_9510.jpg 2016-07-27 17:19:21 1 [DEBUG] Identity string: ffd8ffe000104a46494600010101004800480000 2016-07-27 17:19:21 1 [DEBUG] Mime type found: image/jpeg 2016-07-27 17:19:21 1 [DEBUG] Full name original: /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_9510.jpg 2016-07-27 17:19:21 1 [DEBUG] Full name target: images/stories/virtuemart/product/16676901_9510.jpg 2016-07-27 17:19:21 1 [DEBUG] Store remote file on server /home/xyz/domains/mysite.it/public_html/tmp/com_csvi/16676901_9510.jpg --> /home/xyz/domains/mysite.it/public_html/images/stories/virtuemart/product/16676901_9510.jpg 2016-07-27 17:19:21 1 [DEBUG] Checking if the file_url exists 2016-07-27 17:19:21 1 [QUERY] SELECT `virtuemart_media_id` FROM `xxx_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/product/16676901_9510.jpg' 2016-07-27 17:19:21 1 [DEBUG] Query for Media 2016-07-27 17:19:21 1 [QUERY] INSERT INTO `xxx_virtuemart_medias` (`virtuemart_vendor_id`,`file_title`,`file_description`,`file_meta`,`file_class`,`file_mimetype`,`file_type`,`file_url`,`file_url_thumb`,`file_is_product_image`,`file_is_downloadable`,`file_is_forSale`,`file_params`,`file_lang`,`shared`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`,`locked_on`,`locked_by`) VALUES ('1','16676901_9510.jpg','','','','image/jpeg','product','images/stories/virtuemart/product/16676901_9510.jpg','images/stories/virtuemart/product/16676901_9510.jpg','1','0','0','','','0','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0') 2016-07-27 17:19:21 1 [DEBUG] Query for ProductMedia 2016-07-27 17:19:21 1 [QUERY] INSERT INTO `xxx_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('19576','17149','7') 2016-07-27 17:19:21 1 [DEBUG] Store product image relation 2016-07-27 17:19:21 1 [DEBUG] Finding a product_price_id 2016-07-27 17:19:21 1 [QUERY] SELECT `virtuemart_product_price_id` FROM `xxx_virtuemart_product_prices` WHERE `virtuemart_product_id` = 19576 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-07-27 17:19:21 1 [DEBUG] Query for ProductPrice 2016-07-27 17:19:21 1 [QUERY] INSERT INTO `xxx_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 ('19576','0','45','0','47','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') 2016-07-27 17:19:21 1 [DEBUG] Checking manufacturer 2016-07-27 17:19:21 1 [DEBUG] Delete product manufacturer references 2016-07-27 17:19:21 1 [QUERY] DELETE FROM `xxx_virtuemart_product_manufacturers` WHERE `virtuemart_product_id` = 19576 2016-07-27 17:19:21 1 [DEBUG] Manufacturer exists 2016-07-27 17:19:21 1 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `xxx_virtuemart_manufacturers_en_gb` WHERE `mf_name` = 'Philips' 2016-07-27 17:19:21 1 [DEBUG] Load a row 2016-07-27 17:19:21 1 [DEBUG] Query for ManufacturerLang 2016-07-27 17:19:21 1 [QUERY] UPDATE `xxx_virtuemart_manufacturers_en_gb` SET `mf_name`='Philips',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='philips' WHERE `virtuemart_manufacturer_id`='59' 2016-07-27 17:19:21 1 [DEBUG] Manufacturer exists 2016-07-27 17:19:21 1 [QUERY] SELECT `virtuemart_manufacturer_id` FROM `xxx_virtuemart_manufacturers` WHERE `virtuemart_manufacturer_id` = 59 2016-07-27 17:19:21 1 [DEBUG] Query for ProductManufacturer 2016-07-27 17:19:21 1 [QUERY] INSERT INTO `xxx_virtuemart_product_manufacturers` (`virtuemart_product_id`,`virtuemart_manufacturer_id`) VALUES ('19576','59') 2016-07-27 17:19:21 1 [DEBUG] Processing custom available field: Informazioni aggiuntive 2016-07-27 17:19:21 1 [DEBUG] Processing custom available field: Video 2016-07-27 17:19:21 1 [DEBUG] Checking category 2016-07-27 17:19:21 1 [DEBUG] Check if category path exists: Catalogo 2016-07-27 17:19:21 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `xxx_virtuemart_categories` AS `c` LEFT JOIN `xxx_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `xxx_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Catalogo' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0 2016-07-27 17:19:21 1 [DEBUG] Check if category path exists: Digital Signage 2016-07-27 17:19:21 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `xxx_virtuemart_categories` AS `c` LEFT JOIN `xxx_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `xxx_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Digital Signage' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 1 2016-07-27 17:19:21 1 [DEBUG] Check if category path exists: Illuminazione autore 2016-07-27 17:19:21 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `xxx_virtuemart_categories` AS `c` LEFT JOIN `xxx_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `xxx_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Illuminazione autore' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 557 2016-07-27 17:19:22 1 [DEBUG] COM_CSVI_DELETE_OLD_CATEGORIES_XREF 2016-07-27 17:19:22 1 [QUERY] DELETE FROM `xxx_virtuemart_product_categories` WHERE `virtuemart_product_id` = 19576 2016-07-27 17:19:22 1 [DEBUG] Check if a category reference already exists 2016-07-27 17:19:22 1 [QUERY] SELECT COUNT(*) AS total FROM `xxx_virtuemart_product_categories` WHERE `virtuemart_product_id` = 19576 AND `virtuemart_category_id` = 571 2016-07-27 17:19:22 1 [DEBUG] Category reference does not exist yet 2016-07-27 17:19:22 1 [DEBUG] COM_CSVI_ADD_NEW_CATEGORY_REFERENCES 2016-07-27 17:19:22 1 [QUERY] INSERT INTO `xxx_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('19576','571') 2016-07-27 17:19:22 1 [ADD] COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED 2016-07-27 17:19:22 1 [QUERY] INSERT INTO `xxx_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('19576','571') 2016-07-27 17:19:22 1 [DEBUG] Process related products 2016-07-27 17:19:22 1 [QUERY] SELECT `p1`.`virtuemart_product_id` AS `virtuemart_product_id`,`p2`.`virtuemart_product_id` AS `customfield_value` FROM `xxx_csvi_related_products` AS `r` LEFT JOIN `xxx_virtuemart_products` AS `p1` ON `r`.`product_sku` = `p1`.`product_sku` LEFT JOIN `xxx_virtuemart_products` AS `p2` ON `r`.`related_sku` = `p2`.`product_sku`