#
#<?php die('Forbidden.'); ?>
#Date: 2014-02-12 17:14:59 UTC
#Software: Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
#Fields: date time line_nr action comment
2014-02-12 17:14:59 0 [DEBUG] Importing filetype: csv
2014-02-12 17:14:59 0 [DEBUG] Found field delimiter: ;
2014-02-12 17:14:59 0 [DEBUG] Load config fields
2014-02-12 17:14:59 0 [DEBUG] Field: product_sku
2014-02-12 17:14:59 0 [DEBUG] Field: product_price
2014-02-12 17:14:59 0 [DEBUG] Using file for configuration
2014-02-12 17:14:59 0 [DEBUG] CSVI Pro Version: 5.9.6
2014-02-12 17:14:59 0 [DEBUG] PHP version: 5.3.28
2014-02-12 17:14:59 0 [DEBUG] action: import
2014-02-12 17:14:59 0 [DEBUG] component: com_virtuemart
2014-02-12 17:14:59 0 [DEBUG] operation: productimport
2014-02-12 17:14:59 0 [DEBUG] source: fromupload
2014-02-12 17:14:59 0 [DEBUG] Load from computer: ceny.csv
2014-02-12 17:14:59 0 [DEBUG] local_csv_file:
2014-02-12 17:14:59 0 [DEBUG] urlfile:
2014-02-12 17:14:59 0 [DEBUG] ftphost:
2014-02-12 17:14:59 0 [DEBUG] ftpport:
2014-02-12 17:14:59 0 [DEBUG] ftproot:
2014-02-12 17:14:59 0 [DEBUG] ftpfile:
2014-02-12 17:14:59 0 [DEBUG] auto_detect_delimiters: Да
2014-02-12 17:14:59 0 [DEBUG] field_delimiter:
2014-02-12 17:14:59 0 [DEBUG] text_enclosure:
2014-02-12 17:14:59 0 [DEBUG] use_file_extension:
2014-02-12 17:14:59 0 [DEBUG] im_mac: Нет
2014-02-12 17:14:59 0 [DEBUG] use_column_headers: Да
2014-02-12 17:14:59 0 [DEBUG] add_extra_fields: Нет
2014-02-12 17:14:59 0 [DEBUG] skip_first_line: Нет
2014-02-12 17:14:59 0 [DEBUG] overwrite_existing_data: Да
2014-02-12 17:14:59 0 [DEBUG] ignore_non_exist: Нет
2014-02-12 17:14:59 0 [DEBUG] skip_default_value: Нет
2014-02-12 17:14:59 0 [DEBUG] collect_debug_info: Да
2014-02-12 17:14:59 0 [DEBUG] xml_record_name:
2014-02-12 17:14:59 0 [DEBUG] language: ru-RU
2014-02-12 17:14:59 0 [DEBUG] category_separator: /
2014-02-12 17:14:59 0 [DEBUG] append_categories: Нет
2014-02-12 17:14:59 0 [DEBUG] update_based_on: product_sku
2014-02-12 17:14:59 0 [DEBUG] mpn_column_name:
2014-02-12 17:14:59 0 [DEBUG] unpublish_before_import: Нет
2014-02-12 17:14:59 0 [DEBUG] recreate_alias: Нет
2014-02-12 17:14:59 0 [DEBUG] update_stockable_parent: Нет
2014-02-12 17:14:59 0 [DEBUG] use_icecat: Нет
2014-02-12 17:14:59 0 [DEBUG] similar_sku: Нет
2014-02-12 17:14:59 0 [DEBUG] process_image: Да
2014-02-12 17:14:59 0 [DEBUG] delete_product_images: Нет
2014-02-12 17:14:59 0 [DEBUG] auto_generate_image_name: Нет
2014-02-12 17:14:59 0 [DEBUG] type_generate_image_name: product_sku
2014-02-12 17:14:59 0 [DEBUG] autogenerateext: jpg
2014-02-12 17:14:59 0 [DEBUG] change_case: none
2014-02-12 17:14:59 0 [DEBUG] autofill: Нет
2014-02-12 17:14:59 0 [DEBUG] keep_original: Нет
2014-02-12 17:14:59 0 [DEBUG] convert_type: none
2014-02-12 17:14:59 0 [DEBUG] save_images_on_server: Нет
2014-02-12 17:14:59 0 [DEBUG] redownload_external_image: Да
2014-02-12 17:14:59 0 [DEBUG] full_resize: Нет
2014-02-12 17:14:59 0 [DEBUG] full_width:
2014-02-12 17:14:59 0 [DEBUG] full_height:
2014-02-12 17:14:59 0 [DEBUG] full_watermark: Нет
2014-02-12 17:14:59 0 [DEBUG] full_watermark_right:
2014-02-12 17:14:59 0 [DEBUG] full_watermark_bottom:
2014-02-12 17:14:59 0 [DEBUG] full_watermark_image:
2014-02-12 17:14:59 0 [DEBUG] thumb_check_filetype: Нет
2014-02-12 17:14:59 0 [DEBUG] thumb_create: Нет
2014-02-12 17:14:59 0 [DEBUG] thumb_extension: none
2014-02-12 17:14:59 0 [DEBUG] thumb_width: 90
2014-02-12 17:14:59 0 [DEBUG] thumb_height: 90
2014-02-12 17:14:59 0 [DEBUG] resize_max_width: 1024
2014-02-12 17:14:59 0 [DEBUG] resize_max_height: 768
2014-02-12 17:14:59 0 [DEBUG] file_location_product_files:
2014-02-12 17:14:59 0 [DEBUG] use_system_limits: Нет
2014-02-12 17:14:59 0 [DEBUG] max_execution_time:
2014-02-12 17:14:59 0 [DEBUG] memory_limit:
2014-02-12 17:14:59 0 [DEBUG] post_max_size:
2014-02-12 17:14:59 0 [DEBUG] upload_max_filesize:
2014-02-12 17:14:59 0 [DEBUG] template_name: product
2014-02-12 17:14:59 0 [DEBUG] id: 18
2014-02-12 17:14:59 0 [DEBUG] Load custom fields
2014-02-12 17:14:59 0 [QUERY] SELECT virtuemart_custom_id AS id, field_type, TRIM(custom_title) AS title FROM `odaku_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M')
2014-02-12 17:14:59 0 [DEBUG] Load custom fields
2014-02-12 17:14:59 0 [QUERY] SELECT virtuemart_custom_id AS id, field_type, TRIM(custom_title) AS title FROM `odaku_virtuemart_customs` WHERE `field_type` IN ('S','I','B','D','T','M')
2014-02-12 17:14:59 1 [DEBUG] Use field value
2014-02-12 17:14:59 1 [DEBUG] Use field value
2014-02-12 17:14:59 1 [DEBUG] Process line 1
2014-02-12 17:14:59 1 [DEBUG] Use field value
2014-02-12 17:14:59 1 [DEBUG] Find product ID based on product SKU
2014-02-12 17:14:59 1 [QUERY] SELECT `virtuemart_product_id` FROM `odaku_virtuemart_products` WHERE `product_sku` = 'KT79732'
2014-02-12 17:14:59 1 [DEBUG] Use field value
2014-02-12 17:14:59 1 [DEBUG] Check to see if the vendor ID exists
2014-02-12 17:14:59 1 [QUERY] SELECT IF (COUNT(virtuemart_vendor_id) = 0, 1, virtuemart_vendor_id) AS vendor_id FROM odaku_virtuemart_products WHERE product_sku = 'KT79732'
2014-02-12 17:14:59 1 [DEBUG] Get the product currency
2014-02-12 17:14:59 1 [DEBUG] Get the product currency
2014-02-12 17:14:59 1 [QUERY] SELECT vendor_currency FROM odaku_virtuemart_vendors WHERE virtuemart_vendor_id = 1
2014-02-12 17:14:59 1 [DEBUG] Processing SKU: KT79732
2014-02-12 17:14:59 1 [DEBUG] Product tax
2014-02-12 17:14:59 1 [DEBUG] Manufacturer import
2014-02-12 17:14:59 1 [DEBUG] Retrieve manufacturer ID based on product SKU
2014-02-12 17:14:59 1 [QUERY] SELECT `m`.`virtuemart_manufacturer_id` FROM `odaku_virtuemart_product_manufacturers` AS `m` LEFT JOIN `odaku_virtuemart_products` AS `p` ON `m`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `p`.`product_sku` = 'KT79732'
2014-02-12 17:14:59 1 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 1 [QUERY] SELECT * FROM odaku_virtuemart_manufacturers_ru_ru WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 1 [DEBUG] Manufacturer language query
2014-02-12 17:14:59 1 [QUERY] UPDATE `odaku_virtuemart_manufacturers_ru_ru` SET `mf_name`='Acer',`mf_email`='',`mf_desc`='<p><span>Acer — тайваньская компания по производству компьютерной техники и электроники.</span></p>',`mf_url`='http://www.acer.ua',`slug`='acer' WHERE `virtuemart_manufacturer_id`='1'
2014-02-12 17:14:59 1 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 1 [QUERY] SELECT virtuemart_manufacturer_id FROM odaku_virtuemart_manufacturers WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 1 [DEBUG] Product query
2014-02-12 17:14:59 1 [QUERY] UPDATE `odaku_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='KT79732',`product_weight`='0.0000',`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`='0',`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=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='0',`created_on`='2014-02-12 16:23:18',`created_by`='42',`modified_on`='2014-02-12 17:14:59',`modified_by`='42',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='335'
2014-02-12 17:14:59 1 [DEBUG] Check product language entry
2014-02-12 17:14:59 1 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 335
2014-02-12 17:14:59 1 [DEBUG] Product language query
2014-02-12 17:14:59 1 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 335
2014-02-12 17:14:59 1 [DEBUG] Finding a product_price_id
2014-02-12 17:14:59 1 [QUERY] SELECT `virtuemart_product_price_id` FROM `odaku_virtuemart_product_prices` WHERE `virtuemart_product_id` = '335' AND `virtuemart_shoppergroup_id` = '0' AND `product_currency` = '199' 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)
2014-02-12 17:14:59 1 [DEBUG] Storing price
2014-02-12 17:14:59 1 [SQL ERROR] Unknown column 'product_price_publish_up' in 'field list' SQL=INSERT INTO `odaku_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`product_price_publish_up`,`product_price_publish_down`) VALUES ('335','0','32573','0','199','0','0','2014-02-12 17:14:59','42','2014-02-12 17:14:59','42','0000-00-00 00:00:00','0000-00-00 00:00:00')
2014-02-12 17:14:59 1 [DEBUG] No custom available fields found
2014-02-12 17:14:59 2 [DEBUG] Use field value
2014-02-12 17:14:59 2 [DEBUG] Use field value
2014-02-12 17:14:59 2 [DEBUG] Process line 2
2014-02-12 17:14:59 2 [DEBUG] Use field value
2014-02-12 17:14:59 2 [DEBUG] Find product ID based on product SKU
2014-02-12 17:14:59 2 [QUERY] SELECT `virtuemart_product_id` FROM `odaku_virtuemart_products` WHERE `product_sku` = 'KT67972'
2014-02-12 17:14:59 2 [DEBUG] Use field value
2014-02-12 17:14:59 2 [DEBUG] Check to see if the vendor ID exists
2014-02-12 17:14:59 2 [QUERY] SELECT IF (COUNT(virtuemart_vendor_id) = 0, 1, virtuemart_vendor_id) AS vendor_id FROM odaku_virtuemart_products WHERE product_sku = 'KT67972'
2014-02-12 17:14:59 2 [DEBUG] Get the product currency
2014-02-12 17:14:59 2 [DEBUG] Processing SKU: KT67972
2014-02-12 17:14:59 2 [DEBUG] Product tax
2014-02-12 17:14:59 2 [DEBUG] Manufacturer import
2014-02-12 17:14:59 2 [DEBUG] Retrieve manufacturer ID based on product SKU
2014-02-12 17:14:59 2 [QUERY] SELECT `m`.`virtuemart_manufacturer_id` FROM `odaku_virtuemart_product_manufacturers` AS `m` LEFT JOIN `odaku_virtuemart_products` AS `p` ON `m`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `p`.`product_sku` = 'KT67972'
2014-02-12 17:14:59 2 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 2 [QUERY] SELECT * FROM odaku_virtuemart_manufacturers_ru_ru WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 2 [DEBUG] Manufacturer language query
2014-02-12 17:14:59 2 [QUERY] UPDATE `odaku_virtuemart_manufacturers_ru_ru` SET `mf_name`='Acer',`mf_email`='',`mf_desc`='<p><span>Acer — тайваньская компания по производству компьютерной техники и электроники.</span></p>',`mf_url`='http://www.acer.ua',`slug`='acer' WHERE `virtuemart_manufacturer_id`='1'
2014-02-12 17:14:59 2 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 2 [QUERY] SELECT virtuemart_manufacturer_id FROM odaku_virtuemart_manufacturers WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 2 [DEBUG] Product query
2014-02-12 17:14:59 2 [QUERY] UPDATE `odaku_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='KT67972',`product_weight`='0.0000',`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`='0',`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=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='0',`created_on`='2014-02-12 16:23:18',`created_by`='42',`modified_on`='2014-02-12 17:14:59',`modified_by`='42',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='336'
2014-02-12 17:14:59 2 [DEBUG] Check product language entry
2014-02-12 17:14:59 2 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 336
2014-02-12 17:14:59 2 [DEBUG] Product language query
2014-02-12 17:14:59 2 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 336
2014-02-12 17:14:59 2 [DEBUG] Finding a product_price_id
2014-02-12 17:14:59 2 [QUERY] SELECT `virtuemart_product_price_id` FROM `odaku_virtuemart_product_prices` WHERE `virtuemart_product_id` = '336' AND `virtuemart_shoppergroup_id` = '0' AND `product_currency` = '199' 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)
2014-02-12 17:14:59 2 [DEBUG] Storing price
2014-02-12 17:14:59 2 [SQL ERROR] Unknown column 'product_price_publish_up' in 'field list' SQL=INSERT INTO `odaku_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`product_price_publish_up`,`product_price_publish_down`) VALUES ('336','0','37955','0','199','0','0','2014-02-12 17:14:59','42','2014-02-12 17:14:59','42','0000-00-00 00:00:00','0000-00-00 00:00:00')
2014-02-12 17:14:59 2 [DEBUG] No custom available fields found
2014-02-12 17:14:59 3 [DEBUG] Use field value
2014-02-12 17:14:59 3 [DEBUG] Use field value
2014-02-12 17:14:59 3 [DEBUG] Process line 3
2014-02-12 17:14:59 3 [DEBUG] Use field value
2014-02-12 17:14:59 3 [DEBUG] Find product ID based on product SKU
2014-02-12 17:14:59 3 [QUERY] SELECT `virtuemart_product_id` FROM `odaku_virtuemart_products` WHERE `product_sku` = 'КТ67386'
2014-02-12 17:14:59 3 [DEBUG] Use field value
2014-02-12 17:14:59 3 [DEBUG] Check to see if the vendor ID exists
2014-02-12 17:14:59 3 [QUERY] SELECT IF (COUNT(virtuemart_vendor_id) = 0, 1, virtuemart_vendor_id) AS vendor_id FROM odaku_virtuemart_products WHERE product_sku = 'КТ67386'
2014-02-12 17:14:59 3 [DEBUG] Get the product currency
2014-02-12 17:14:59 3 [DEBUG] Processing SKU: КТ67386
2014-02-12 17:14:59 3 [DEBUG] Product tax
2014-02-12 17:14:59 3 [DEBUG] Manufacturer import
2014-02-12 17:14:59 3 [DEBUG] Retrieve manufacturer ID based on product SKU
2014-02-12 17:14:59 3 [QUERY] SELECT `m`.`virtuemart_manufacturer_id` FROM `odaku_virtuemart_product_manufacturers` AS `m` LEFT JOIN `odaku_virtuemart_products` AS `p` ON `m`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `p`.`product_sku` = 'КТ67386'
2014-02-12 17:14:59 3 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 3 [QUERY] SELECT * FROM odaku_virtuemart_manufacturers_ru_ru WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 3 [DEBUG] Manufacturer language query
2014-02-12 17:14:59 3 [QUERY] UPDATE `odaku_virtuemart_manufacturers_ru_ru` SET `mf_name`='Acer',`mf_email`='',`mf_desc`='<p><span>Acer — тайваньская компания по производству компьютерной техники и электроники.</span></p>',`mf_url`='http://www.acer.ua',`slug`='acer' WHERE `virtuemart_manufacturer_id`='1'
2014-02-12 17:14:59 3 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 3 [QUERY] SELECT virtuemart_manufacturer_id FROM odaku_virtuemart_manufacturers WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 3 [DEBUG] Product query
2014-02-12 17:14:59 3 [QUERY] UPDATE `odaku_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='КТ67386',`product_weight`='0.0000',`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`='0',`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=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='0',`created_on`='2014-02-11 23:31:52',`created_by`='42',`modified_on`='2014-02-12 17:14:59',`modified_by`='42',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='145'
2014-02-12 17:14:59 3 [DEBUG] Check product language entry
2014-02-12 17:14:59 3 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 145
2014-02-12 17:14:59 3 [DEBUG] Product language query
2014-02-12 17:14:59 3 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 145
2014-02-12 17:14:59 3 [DEBUG] Finding a product_price_id
2014-02-12 17:14:59 3 [QUERY] SELECT `virtuemart_product_price_id` FROM `odaku_virtuemart_product_prices` WHERE `virtuemart_product_id` = '145' AND `virtuemart_shoppergroup_id` = '0' AND `product_currency` = '199' 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)
2014-02-12 17:14:59 3 [DEBUG] Storing price
2014-02-12 17:14:59 3 [SQL ERROR] Unknown column 'product_price_publish_up' in 'field list' SQL=INSERT INTO `odaku_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`product_price_publish_up`,`product_price_publish_down`) VALUES ('145','0','38629','0','199','0','0','2014-02-12 17:14:59','42','2014-02-12 17:14:59','42','0000-00-00 00:00:00','0000-00-00 00:00:00')
2014-02-12 17:14:59 3 [DEBUG] No custom available fields found
2014-02-12 17:14:59 4 [DEBUG] Use field value
2014-02-12 17:14:59 4 [DEBUG] Use field value
2014-02-12 17:14:59 4 [DEBUG] Process line 4
2014-02-12 17:14:59 4 [DEBUG] Use field value
2014-02-12 17:14:59 4 [DEBUG] Find product ID based on product SKU
2014-02-12 17:14:59 4 [QUERY] SELECT `virtuemart_product_id` FROM `odaku_virtuemart_products` WHERE `product_sku` = 'КТ77718'
2014-02-12 17:14:59 4 [DEBUG] Use field value
2014-02-12 17:14:59 4 [DEBUG] Check to see if the vendor ID exists
2014-02-12 17:14:59 4 [QUERY] SELECT IF (COUNT(virtuemart_vendor_id) = 0, 1, virtuemart_vendor_id) AS vendor_id FROM odaku_virtuemart_products WHERE product_sku = 'КТ77718'
2014-02-12 17:14:59 4 [DEBUG] Get the product currency
2014-02-12 17:14:59 4 [DEBUG] Processing SKU: КТ77718
2014-02-12 17:14:59 4 [DEBUG] Product tax
2014-02-12 17:14:59 4 [DEBUG] Manufacturer import
2014-02-12 17:14:59 4 [DEBUG] Retrieve manufacturer ID based on product SKU
2014-02-12 17:14:59 4 [QUERY] SELECT `m`.`virtuemart_manufacturer_id` FROM `odaku_virtuemart_product_manufacturers` AS `m` LEFT JOIN `odaku_virtuemart_products` AS `p` ON `m`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `p`.`product_sku` = 'КТ77718'
2014-02-12 17:14:59 4 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 4 [QUERY] SELECT * FROM odaku_virtuemart_manufacturers_ru_ru WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 4 [DEBUG] Manufacturer language query
2014-02-12 17:14:59 4 [QUERY] UPDATE `odaku_virtuemart_manufacturers_ru_ru` SET `mf_name`='Acer',`mf_email`='',`mf_desc`='<p><span>Acer — тайваньская компания по производству компьютерной техники и электроники.</span></p>',`mf_url`='http://www.acer.ua',`slug`='acer' WHERE `virtuemart_manufacturer_id`='1'
2014-02-12 17:14:59 4 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 4 [QUERY] SELECT virtuemart_manufacturer_id FROM odaku_virtuemart_manufacturers WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 4 [DEBUG] Product query
2014-02-12 17:14:59 4 [QUERY] UPDATE `odaku_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='КТ77718',`product_weight`='0.0000',`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`='0',`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=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='0',`created_on`='2014-02-11 23:31:52',`created_by`='42',`modified_on`='2014-02-12 17:14:59',`modified_by`='42',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='146'
2014-02-12 17:14:59 4 [DEBUG] Check product language entry
2014-02-12 17:14:59 4 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 146
2014-02-12 17:14:59 4 [DEBUG] Product language query
2014-02-12 17:14:59 4 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 146
2014-02-12 17:14:59 4 [DEBUG] Finding a product_price_id
2014-02-12 17:14:59 4 [QUERY] SELECT `virtuemart_product_price_id` FROM `odaku_virtuemart_product_prices` WHERE `virtuemart_product_id` = '146' AND `virtuemart_shoppergroup_id` = '0' AND `product_currency` = '199' 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)
2014-02-12 17:14:59 4 [DEBUG] Storing price
2014-02-12 17:14:59 4 [SQL ERROR] Unknown column 'product_price_publish_up' in 'field list' SQL=INSERT INTO `odaku_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`product_price_publish_up`,`product_price_publish_down`) VALUES ('146','0','36088','0','199','0','0','2014-02-12 17:14:59','42','2014-02-12 17:14:59','42','0000-00-00 00:00:00','0000-00-00 00:00:00')
2014-02-12 17:14:59 4 [DEBUG] No custom available fields found
2014-02-12 17:14:59 5 [DEBUG] Use field value
2014-02-12 17:14:59 5 [DEBUG] Use field value
2014-02-12 17:14:59 5 [DEBUG] Process line 5
2014-02-12 17:14:59 5 [DEBUG] Use field value
2014-02-12 17:14:59 5 [DEBUG] Find product ID based on product SKU
2014-02-12 17:14:59 5 [QUERY] SELECT `virtuemart_product_id` FROM `odaku_virtuemart_products` WHERE `product_sku` = 'КТ77303'
2014-02-12 17:14:59 5 [DEBUG] Use field value
2014-02-12 17:14:59 5 [DEBUG] Check to see if the vendor ID exists
2014-02-12 17:14:59 5 [QUERY] SELECT IF (COUNT(virtuemart_vendor_id) = 0, 1, virtuemart_vendor_id) AS vendor_id FROM odaku_virtuemart_products WHERE product_sku = 'КТ77303'
2014-02-12 17:14:59 5 [DEBUG] Get the product currency
2014-02-12 17:14:59 5 [DEBUG] Processing SKU: КТ77303
2014-02-12 17:14:59 5 [DEBUG] Product tax
2014-02-12 17:14:59 5 [DEBUG] Manufacturer import
2014-02-12 17:14:59 5 [DEBUG] Retrieve manufacturer ID based on product SKU
2014-02-12 17:14:59 5 [QUERY] SELECT `m`.`virtuemart_manufacturer_id` FROM `odaku_virtuemart_product_manufacturers` AS `m` LEFT JOIN `odaku_virtuemart_products` AS `p` ON `m`.`virtuemart_product_id` = `p`.`virtuemart_product_id` WHERE `p`.`product_sku` = 'КТ77303'
2014-02-12 17:14:59 5 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 5 [QUERY] SELECT * FROM odaku_virtuemart_manufacturers_ru_ru WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 5 [DEBUG] Manufacturer language query
2014-02-12 17:14:59 5 [QUERY] UPDATE `odaku_virtuemart_manufacturers_ru_ru` SET `mf_name`='Acer',`mf_email`='',`mf_desc`='<p><span>Acer — тайваньская компания по производству компьютерной техники и электроники.</span></p>',`mf_url`='http://www.acer.ua',`slug`='acer' WHERE `virtuemart_manufacturer_id`='1'
2014-02-12 17:14:59 5 [DEBUG] Manufacturer already exists
2014-02-12 17:14:59 5 [QUERY] SELECT virtuemart_manufacturer_id FROM odaku_virtuemart_manufacturers WHERE `virtuemart_manufacturer_id` = '1'
2014-02-12 17:14:59 5 [DEBUG] Product query
2014-02-12 17:14:59 5 [QUERY] UPDATE `odaku_virtuemart_products` SET `virtuemart_vendor_id`='1',`product_parent_id`='0',`product_sku`='КТ77303',`product_weight`='0.0000',`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`='0',`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=\"\"|max_order_level=\"\"|step_order_level=\"\"|product_box=\"\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='0',`created_on`='2014-02-11 23:31:52',`created_by`='42',`modified_on`='2014-02-12 17:14:59',`modified_by`='42',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_product_id`='147'
2014-02-12 17:14:59 5 [DEBUG] Check product language entry
2014-02-12 17:14:59 5 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 147
2014-02-12 17:14:59 5 [DEBUG] Product language query
2014-02-12 17:14:59 5 [QUERY] SELECT virtuemart_product_id FROM odaku_virtuemart_products_ru_ru WHERE `virtuemart_product_id` = 147
2014-02-12 17:14:59 5 [DEBUG] Finding a product_price_id
2014-02-12 17:14:59 5 [QUERY] SELECT `virtuemart_product_price_id` FROM `odaku_virtuemart_product_prices` WHERE `virtuemart_product_id` = '147' AND `virtuemart_shoppergroup_id` = '0' AND `product_currency` = '199' 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)
2014-02-12 17:14:59 5 [DEBUG] Storing price
2014-02-12 17:14:59 5 [SQL ERROR] Unknown column 'product_price_publish_up' in 'field list' SQL=INSERT INTO `odaku_virtuemart_product_prices` (`virtuemart_product_id`,`virtuemart_shoppergroup_id`,`product_price`,`override`,`product_currency`,`price_quantity_start`,`price_quantity_end`,`created_on`,`created_by`,`modified_on`,`modified_by`,`product_price_publish_up`,`product_price_publish_down`) VALUES ('147','0','3744','0','199','0','0','2014-02-12 17:14:59','42','2014-02-12 17:14:59','42','0000-00-00 00:00:00','0000-00-00 00:00:00')
2014-02-12 17:14:59 5 [DEBUG] No custom available fields found
2014-02-12 17:14:59 20 [DEBUG] Clean up old logs. Found 26 logs and threshold is 25 logs