# # #Date: 2020-03-10 13:33:00 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2020-03-10 13:33:00 0 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs 2020-03-10 13:33:08 0 [DEBUG] Found field delimiter: , 2020-03-10 13:33:09 0 [DEBUG] Found field delimiter: , 2020-03-10 13:33:09 0 [DEBUG] Loading the supported fields for com_virtuemart, operation price and action import 2020-03-10 13:33:09 0 [QUERY] SELECT `a`.`csvi_name` FROM `irtec_csvi_availablefields` AS `a` LEFT JOIN `irtec_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` = 'price' AND `a`.`action` = 'import' AND `t`.`action` = 'import' 2020-03-10 13:33:09 0 [DEBUG] Load the fields to process 2020-03-10 13:33:09 0 [DEBUG] Setup field: virtuemart_shoppergroup_id 2020-03-10 13:33:09 0 [DEBUG] Setup field: virtuemart_product_id 2020-03-10 13:33:09 0 [DEBUG] Setup field: product_price 2020-03-10 13:33:09 0 [DEBUG] Use the file for configuration 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field product_price 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field product_price 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field product_price 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field product_price 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:09 0 [DEBUG] Use field value for field product_price 2020-03-10 13:33:13 0 [DEBUG] Found field delimiter: , 2020-03-10 13:33:13 0 [DEBUG] Loading the supported fields for com_virtuemart, operation price and action import 2020-03-10 13:33:13 0 [QUERY] SELECT `a`.`csvi_name` FROM `irtec_csvi_availablefields` AS `a` LEFT JOIN `irtec_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` = 'price' AND `a`.`action` = 'import' AND `t`.`action` = 'import' 2020-03-10 13:33:13 0 [DEBUG] Load the fields to process 2020-03-10 13:33:13 0 [DEBUG] Setup field: virtuemart_shoppergroup_id 2020-03-10 13:33:13 0 [DEBUG] Setup field: virtuemart_product_id 2020-03-10 13:33:13 0 [DEBUG] Setup field: product_price 2020-03-10 13:33:13 0 [DEBUG] Use the file for configuration 2020-03-10 13:33:13 0 [DEBUG] Clean up old logs. Found 25 logs and threshold is 25 logs 2020-03-10 13:33:13 0 [DEBUG] Found field delimiter: , 2020-03-10 13:33:13 0 [DEBUG] Loading the supported fields for com_virtuemart, operation price and action import 2020-03-10 13:33:13 0 [QUERY] SELECT `a`.`csvi_name` FROM `irtec_csvi_availablefields` AS `a` LEFT JOIN `irtec_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` = 'price' AND `a`.`action` = 'import' AND `t`.`action` = 'import' 2020-03-10 13:33:13 0 [DEBUG] Load the fields to process 2020-03-10 13:33:13 0 [DEBUG] Setup field: virtuemart_shoppergroup_id 2020-03-10 13:33:13 0 [DEBUG] Setup field: virtuemart_product_id 2020-03-10 13:33:13 0 [DEBUG] Setup field: product_price 2020-03-10 13:33:13 0 [DEBUG] Use the file for configuration 2020-03-10 13:33:13 0 [DEBUG] ========== 2020-03-10 13:33:13 0 [DEBUG] RO CSVI Version: 7.14.0 2020-03-10 13:33:13 0 [DEBUG] PHP version: 7.3.15 2020-03-10 13:33:13 0 [DEBUG] Action: import 2020-03-10 13:33:13 0 [DEBUG] Component: com_virtuemart 2020-03-10 13:33:13 0 [DEBUG] Operation: price 2020-03-10 13:33:13 0 [DEBUG] Override: 2020-03-10 13:33:13 0 [DEBUG] Source: fromupload 2020-03-10 13:33:13 0 [DEBUG] Load from your computer: /home/cichlidens/domains/cichliden-stadel.de/public_html/tmp/com_csvi/1831083882/CSVI_Prices_10-03-2020_13.29.csv 2020-03-10 13:33:13 0 [DEBUG] Load from server: 2020-03-10 13:33:13 0 [DEBUG] Delete after import: No 2020-03-10 13:33:13 0 [DEBUG] Load from URL: http:// 2020-03-10 13:33:14 0 [DEBUG] URL Username: 2020-03-10 13:33:14 0 [DEBUG] Name of username field: user 2020-03-10 13:33:14 0 [DEBUG] URL Password: 2020-03-10 13:33:14 0 [DEBUG] Name of the password field: password 2020-03-10 13:33:14 0 [DEBUG] Retrieve method: get 2020-03-10 13:33:14 0 [DEBUG] Authorization Type: htaccess 2020-03-10 13:33:14 0 [DEBUG] Encode URL: Yes 2020-03-10 13:33:14 0 [DEBUG] FTP Host: 2020-03-10 13:33:14 0 [DEBUG] FTP Port: 2020-03-10 13:33:14 0 [DEBUG] SFTP: No 2020-03-10 13:33:14 0 [DEBUG] FTP Root Folder: 2020-03-10 13:33:14 0 [DEBUG] FTP Filename: 2020-03-10 13:33:14 0 [DEBUG] Connection type: 2020-03-10 13:33:14 0 [DEBUG] Table list: 2020-03-10 13:33:14 0 [DEBUG] Username: 2020-03-10 13:33:14 0 [DEBUG] Host: 2020-03-10 13:33:14 0 [DEBUG] Port: 2020-03-10 13:33:14 0 [DEBUG] Database name: 2020-03-10 13:33:14 0 [DEBUG] Database table: 2020-03-10 13:33:14 0 [DEBUG] Autodetect delimiters: Yes 2020-03-10 13:33:14 0 [DEBUG] Field Delimiter: comma 2020-03-10 13:33:14 0 [DEBUG] Text Enclosure: 2020-03-10 13:33:14 0 [DEBUG] Use file extension: 2020-03-10 13:33:14 0 [DEBUG] I'm Mac: No 2020-03-10 13:33:14 0 [DEBUG] Use file for configuration: Yes 2020-03-10 13:33:14 0 [DEBUG] Add extra fields: No 2020-03-10 13:33:14 0 [DEBUG] Skip first line: No 2020-03-10 13:33:14 0 [DEBUG] Overwrite existing data: Yes 2020-03-10 13:33:14 0 [DEBUG] Skip new items: No 2020-03-10 13:33:14 0 [DEBUG] Skip empty custom fields: No 2020-03-10 13:33:14 0 [DEBUG] Record name: 2020-03-10 13:33:14 0 [DEBUG] Delete existing prices: No 2020-03-10 13:33:14 0 [DEBUG] Lines per import: 1000 2020-03-10 13:33:14 0 [DEBUG] Time between imports: 5 2020-03-10 13:33:14 0 [DEBUG] Override system limits?: No 2020-03-10 13:33:14 0 [DEBUG] Maximum execution time: 2020-03-10 13:33:14 0 [DEBUG] Maximum amount of memory: 2020-03-10 13:33:14 0 [DEBUG] Maximum size of POST data in megabytes: 2020-03-10 13:33:14 0 [DEBUG] Maximum allowed size for uploaded files in megabytes: 2020-03-10 13:33:14 0 [DEBUG] Template ID: 55 2020-03-10 13:33:14 0 [DEBUG] Tags: 2020-03-10 13:33:14 0 [DEBUG] ========== 2020-03-10 13:33:14 0 [DEBUG] Updating start date and time of import 2020-03-10 13:33:14 0 [QUERY] UPDATE `irtec_csvi_logs` SET `start` = '2020-03-10 13:33:14' WHERE `csvi_log_id` = 300 2020-03-10 13:33:14 1 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 1 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 1 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 1 [DEBUG] Process line 1 2020-03-10 13:33:14 1 [DEBUG] Update based on value not found 2020-03-10 13:33:14 2 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 2 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 2 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 2 [DEBUG] Process line 2 2020-03-10 13:33:14 2 [DEBUG] Update based on value not found 2020-03-10 13:33:14 3 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 3 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 3 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 3 [DEBUG] Process line 3 2020-03-10 13:33:14 3 [DEBUG] Update based on value not found 2020-03-10 13:33:14 4 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 4 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 4 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 4 [DEBUG] Process line 4 2020-03-10 13:33:14 4 [DEBUG] Update based on value not found 2020-03-10 13:33:14 5 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 5 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 5 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 5 [DEBUG] Process line 5 2020-03-10 13:33:14 5 [DEBUG] Update based on value not found 2020-03-10 13:33:14 6 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 6 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 6 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 6 [DEBUG] Process line 6 2020-03-10 13:33:14 6 [DEBUG] Update based on value not found 2020-03-10 13:33:14 7 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 7 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 7 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 7 [DEBUG] Process line 7 2020-03-10 13:33:14 7 [DEBUG] Update based on value not found 2020-03-10 13:33:14 8 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 8 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 8 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 8 [DEBUG] Process line 8 2020-03-10 13:33:14 8 [DEBUG] Update based on value not found 2020-03-10 13:33:14 9 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 9 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 9 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 9 [DEBUG] Process line 9 2020-03-10 13:33:14 9 [DEBUG] Update based on value not found 2020-03-10 13:33:14 10 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 10 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 10 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 10 [DEBUG] Process line 10 2020-03-10 13:33:14 10 [DEBUG] Update based on value not found 2020-03-10 13:33:14 11 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 11 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 11 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 11 [DEBUG] Process line 11 2020-03-10 13:33:14 11 [DEBUG] Update based on value not found 2020-03-10 13:33:14 12 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 12 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 12 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 12 [DEBUG] Process line 12 2020-03-10 13:33:14 12 [DEBUG] Update based on value not found 2020-03-10 13:33:14 13 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 13 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 13 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 13 [DEBUG] Process line 13 2020-03-10 13:33:14 13 [DEBUG] Update based on value not found 2020-03-10 13:33:14 14 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 14 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 14 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 14 [DEBUG] Process line 14 2020-03-10 13:33:14 14 [DEBUG] Update based on value not found 2020-03-10 13:33:14 15 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 15 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 15 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 15 [DEBUG] Process line 15 2020-03-10 13:33:14 15 [DEBUG] Update based on value not found 2020-03-10 13:33:14 16 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 16 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 16 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 16 [DEBUG] Process line 16 2020-03-10 13:33:14 16 [DEBUG] Update based on value not found 2020-03-10 13:33:14 17 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 17 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 17 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 17 [DEBUG] Process line 17 2020-03-10 13:33:14 17 [DEBUG] Update based on value not found 2020-03-10 13:33:14 18 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 18 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 18 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 18 [DEBUG] Process line 18 2020-03-10 13:33:14 18 [DEBUG] Update based on value not found 2020-03-10 13:33:14 19 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 19 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 19 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 19 [DEBUG] Process line 19 2020-03-10 13:33:14 19 [DEBUG] Update based on value not found 2020-03-10 13:33:14 20 [DEBUG] Use field value for field virtuemart_shoppergroup_id 2020-03-10 13:33:14 20 [DEBUG] Use field value for field virtuemart_product_id 2020-03-10 13:33:14 20 [DEBUG] Use field value for field product_price 2020-03-10 13:33:14 20 [DEBUG] Process line 20 2020-03-10 13:33:14 20 [DEBUG] Update based on value not found