| 2015-09-25 |
08:42:18 |
0 |
[DEBUG] |
Clean up old logs. Found 26 logs and threshold is 25 logs
|
| 2015-09-25 |
08:42:18 |
0 |
[QUERY] |
SELECT csvi_log_id FROM k7hAg_csvi_logs ORDER BY csvi_log_id
|
| 2015-09-25 |
08:42:22 |
0 |
[DEBUG] |
Clean up old logs. Found 25 logs and threshold is 25 logs
|
| 2015-09-25 |
08:42:22 |
0 |
[QUERY] |
SELECT csvi_log_id FROM k7hAg_csvi_logs ORDER BY csvi_log_id
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Found field delimiter: |
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Loading the supported fields for com_virtuemart, operation product and action import
|
| 2015-09-25 |
08:42:23 |
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-25 |
08:42:23 |
0 |
[DEBUG] |
Load the fields to process
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: product_sku
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: product_name
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: slug
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: category_path
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: product_s_desc
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: published
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: file_title
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: file_description
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: file_meta
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: file_url
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: file_url_thumb
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: metadesc
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Setup field: metakey
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Use the file for configuration
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
==========
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
CSVI Pro Version: 6.1.2
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
PHP version: 5.5.29
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Action: import
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Component: com_virtuemart
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Operation: product
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Source: fromupload
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Load from computer: /home/netiweb/domains/44.tapicerska.pl/public_html/tmp/com_csvi/1443170541/Import_Produkty.csv
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Load from server:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Delete after import: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Load from URL:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
FTP Host:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
FTP Port:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
FTP Root Folder:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
FTP Filename:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Autodetect delimiters: Yes
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Field Delimiter: comma
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Text Enclosure:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Use file extension:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
I'm Mac: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Use file for configuration: Yes
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Add extra fields: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Skip first line: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Overwrite existing data: Yes
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Skip new items: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Record name:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Language: pl-PL
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Category separator: /
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Append categories: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Import based on: product_sku
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Unpublish before import: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Recreate alias: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Force stockable parent update: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Use ICEcat data: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Similar SKU search: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Process images: Yes
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Location product files:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Delete image relations: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Create image name: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Image name based on: product_sku
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Image name format: jpg
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Change case: none
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Fill media fields: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Keep original file: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Convert image type: none
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Save images on server: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Re-download image: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Resize large image: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Full image width:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Full image height:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Check filetype: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Automatic thumbnail creation: Yes
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Thumbnail type: none
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Thumbnail width: 380
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Thumbnail height: 285
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Maximum width resize: 1024
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Maximum height resize: 768
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Watermark: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Right margin:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Bottom margin:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Image:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Lines per import: 1000
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Time between imports: 5
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Override system limits?: No
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Maximum execution time:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Maximum amount of memory:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Maximum size of POST data in megabytes:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Maximum allowed size for uploaded files in megabytes:
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
==========
|
| 2015-09-25 |
08:42:23 |
0 |
[DEBUG] |
Load the custom fields
|
| 2015-09-25 |
08:42:23 |
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-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Process line 1
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Check if the vendor exists
|
| 2015-09-25 |
08:42:23 |
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-25 |
08:42:23 |
1 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='1'
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 1
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'hamaki-ogrodowe' AND
`virtuemart_product_id` != 1
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Hamaki
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='hamaki-ogrodowe'
WHERE `virtuemart_product_id`='1'
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
INSERT INTO `k7hAg_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','Zaślepka','Zaślepka','Zaślepka','','image/jpeg','product','images/stories/virtuemart/product/zaslepka_produkt.jpg','','1','0','0','','','0','1','0000-00-00
00:00:00','0','0000-00-00 00:00:00','0','0000-00-00 00:00:00','0')
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('1','7','1')
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,1,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
Check if category path exists: Ogród
|
| 2015-09-25 |
08:42:23 |
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-25 |
08:42:23 |
1 |
[DEBUG] |
Check if category path exists: Meble ogrodowe
|
| 2015-09-25 |
08:42:23 |
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-25 |
08:42:23 |
1 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1
AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('1','99')
|
| 2015-09-25 |
08:42:23 |
1 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories` (`virtuemart_product_id`,`virtuemart_category_id`) VALUES ('1','99')
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 1
AND `virtuemart_category_id` = 117
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
1 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('1','117','0')
|
| 2015-09-25 |
08:42:23 |
1 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
1 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('1','117','0')
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Process line 2
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='2',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='2'
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 2
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'hustawki-ogrodowe' AND
`virtuemart_product_id` != 2
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Huśtawki
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='hustawki-ogrodowe'
WHERE `virtuemart_product_id`='2'
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
2 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('2','7','1')
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,2,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2
AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('2','99','0')
|
| 2015-09-25 |
08:42:23 |
2 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('2','99','0')
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 2
AND `virtuemart_category_id` = 117
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
2 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('2','117','0')
|
| 2015-09-25 |
08:42:23 |
2 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
2 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('2','117','0')
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Process line 3
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='3',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='3'
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 3
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'krzesla-ogrodowe' AND
`virtuemart_product_id` != 3
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Krzesła
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='krzesla-ogrodowe'
WHERE `virtuemart_product_id`='3'
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
3 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('3','7','1')
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,3,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 3
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 3
AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('3','99','0')
|
| 2015-09-25 |
08:42:23 |
3 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('3','99','0')
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 3
AND `virtuemart_category_id` = 117
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
3 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('3','117','0')
|
| 2015-09-25 |
08:42:23 |
3 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
3 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('3','117','0')
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Process line 4
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='4',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='4'
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 4
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'lezaki-ogrodowe' AND
`virtuemart_product_id` != 4
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Leżaki
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='lezaki-ogrodowe'
WHERE `virtuemart_product_id`='4'
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
4 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('4','7','1')
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,4,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 4
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 4
AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('4','99','0')
|
| 2015-09-25 |
08:42:23 |
4 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('4','99','0')
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 4
AND `virtuemart_category_id` = 117
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
4 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('4','117','0')
|
| 2015-09-25 |
08:42:23 |
4 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
4 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('4','117','0')
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Process line 5
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='5',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='5'
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 5
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'lawki-ogrodowe' AND
`virtuemart_product_id` != 5
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Ławki
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='lawki-ogrodowe'
WHERE `virtuemart_product_id`='5'
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
5 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('5','7','1')
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,5,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5
AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('5','99','0')
|
| 2015-09-25 |
08:42:23 |
5 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('5','99','0')
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 5
AND `virtuemart_category_id` = 117
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
5 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('5','117','0')
|
| 2015-09-25 |
08:42:23 |
5 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
5 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('5','117','0')
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Process line 6
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='6',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='6'
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 6
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'parasole-ogrodowe' AND
`virtuemart_product_id` != 6
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Parasole
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='parasole-ogrodowe'
WHERE `virtuemart_product_id`='6'
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
6 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('6','7','1')
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,6,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 6
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 6
AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('6','99','0')
|
| 2015-09-25 |
08:42:23 |
6 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('6','99','0')
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 6
AND `virtuemart_category_id` = 117
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
6 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('6','117','0')
|
| 2015-09-25 |
08:42:23 |
6 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
6 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('6','117','0')
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Process line 7
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='7',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='7'
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 7
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'stoly-ogrodowe' AND
`virtuemart_product_id` != 7
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Stoły
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='stoly-ogrodowe'
WHERE `virtuemart_product_id`='7'
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
7 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('7','7','1')
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,7,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 7
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 7
AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('7','99','0')
|
| 2015-09-25 |
08:42:23 |
7 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('7','99','0')
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 7
AND `virtuemart_category_id` = 117
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
7 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('7','117','0')
|
| 2015-09-25 |
08:42:23 |
7 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
7 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('7','117','0')
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Process line 8
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='8',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='8'
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 8
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'zestawy-ogrodowe' AND
`virtuemart_product_id` != 8
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Zestawy
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='zestawy-ogrodowe'
WHERE `virtuemart_product_id`='8'
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
8 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('8','7','1')
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,8,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 8
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 8
AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('8','99','0')
|
| 2015-09-25 |
08:42:23 |
8 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('8','99','0')
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 8
AND `virtuemart_category_id` = 117
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
8 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('8','117','0')
|
| 2015-09-25 |
08:42:23 |
8 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
8 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('8','117','0')
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Process line 9
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='9',`virtuemart_vendor_id`='1',`product_parent_id`='0',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='9'
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 9
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'kinkiety-ogrodowe' AND
`virtuemart_product_id` != 9
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Kinkiety
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='kinkiety-ogrodowe'
WHERE `virtuemart_product_id`='9'
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
9 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('9','7','1')
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,9,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
Check if category path exists: Oświetlenie ogrodowe
|
| 2015-09-25 |
08:42:23 |
9 |
[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` = 'Oświetlenie ogrodowe' AND `x`.`category_child_id`
= `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 99
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 9
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 9
AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('9','99','0')
|
| 2015-09-25 |
08:42:23 |
9 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('9','99','0')
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 9
AND `virtuemart_category_id` = 119
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
9 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('9','119','0')
|
| 2015-09-25 |
08:42:23 |
9 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
9 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('9','119','0')
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Process line 10
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='10',`virtuemart_vendor_id`='1',`product_parent_id`='0',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='10'
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 10
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'lampy-ogrodowe' AND
`virtuemart_product_id` != 10
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Lampy
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='lampy-ogrodowe'
WHERE `virtuemart_product_id`='10'
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
10 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('10','7','1')
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,10,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 10
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
10 AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('10','99','0')
|
| 2015-09-25 |
08:42:23 |
10 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('10','99','0')
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
10 AND `virtuemart_category_id` = 119
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
10 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('10','119','0')
|
| 2015-09-25 |
08:42:23 |
10 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
10 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('10','119','0')
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Process line 11
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='11',`virtuemart_vendor_id`='1',`product_parent_id`='0',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='11'
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 11
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'latarnie-ogrodowe' AND
`virtuemart_product_id` != 11
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Latarnie
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='latarnie-ogrodowe'
WHERE `virtuemart_product_id`='11'
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
11 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('11','7','1')
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,11,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 11
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
11 AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('11','99','0')
|
| 2015-09-25 |
08:42:23 |
11 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('11','99','0')
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
11 AND `virtuemart_category_id` = 119
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
11 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('11','119','0')
|
| 2015-09-25 |
08:42:23 |
11 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
11 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('11','119','0')
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Process line 12
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='12',`virtuemart_vendor_id`='1',`product_parent_id`='0',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='12'
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 12
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'reflektory-ogrodowe' AND
`virtuemart_product_id` != 12
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Reflektory
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='reflektory-ogrodowe'
WHERE `virtuemart_product_id`='12'
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
12 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('12','7','1')
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,12,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 12
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
12 AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('12','99','0')
|
| 2015-09-25 |
08:42:23 |
12 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('12','99','0')
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
12 AND `virtuemart_category_id` = 119
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
12 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('12','119','0')
|
| 2015-09-25 |
08:42:23 |
12 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
12 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('12','119','0')
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Process line 13
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='13',`virtuemart_vendor_id`='1',`product_parent_id`='0',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='13'
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 13
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'swiece-ogrodowe' AND
`virtuemart_product_id` != 13
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Świece
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='swiece-ogrodowe'
WHERE `virtuemart_product_id`='13'
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
13 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('13','7','1')
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,13,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 13
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
13 AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('13','99','0')
|
| 2015-09-25 |
08:42:23 |
13 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('13','99','0')
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
13 AND `virtuemart_category_id` = 119
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
13 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('13','119','0')
|
| 2015-09-25 |
08:42:23 |
13 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
13 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('13','119','0')
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field product_sku
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field product_name
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field slug
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field category_path
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field product_s_desc
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field published
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field file_title
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field file_description
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field file_meta
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field file_url
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field file_url_thumb
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field metadesc
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Use field value for field metakey
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Process line 14
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Product tax:
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Query for Product
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products` SET
`virtuemart_product_id`='14',`virtuemart_vendor_id`='1',`product_parent_id`='0',`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-25
08:42:23',`modified_by`='626',`locked_on`='0000-00-00
00:00:00',`locked_by`='0' WHERE `product_sku`='14'
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Check product language entry
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
SELECT `virtuemart_product_id`,`slug` FROM `k7hAg_virtuemart_products_pl_pl` WHERE `virtuemart_product_id` = 14
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Load a row
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Check if the product slug exists
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
SELECT COUNT(`virtuemart_product_id`) FROM
k7hAg_virtuemart_products_pl_pl WHERE `slug` = 'zarowki-oprawy-ogrodowe'
AND `virtuemart_product_id` != 14
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Query for ProductLang
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
UPDATE `k7hAg_virtuemart_products_pl_pl` SET
`product_s_desc`='desc',`product_desc`='',`product_name`='Żarówki,
oprawy
ogrodowe',`metadesc`='metadesc',`metakey`='metakey',`customtitle`='',`slug`='zarowki-oprawy-ogrodowe'
WHERE `virtuemart_product_id`='14'
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Process file: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Process image file
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Identity string: ffd8ffe000104a46494600010101004800480000
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Mime type found: image/jpeg
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Full name original: /home/netiweb/domains/44.tapicerska.pl/public_html/images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Full name target: images/stories/virtuemart/product/zaslepka_produkt.jpg
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Query for Media
|
| 2015-09-25 |
08:42:23 |
14 |
[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`='7'
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Query for ProductMedia
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_medias` (`virtuemart_product_id`,`virtuemart_media_id`,`ordering`) VALUES ('14','7','1')
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Store product image relation
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Checking manufacturer
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
No custom available fields found
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
INSERT INTO `k7hAg_csvi_logdetails`
(`csvi_log_id`,`line`,`description`,`result`,`status`,`area`) VALUES
(125,14,'Image added','Success','Added','Product media relations')
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
Checking category
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
COM_CSVI_DELETE_OLD_CATEGORIES_XREF
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
DELETE FROM `k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` = 14
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
14 AND `virtuemart_category_id` = 99
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('14','99','0')
|
| 2015-09-25 |
08:42:23 |
14 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('14','99','0')
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
COM_CSVI_CHECK_IF_CATEGORY_REFERENCE_ALREADY_EXISTS
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
SELECT COUNT(*) AS total FROM
`k7hAg_virtuemart_product_categories` WHERE `virtuemart_product_id` =
14 AND `virtuemart_category_id` = 119
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
COM_CSVI_CATEGORY_REFERENCE_DOES_NOT_YET_EXIST
|
| 2015-09-25 |
08:42:23 |
14 |
[DEBUG] |
COM_CSVI_ADD_NEW_CATEGORY_REFERENCES
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('14','119','0')
|
| 2015-09-25 |
08:42:23 |
14 |
[ADD] |
COM_CSVI_TABLE_VirtueMartTableProductcategoryxref_ADDED
|
| 2015-09-25 |
08:42:23 |
14 |
[QUERY] |
INSERT INTO `k7hAg_virtuemart_product_categories`
(`virtuemart_product_id`,`virtuemart_category_id`,`ordering`) VALUES
('14','119','0')
|