# # #Date: 2015-07-04 07:23:06 UTC #Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT #Fields: date time line_nr action comment 2015-07-04 07:23:06 0 [DEBUG] Importing filetype: csv 2015-07-04 07:23:06 0 [DEBUG] Load config fields 2015-07-04 07:23:06 0 [DEBUG] Field: category_path 2015-07-04 07:23:06 0 [DEBUG] Field: product_sku 2015-07-04 07:23:06 0 [DEBUG] Field: custom_title 2015-07-04 07:23:06 0 [DEBUG] Field: custom_value 2015-07-04 07:23:06 0 [DEBUG] Field: custom_param 2015-07-04 07:23:06 0 [DEBUG] Field: product_name 2015-07-04 07:23:06 0 [DEBUG] Field: product_in_stock 2015-07-04 07:23:06 0 [DEBUG] Field: product_price 2015-07-04 07:23:06 0 [DEBUG] Field: published 2015-07-04 07:23:06 0 [DEBUG] Field: custom_multiple 2015-07-04 07:23:06 0 [DEBUG] Using file for configuration 2015-07-04 07:23:06 0 [DEBUG] Field name: category_path 2015-07-04 07:23:06 0 [DEBUG] Use database for configuration 2015-07-04 07:23:06 0 [DEBUG] Field name: product_sku 2015-07-04 07:23:06 0 [DEBUG] Use database for configuration 2015-07-04 07:23:06 0 [DEBUG] Field name: custom_title 2015-07-04 07:23:06 0 [DEBUG] Use database for configuration 2015-07-04 07:23:06 0 [DEBUG] Field name: custom_value 2015-07-04 07:23:06 0 [DEBUG] Use database for configuration 2015-07-04 07:23:06 0 [DEBUG] Field name: custom_param 2015-07-04 07:23:06 0 [DEBUG] Use database for configuration 2015-07-04 07:23:06 0 [DEBUG] Field name: product_name 2015-07-04 07:23:06 0 [DEBUG] Use database for configuration 2015-07-04 07:23:06 0 [DEBUG] Field name: product_in_stock 2015-07-04 07:23:06 0 [DEBUG] Use database for configuration 2015-07-04 07:23:06 0 [DEBUG] Field name: product_price 2015-07-04 07:23:06 0 [DEBUG] Use database for configuration 2015-07-04 07:23:06 0 [DEBUG] Field name: published 2015-07-04 07:23:06 0 [DEBUG] Use database for configuration 2015-07-04 07:23:06 0 [DEBUG] CSVI Pro Version: 5.21.2 2015-07-04 07:23:06 0 [DEBUG] PHP version: 5.4.39-0+deb7u2 2015-07-04 07:23:06 0 [DEBUG] action: import 2015-07-04 07:23:06 0 [DEBUG] component: com_virtuemart 2015-07-04 07:23:06 0 [DEBUG] operation: productimport 2015-07-04 07:23:06 0 [DEBUG] source: fromupload 2015-07-04 07:23:06 0 [DEBUG] Load from computer: Sample_8.csv 2015-07-04 07:23:06 0 [DEBUG] local_csv_file: 2015-07-04 07:23:06 0 [DEBUG] urlfile: 2015-07-04 07:23:06 0 [DEBUG] ftphost: 2015-07-04 07:23:06 0 [DEBUG] ftpport: 2015-07-04 07:23:06 0 [DEBUG] ftproot: 2015-07-04 07:23:06 0 [DEBUG] ftpfile: 2015-07-04 07:23:06 0 [DEBUG] auto_detect_delimiters: Нет 2015-07-04 07:23:06 0 [DEBUG] field_delimiter: ; 2015-07-04 07:23:06 0 [DEBUG] text_enclosure: " 2015-07-04 07:23:06 0 [DEBUG] use_file_extension: 2015-07-04 07:23:06 0 [DEBUG] im_mac: Нет 2015-07-04 07:23:06 0 [DEBUG] use_column_headers: Да 2015-07-04 07:23:06 0 [DEBUG] add_extra_fields: Да 2015-07-04 07:23:06 0 [DEBUG] skip_first_line: Нет 2015-07-04 07:23:06 0 [DEBUG] overwrite_existing_data: Да 2015-07-04 07:23:06 0 [DEBUG] ignore_non_exist: Нет 2015-07-04 07:23:06 0 [DEBUG] skip_default_value: Нет 2015-07-04 07:23:06 0 [DEBUG] collect_debug_info: Да 2015-07-04 07:23:06 0 [DEBUG] xml_record_name: 2015-07-04 07:23:06 0 [DEBUG] language: ru-RU 2015-07-04 07:23:06 0 [DEBUG] category_separator: / 2015-07-04 07:23:06 0 [DEBUG] append_categories: Нет 2015-07-04 07:23:06 0 [DEBUG] update_based_on: product_sku 2015-07-04 07:23:06 0 [DEBUG] mpn_column_name: 2015-07-04 07:23:06 0 [DEBUG] unpublish_before_import: Нет 2015-07-04 07:23:06 0 [DEBUG] recreate_alias: Нет 2015-07-04 07:23:06 0 [DEBUG] update_stockable_parent: Нет 2015-07-04 07:23:06 0 [DEBUG] use_icecat: Нет 2015-07-04 07:23:06 0 [DEBUG] similar_sku: Нет 2015-07-04 07:23:06 0 [DEBUG] process_image: Нет 2015-07-04 07:23:06 0 [DEBUG] delete_product_images: Нет 2015-07-04 07:23:06 0 [DEBUG] auto_generate_image_name: Нет 2015-07-04 07:23:06 0 [DEBUG] type_generate_image_name: product_sku 2015-07-04 07:23:06 0 [DEBUG] autogenerateext: jpg 2015-07-04 07:23:06 0 [DEBUG] change_case: none 2015-07-04 07:23:06 0 [DEBUG] autofill: Нет 2015-07-04 07:23:06 0 [DEBUG] keep_original: Нет 2015-07-04 07:23:06 0 [DEBUG] convert_type: none 2015-07-04 07:23:06 0 [DEBUG] save_images_on_server: Нет 2015-07-04 07:23:06 0 [DEBUG] redownload_external_image: Да 2015-07-04 07:23:06 0 [DEBUG] full_resize: Нет 2015-07-04 07:23:06 0 [DEBUG] full_width: 2015-07-04 07:23:06 0 [DEBUG] full_height: 2015-07-04 07:23:06 0 [DEBUG] full_watermark: Нет 2015-07-04 07:23:06 0 [DEBUG] full_watermark_right: 2015-07-04 07:23:06 0 [DEBUG] full_watermark_bottom: 2015-07-04 07:23:06 0 [DEBUG] full_watermark_image: 2015-07-04 07:23:06 0 [DEBUG] thumb_check_filetype: Нет 2015-07-04 07:23:06 0 [DEBUG] thumb_create: Нет 2015-07-04 07:23:06 0 [DEBUG] thumb_extension: none 2015-07-04 07:23:06 0 [DEBUG] thumb_width: 90 2015-07-04 07:23:06 0 [DEBUG] thumb_height: 90 2015-07-04 07:23:06 0 [DEBUG] resize_max_width: 1024 2015-07-04 07:23:06 0 [DEBUG] resize_max_height: 768 2015-07-04 07:23:06 0 [DEBUG] file_location_product_files: images/stories/virtuemart/product/ 2015-07-04 07:23:06 0 [DEBUG] use_system_limits: Нет 2015-07-04 07:23:06 0 [DEBUG] max_execution_time: 2015-07-04 07:23:06 0 [DEBUG] memory_limit: 2015-07-04 07:23:06 0 [DEBUG] post_max_size: 2015-07-04 07:23:06 0 [DEBUG] upload_max_filesize: 2015-07-04 07:23:06 0 [DEBUG] template_name: 5 2015-07-04 07:23:06 0 [DEBUG] id: 51 2015-07-04 07:23:06 0 [DEBUG] Load custom fields 2015-07-04 07:23:06 0 [QUERY] SELECT `virtuemart_custom_id` AS `id`,`field_type`, TRIM(`custom_title`) AS `title`,`custom_parent_id` FROM `g8bfs_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M','Y','X') 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Process line 1 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Find product ID based on product SKU 2015-07-04 07:23:06 1 [QUERY] SELECT `virtuemart_product_id` FROM `g8bfs_virtuemart_products` WHERE `product_sku` = '1255' 2015-07-04 07:23:06 1 [DEBUG] Use field value 2015-07-04 07:23:06 1 [DEBUG] Check to see if the vendor ID exists 2015-07-04 07:23:06 1 [QUERY] SELECT IF (COUNT(virtuemart_vendor_id) = 0, 1, virtuemart_vendor_id) AS vendor_id FROM g8bfs_virtuemart_products WHERE product_sku = '1255' 2015-07-04 07:23:06 1 [DEBUG] Get the product currency 2015-07-04 07:23:06 1 [DEBUG] Get the product currency 2015-07-04 07:23:06 1 [QUERY] SELECT vendor_currency FROM g8bfs_virtuemart_vendors WHERE virtuemart_vendor_id = 1 2015-07-04 07:23:06 1 [DEBUG] Processing SKU: 1255 2015-07-04 07:23:06 1 [DEBUG] Product tax 2015-07-04 07:23:06 1 [DEBUG] Manufacturer import 2015-07-04 07:23:06 1 [DEBUG] Retrieve manufacturer ID based on product SKU 2015-07-04 07:23:06 1 [QUERY] SELECT `m`.`virtuemart_manufacturer_id` FROM `g8bfs_virtuemart_product_manufacturers` AS `m` LEFT JOIN `g8bfs_virtuemart_products` AS `p` ON `m`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `p`.`product_sku` = '1255' 2015-07-04 07:23:06 1 [DEBUG] Get default manufacturer ID 2015-07-04 07:23:06 1 [QUERY] SELECT MIN(virtuemart_manufacturer_id) FROM `g8bfs_virtuemart_manufacturers` 2015-07-04 07:23:06 1 [DEBUG] Manufacturer already exists 2015-07-04 07:23:06 1 [QUERY] SELECT * FROM g8bfs_virtuemart_manufacturers_ru_ru WHERE `virtuemart_manufacturer_id` = '1' 2015-07-04 07:23:06 1 [DEBUG] Manufacturer language query 2015-07-04 07:23:06 1 [QUERY] UPDATE `g8bfs_virtuemart_manufacturers_ru_ru` SET `mf_name`='',`mf_email`='',`mf_desc`='',`mf_url`='',`slug`='2015-07-03-08-10-421138457575' WHERE `virtuemart_manufacturer_id`='1' 2015-07-04 07:23:06 1 [DEBUG] Manufacturer already exists 2015-07-04 07:23:06 1 [QUERY] SELECT virtuemart_manufacturer_id FROM g8bfs_virtuemart_manufacturers WHERE `virtuemart_manufacturer_id` = '1' 2015-07-04 07:23:06 1 [DEBUG] Product query 2015-07-04 07:23:06 1 [QUERY] INSERT INTO `g8bfs_virtuemart_products` (`virtuemart_vendor_id`,`product_sku`,`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_availability`,`product_special`,`product_sales`,`product_unit`,`product_packaging`,`product_params`,`hits`,`intnotes`,`metarobot`,`metaauthor`,`layout`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('1','1255','0','KG','0','0','0','M','','0','0','0','','0','0','KG','0','min_order_level=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|','0','','','','0','1','2015-07-04 07:23:06','756','2015-07-04 07:23:06','756') 2015-07-04 07:23:06 1 [DEBUG] Check product language entry 2015-07-04 07:23:06 1 [QUERY] SELECT virtuemart_product_id FROM g8bfs_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 259 2015-07-04 07:23:06 1 [DEBUG] Check product slug 2015-07-04 07:23:06 1 [QUERY] SELECT COUNT(`virtuemart_product_id`) FROM g8bfs_virtuemart_products_ru_ru WHERE `slug` = 'product-1255' AND `virtuemart_product_id` != '259' 2015-07-04 07:23:06 1 [DEBUG] Add product language entry 2015-07-04 07:23:06 1 [QUERY] INSERT INTO g8bfs_virtuemart_products_ru_ru (`virtuemart_product_id`, `slug`) VALUES ('259', 'product-1255') 2015-07-04 07:23:06 1 [DEBUG] Product language query 2015-07-04 07:23:06 1 [QUERY] UPDATE `g8bfs_virtuemart_products_ru_ru` SET `product_name`='Product 1255',`slug`='product-1255' WHERE `virtuemart_product_id`='259' 2015-07-04 07:23:06 1 [DEBUG] Finding a product_price_id 2015-07-04 07:23:06 1 [QUERY] SELECT `virtuemart_product_price_id` FROM `g8bfs_virtuemart_product_prices` WHERE `virtuemart_product_id` = '259' AND `virtuemart_shoppergroup_id` = '0' AND `product_currency` = '131' AND `price_quantity_start` = '0' AND `price_quantity_end` = '0' AND (`product_price_publish_up` = '0000-00-00 00:00:00' OR `product_price_publish_up` IS NULL) AND (`product_price_publish_down` = '0000-00-00 00:00:00' OR `product_price_publish_down` IS NULL) 2015-07-04 07:23:06 1 [DEBUG] Storing price 2015-07-04 07:23:06 1 [QUERY] INSERT INTO `g8bfs_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`) VALUES ('259','0','100','0','131','0000-00-00 00:00:00','0000-00-00 00:00:00','0','0','2015-07-04 07:23:06','756','2015-07-04 07:23:06','756') 2015-07-04 07:23:06 1 [DEBUG] Process manufacturer cross reference 2015-07-04 07:23:06 1 [QUERY] INSERT INTO `g8bfs_virtuemart_product_manufacturers` (`virtuemart_product_id`,`virtuemart_manufacturer_id`) VALUES ('259','1') 2015-07-04 07:23:06 1 [DEBUG] Custom title:Color~Size 2015-07-04 07:23:06 1 [DEBUG] Custom values:customfieldsforall~customfieldsforall 2015-07-04 07:23:06 1 [DEBUG] Custom params:Red#Blue#Черный#Синий~S#M#L 2015-07-04 07:23:06 1 [DEBUG] Custom field query 2015-07-04 07:23:06 1 [QUERY] SELECT custom_parent_id, virtuemart_custom_id FROM g8bfs_virtuemart_customs WHERE `custom_title` = 'Color' 2015-07-04 07:23:06 1 [DEBUG] Remove existing custom values 2015-07-04 07:23:06 1 [QUERY] DELETE FROM `g8bfs_virtuemart_product_customfields` WHERE `virtuemart_product_id` = '259' AND `virtuemart_custom_id` = 27 2015-07-04 07:23:06 1 [DEBUG] COM_CSVI_DEBUG_CUSTOMFIELD_VALUE_QUERY 2015-07-04 07:23:06 1 [QUERY] SELECT `customsforall_value_id` FROM `g8bfs_virtuemart_custom_plg_customsforall_values` WHERE `virtuemart_custom_id` = 27 2015-07-04 07:23:06 1 [DEBUG] COM_CSVI_DEBUG_CUSTOMFIELD_VALUE_QUERY 2015-07-04 07:23:06 1 [QUERY] DELETE FROM `g8bfs_virtuemart_product_custom_plg_customsforall` WHERE `virtuemart_product_id` = 259 AND `customsforall_value_id` IN (51,52,53,54) 2015-07-04 07:23:06 1 [DEBUG] Custom field query 2015-07-04 07:23:06 1 [QUERY] INSERT INTO `g8bfs_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_price`,`customfield_params`,`created_on`,`created_by`,`modified_on`,`modified_by`,`ordering`) VALUES ('259','27','customfieldsforall','','','2015-07-04 07:23:06','756','2015-07-04 07:23:06','756','') 2015-07-04 07:23:06 1 [DEBUG] COM_CSVI_DEBUG_CUSTOMFIELD_VALUE_QUERY 2015-07-04 07:23:06 1 [QUERY] SELECT `customsforall_value_id` FROM `g8bfs_virtuemart_custom_plg_customsforall_values` WHERE `virtuemart_custom_id` = 27 AND `customsforall_value_name` IN ('Red','Blue','Черный','Синий') 2015-07-04 07:23:06 1 [DEBUG] COM_CSVI_DEBUG_CUSTOMFIELD_PARAM_QUERY 2015-07-04 07:23:06 1 [QUERY] INSERT INTO `g8bfs_virtuemart_product_custom_plg_customsforall` (customsforall_value_id,virtuemart_product_id,customfield_id) VALUES (51,259,523),(52,259,523),(53,259,523),(54,259,523) 2015-07-04 07:23:06 1 [DEBUG] Custom field query 2015-07-04 07:23:06 1 [QUERY] SELECT custom_parent_id, virtuemart_custom_id FROM g8bfs_virtuemart_customs WHERE `custom_title` = 'Size' 2015-07-04 07:23:06 1 [DEBUG] Remove existing custom values 2015-07-04 07:23:06 1 [QUERY] DELETE FROM `g8bfs_virtuemart_product_customfields` WHERE `virtuemart_product_id` = '259' AND `virtuemart_custom_id` = 28 2015-07-04 07:23:06 1 [DEBUG] COM_CSVI_DEBUG_CUSTOMFIELD_VALUE_QUERY 2015-07-04 07:23:06 1 [QUERY] SELECT `customsforall_value_id` FROM `g8bfs_virtuemart_custom_plg_customsforall_values` WHERE `virtuemart_custom_id` = 28 2015-07-04 07:23:06 1 [DEBUG] COM_CSVI_DEBUG_CUSTOMFIELD_VALUE_QUERY 2015-07-04 07:23:06 1 [QUERY] DELETE FROM `g8bfs_virtuemart_product_custom_plg_customsforall` WHERE `virtuemart_product_id` = 259 AND `customsforall_value_id` IN (55,56,57) 2015-07-04 07:23:06 1 [DEBUG] Custom field query 2015-07-04 07:23:06 1 [QUERY] INSERT INTO `g8bfs_virtuemart_product_customfields` (`virtuemart_product_id`,`virtuemart_custom_id`,`customfield_value`,`customfield_params`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('259','28','customfieldsforall','','2015-07-04 07:23:06','756','2015-07-04 07:23:06','756') 2015-07-04 07:23:06 1 [DEBUG] COM_CSVI_DEBUG_CUSTOMFIELD_VALUE_QUERY 2015-07-04 07:23:06 1 [QUERY] SELECT `customsforall_value_id` FROM `g8bfs_virtuemart_custom_plg_customsforall_values` WHERE `virtuemart_custom_id` = 28 AND `customsforall_value_name` IN ('S','M','L') 2015-07-04 07:23:06 1 [DEBUG] COM_CSVI_DEBUG_CUSTOMFIELD_PARAM_QUERY 2015-07-04 07:23:06 1 [QUERY] INSERT INTO `g8bfs_virtuemart_product_custom_plg_customsforall` (customsforall_value_id,virtuemart_product_id,customfield_id) VALUES (55,259,524),(56,259,524),(57,259,524) 2015-07-04 07:23:06 1 [DEBUG] No custom available fields found 2015-07-04 07:23:06 1 [DEBUG] Checking category 2015-07-04 07:23:06 1 [DEBUG] Checking category path: Вечерние платья 2015-07-04 07:23:06 1 [DEBUG] Check if category path exists 2015-07-04 07:23:06 1 [QUERY] SELECT c.virtuemart_category_id FROM g8bfs_virtuemart_categories c LEFT JOIN g8bfs_virtuemart_category_categories x ON c.virtuemart_category_id = x.category_child_id LEFT JOIN g8bfs_virtuemart_categories_ru_ru l ON l.virtuemart_category_id = c.virtuemart_category_id WHERE l.category_name = 'Вечерние платья' AND x.category_child_id = c.virtuemart_category_id AND x.category_parent_id = 0 2015-07-04 07:23:06 1 [DEBUG] Delete old category references 2015-07-04 07:23:06 1 [QUERY] DELETE FROM g8bfs_virtuemart_product_categories WHERE virtuemart_product_id = 259 2015-07-04 07:23:06 1 [DEBUG] Check if category reference already exists 2015-07-04 07:23:06 1 [QUERY] SELECT COUNT(*) AS total FROM g8bfs_virtuemart_product_categories WHERE virtuemart_product_id = 259 AND virtuemart_category_id = 73 2015-07-04 07:23:06 1 [DEBUG] Category reference does not yet exist 2015-07-04 07:23:06 1 [DEBUG] Add new category references 2015-07-04 07:23:06 1 [QUERY] INSERT INTO `g8bfs_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('259','73') 2015-07-04 07:23:06 2 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs