| 2015-09-28 |
08:43:26 |
0 |
[DEBUG] |
Clean up old logs. Found 26 logs and threshold is 25 logs
|
| 2015-09-28 |
08:43:26 |
0 |
[QUERY] |
SELECT csvi_log_id FROM k7hAg_csvi_logs ORDER BY csvi_log_id
|
| 2015-09-28 |
08:43:49 |
0 |
[DEBUG] |
Clean up old logs. Found 25 logs and threshold is 25 logs
|
| 2015-09-28 |
08:43:49 |
0 |
[QUERY] |
SELECT csvi_log_id FROM k7hAg_csvi_logs ORDER BY csvi_log_id
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Found field delimiter: |
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Loading the supported fields for com_virtuemart, operation product and action import
|
| 2015-09-28 |
08:43:50 |
0 |
[QUERY] |
SELECT `a`.`csvi_name` FROM `k7hAg_csvi_availablefields`
AS `a` LEFT JOIN `k7hAg_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'
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Load the fields to process
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: product_sku
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: product_name
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: slug
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: category_path
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: product_s_desc
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: published
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: file_title
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: file_description
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: file_meta
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: file_url
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: metadesc
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Setup field: metakey
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Use the file for configuration
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
==========
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
CSVI Pro Version: 6.1.2
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
PHP version: 5.5.29
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Action: import
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Component: com_virtuemart
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Operation: product
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Source: fromupload
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Load from computer: /home/netiweb/domains/44.tapicerska.pl/public_html/tmp/com_csvi/1443429810/Import_Produkty-2.csv
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Load from server:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Delete after import: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Load from URL:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
FTP Host:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
FTP Port:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
FTP Root Folder:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
FTP Filename:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Autodetect delimiters: Yes
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Field Delimiter: comma
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Text Enclosure:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Use file extension:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
I'm Mac: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Use file for configuration: Yes
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Add extra fields: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Skip first line: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Overwrite existing data: Yes
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Skip new items: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Record name:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Language: pl-PL
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Category separator: /
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Append categories: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Import based on: product_sku
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Unpublish before import: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Recreate alias: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Force stockable parent update: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Use ICEcat data: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Similar SKU search: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Process images: Yes
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Location product files:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Delete image relations: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Create image name: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Image name based on: product_sku
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Image name format: jpg
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Change case: none
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Fill media fields: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Keep original file: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Convert image type: none
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Save images on server: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Re-download image: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Resize large image: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Full image width:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Full image height:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Check filetype: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Automatic thumbnail creation: Yes
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Thumbnail type: none
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Thumbnail width: 380
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Thumbnail height: 285
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Maximum width resize: 1024
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Maximum height resize: 768
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Watermark: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Right margin:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Bottom margin:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Image:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Lines per import: 1000
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Time between imports: 5
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Override system limits?: No
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Maximum execution time:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Maximum amount of memory:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Maximum size of POST data in megabytes:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Maximum allowed size for uploaded files in megabytes:
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
==========
|
| 2015-09-28 |
08:43:50 |
0 |
[DEBUG] |
Load the custom fields
|
| 2015-09-28 |
08:43:50 |
0 |
[QUERY] |
SELECT `virtuemart_custom_id` AS `id`, `field_type`,
TRIM(`custom_title`) AS title FROM `k7hAg_virtuemart_customs` WHERE
`field_type` IN ('S','I','B','D','T','M','Y','X')
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field published
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Process line 1
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Check if the vendor exists
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
SELECT IF (COUNT(`virtuemart_vendor_id`) = 0, 1,
`virtuemart_vendor_id`) AS vendor_id FROM `k7hAg_virtuemart_products`
WHERE `product_sku` = '1'
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Load a row
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Product tax:
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Query for Product
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='1',`virtuemart_vendor_id`='1',`product_parent_id`='0',`product_gtin`='',`product_mpn`='',`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=\"0\"|max_order_level=\"0\"|step_order_level=\"\"|product_box=\"0\"|',`hits`='0',`intnotes`='',`metarobot`='',`metaauthor`='',`layout`='0',`published`='1',`pordering`='0',`created_on`='2015-08-25
11:21:23',`created_by`='626',`modified_on`='2015-09-28
08:43:50',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='1'
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Check product language entry
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 1
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Load a row
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'hamaki-ogrodowe' AND
`virtuemart_product_id` != 1
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET `product_s_desc`=' Hamaki
to fantastyczna forma relaksu na świeżym powietrzu. Można zamontować je
praktycznie wszędzie, gdzie będą dostępne dwa punkty zaczepienia.
Jeżeli nie mamy gdzie zaczepić hamaka, można wybrać wersje ze stelażem i cieszyć się wypoczynkiem w ulubionym miejscu. ',`product_desc`='',`product_name`='Hamaki
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='hamaki-ogrodowe'
WHERE `virtuemart_product_id`='1'
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Process image file
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Query for Media
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
UPDATE `k7hAg_virtuemart_medias` SET
`virtuemart_vendor_id`='1',`file_title`='Zaślepka',`file_description`='Zaślepka',`file_meta`='Zaślepka',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='product',`file_url`='images/stories/virtuemart/product/zaslepka_produkt.jpg',`file_url_thumb`='',`file_is_product_image`='1',`file_is_downloadable`='0',`file_is_forSale`='0',`file_params`='',`file_lang`='',`shared`='0',`published`='1',`created_on`='0000-00-00
00:00:00',`created_by`='0',`modified_on`='0000-00-00
00:00:00',`modified_by`='0',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `virtuemart_media_id`='11'
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Product image relation exists
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
No custom available fields found
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
SELECT `id` FROM `k7hAg_virtuemart_product_medias` WHERE `virtuemart_product_id` = 1 AND `virtuemart_media_id` = 11
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Checking category
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Check if category path exists: Ogród
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
SELECT `c`.`virtuemart_category_id` FROM
`k7hAg_virtuemart_categories` AS `c` LEFT JOIN
`k7hAg_virtuemart_category_categories` AS `x` ON
`c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN
`k7hAg_virtuemart_categories_pl_pl` AS `l` ON
`l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE
`l`.`category_name` = 'Ogród' AND `x`.`category_child_id` =
`c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
Check if category path exists: Meble ogrodowe
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
SELECT `c`.`virtuemart_category_id` FROM
`k7hAg_virtuemart_categories` AS `c` LEFT JOIN
`k7hAg_virtuemart_category_categories` AS `x` ON
`c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN
`k7hAg_virtuemart_categories_pl_pl` AS `l` ON
`l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE
`l`.`category_name` = 'Meble ogrodowe' AND `x`.`category_child_id` =
`c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 99
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1
AND `virtuemart_category_id` = 99
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('1','99')
|
| 2015-09-28 |
08:43:50 |
1 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('1','99')
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1
AND `virtuemart_category_id` = 117
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-28 |
08:43:50 |
1 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('1','117','0')
|
| 2015-09-28 |
08:43:50 |
1 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-28 |
08:43:50 |
1 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('1','117','0')
|