#
#
#Date: 2023-03-11 11:31:53 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
#Fields: date time line_nr action comment
2023-03-11 11:31:53 0 [DEBUG] Clean up old logs. Found 51 logs and threshold is 50 logs
2023-03-11 11:35:34 0 [DEBUG] Loading the supported fields for com_virtuemart, operation category and action import
2023-03-11 11:35:34 0 [QUERY] SELECT `a`.`csvi_name` FROM `qldvm_csvi_availablefields` AS `a` LEFT JOIN `qldvm_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` = 'category' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2023-03-11 11:35:34 0 [DEBUG] Load the fields to process
2023-03-11 11:35:34 0 [DEBUG] Field name: virtuemart_category_id
2023-03-11 11:35:34 0 [DEBUG] Field name: category_parent_id
2023-03-11 11:35:34 0 [DEBUG] Field name: category_name
2023-03-11 11:35:34 0 [DEBUG] Field name: category_description
2023-03-11 11:35:34 0 [DEBUG] Field name: category_path
2023-03-11 11:35:34 0 [DEBUG] Field name: customtitle
2023-03-11 11:35:34 0 [DEBUG] Field name: metakey
2023-03-11 11:35:34 0 [DEBUG] Field name: metadesc
2023-03-11 11:35:34 0 [DEBUG] Field name: metarobot
2023-03-11 11:35:34 0 [DEBUG] Field name: metaauthor
2023-03-11 11:35:34 0 [DEBUG] Field name: file_title
2023-03-11 11:35:34 0 [DEBUG] Field name: file_url
2023-03-11 11:35:34 0 [DEBUG] Field name: file_meta
2023-03-11 11:35:34 0 [DEBUG] Field name: published
2023-03-11 11:35:34 0 [DEBUG] Use field value for field virtuemart_category_id
2023-03-11 11:35:34 0 [DEBUG] Use field value for field category_parent_id
2023-03-11 11:35:34 0 [DEBUG] Use field value for field category_name
2023-03-11 11:35:34 0 [DEBUG] Use field value for field category_description
2023-03-11 11:35:34 0 [DEBUG] Use field value for field category_path
2023-03-11 11:35:34 0 [DEBUG] Use field value for field customtitle
2023-03-11 11:35:34 0 [DEBUG] Use field value for field metakey
2023-03-11 11:35:34 0 [DEBUG] Use field value for field metadesc
2023-03-11 11:35:34 0 [DEBUG] Use field value for field metarobot
2023-03-11 11:35:34 0 [DEBUG] Use field value for field metaauthor
2023-03-11 11:35:34 0 [DEBUG] Use field value for field file_title
2023-03-11 11:35:34 0 [DEBUG] Use field value for field file_url
2023-03-11 11:35:34 0 [DEBUG] Use field value for field file_meta
2023-03-11 11:35:34 0 [DEBUG] Use field value for field published
2023-03-11 11:35:43 0 [DEBUG] Loading the supported fields for com_virtuemart, operation category and action import
2023-03-11 11:35:43 0 [QUERY] SELECT `a`.`csvi_name` FROM `qldvm_csvi_availablefields` AS `a` LEFT JOIN `qldvm_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` = 'category' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2023-03-11 11:35:43 0 [DEBUG] Load the fields to process
2023-03-11 11:35:43 0 [DEBUG] Field name: virtuemart_category_id
2023-03-11 11:35:43 0 [DEBUG] Field name: category_parent_id
2023-03-11 11:35:43 0 [DEBUG] Field name: category_name
2023-03-11 11:35:43 0 [DEBUG] Field name: category_description
2023-03-11 11:35:43 0 [DEBUG] Field name: category_path
2023-03-11 11:35:43 0 [DEBUG] Field name: customtitle
2023-03-11 11:35:43 0 [DEBUG] Field name: metakey
2023-03-11 11:35:43 0 [DEBUG] Field name: metadesc
2023-03-11 11:35:43 0 [DEBUG] Field name: metarobot
2023-03-11 11:35:43 0 [DEBUG] Field name: metaauthor
2023-03-11 11:35:43 0 [DEBUG] Field name: file_title
2023-03-11 11:35:43 0 [DEBUG] Field name: file_url
2023-03-11 11:35:43 0 [DEBUG] Field name: file_meta
2023-03-11 11:35:43 0 [DEBUG] Field name: published
2023-03-11 11:35:43 0 [DEBUG] Clean up old logs. Found 50 logs and threshold is 50 logs
2023-03-11 11:35:43 0 [DEBUG] Loading the supported fields for com_virtuemart, operation category and action import
2023-03-11 11:35:43 0 [QUERY] SELECT `a`.`csvi_name` FROM `qldvm_csvi_availablefields` AS `a` LEFT JOIN `qldvm_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` = 'category' AND `a`.`action` = 'import' AND `t`.`action` = 'import'
2023-03-11 11:35:43 0 [DEBUG] Load the fields to process
2023-03-11 11:35:43 0 [DEBUG] Field name: virtuemart_category_id
2023-03-11 11:35:43 0 [DEBUG] Field name: category_parent_id
2023-03-11 11:35:43 0 [DEBUG] Field name: category_name
2023-03-11 11:35:43 0 [DEBUG] Field name: category_description
2023-03-11 11:35:43 0 [DEBUG] Field name: category_path
2023-03-11 11:35:43 0 [DEBUG] Field name: customtitle
2023-03-11 11:35:43 0 [DEBUG] Field name: metakey
2023-03-11 11:35:43 0 [DEBUG] Field name: metadesc
2023-03-11 11:35:43 0 [DEBUG] Field name: metarobot
2023-03-11 11:35:43 0 [DEBUG] Field name: metaauthor
2023-03-11 11:35:43 0 [DEBUG] Field name: file_title
2023-03-11 11:35:43 0 [DEBUG] Field name: file_url
2023-03-11 11:35:43 0 [DEBUG] Field name: file_meta
2023-03-11 11:35:43 0 [DEBUG] Field name: published
2023-03-11 11:35:43 0 [DEBUG] ==========
2023-03-11 11:35:43 0 [DEBUG] RO CSVI Version: 8.6.1
2023-03-11 11:35:43 0 [DEBUG] PHP version: 7.4.33
2023-03-11 11:35:43 0 [DEBUG] Action: import
2023-03-11 11:35:43 0 [DEBUG] Component: com_virtuemart
2023-03-11 11:35:43 0 [DEBUG] Operation: category
2023-03-11 11:35:43 0 [DEBUG] Override:
2023-03-11 11:35:43 0 [DEBUG] Source: fromupload
2023-03-11 11:35:43 0 [DEBUG] Load from your computer: /var/www/vhosts/domain.com/tmp/com_csvi/1970001764/IMP CAT.txt
2023-03-11 11:35:43 0 [DEBUG] Load from server:
2023-03-11 11:35:43 0 [DEBUG] Delete after import: No
2023-03-11 11:35:43 0 [DEBUG] URL: https://
2023-03-11 11:35:43 0 [DEBUG] URL Username:
2023-03-11 11:35:43 0 [DEBUG] Name of username field: user
2023-03-11 11:35:43 0 [DEBUG] URL Password:
2023-03-11 11:35:43 0 [DEBUG] Name of the password field: password
2023-03-11 11:35:43 0 [DEBUG] Retrieve method: get
2023-03-11 11:35:43 0 [DEBUG] Authorization Type: htaccess
2023-03-11 11:35:43 0 [DEBUG] Encode URL: Yes
2023-03-11 11:35:43 0 [DEBUG] (S)FTP Host:
2023-03-11 11:35:43 0 [DEBUG] (S)FTP Port:
2023-03-11 11:35:43 0 [DEBUG] SFTP: No
2023-03-11 11:35:43 0 [DEBUG] (S)FTP Root Folder:
2023-03-11 11:35:43 0 [DEBUG] (S)FTP Filename:
2023-03-11 11:35:43 0 [DEBUG] Connection Type:
2023-03-11 11:35:43 0 [DEBUG] Table List:
2023-03-11 11:35:43 0 [DEBUG] Username:
2023-03-11 11:35:43 0 [DEBUG] Host:
2023-03-11 11:35:43 0 [DEBUG] Port:
2023-03-11 11:35:43 0 [DEBUG] Database Name:
2023-03-11 11:35:43 0 [DEBUG] Database Table:
2023-03-11 11:35:43 0 [DEBUG] Client ID:
2023-03-11 11:35:43 0 [DEBUG] Client Secret:
2023-03-11 11:35:43 0 [DEBUG] Spreadsheet Id:
2023-03-11 11:35:43 0 [DEBUG] Sheet name:
2023-03-11 11:35:43 0 [DEBUG] From Cell/Column:
2023-03-11 11:35:43 0 [DEBUG] To Cell/Column:
2023-03-11 11:35:43 0 [DEBUG] Autodetect delimiters: No
2023-03-11 11:35:43 0 [DEBUG] Field Delimiter: ;
2023-03-11 11:35:43 0 [DEBUG] Text Enclosure: "
2023-03-11 11:35:43 0 [DEBUG] Escape Character:
2023-03-11 11:35:43 0 [DEBUG] Use file extension:
2023-03-11 11:35:43 0 [DEBUG] I'm Mac: No
2023-03-11 11:35:43 0 [DEBUG] Use file for configuration: No
2023-03-11 11:35:43 0 [DEBUG] Add extra fields: No
2023-03-11 11:35:43 0 [DEBUG] Skip first line: Yes
2023-03-11 11:35:43 0 [DEBUG] Skip lines: Yes
2023-03-11 11:35:43 0 [DEBUG] Overwrite existing data: Yes
2023-03-11 11:35:43 0 [DEBUG] Skip new items: No
2023-03-11 11:35:43 0 [DEBUG] Skip empty custom fields: No
2023-03-11 11:35:43 0 [DEBUG] Record container:
2023-03-11 11:35:43 0 [DEBUG] Record name:
2023-03-11 11:35:43 0 [DEBUG] Keep Order ID: No
2023-03-11 11:35:43 0 [DEBUG] Language: en-GB
2023-03-11 11:35:43 0 [DEBUG] Translation language: en-GB
2023-03-11 11:35:43 0 [DEBUG] Category separator: /
2023-03-11 11:35:43 0 [DEBUG] Recreate alias: Yes
2023-03-11 11:35:43 0 [DEBUG] Unpublish before import: No
2023-03-11 11:35:43 0 [DEBUG] Process images: Yes
2023-03-11 11:35:43 0 [DEBUG] Location category images:
2023-03-11 11:35:43 0 [DEBUG] Change case: none
2023-03-11 11:35:43 0 [DEBUG] Fill media fields: No
2023-03-11 11:35:43 0 [DEBUG] Delete image relations: No
2023-03-11 11:35:43 0 [DEBUG] Keep original file: No
2023-03-11 11:35:43 0 [DEBUG] Convert image type: none
2023-03-11 11:35:43 0 [DEBUG] Save images on server: Yes
2023-03-11 11:35:43 0 [DEBUG] Re-download image: Yes
2023-03-11 11:35:43 0 [DEBUG] Resize large image: No
2023-03-11 11:35:43 0 [DEBUG] Full image width:
2023-03-11 11:35:43 0 [DEBUG] Full image height:
2023-03-11 11:35:43 0 [DEBUG] Check filetype: No
2023-03-11 11:35:43 0 [DEBUG] Automatic thumbnail creation: Yes
2023-03-11 11:35:43 0 [DEBUG] Thumbnail type: none
2023-03-11 11:35:43 0 [DEBUG] Thumbnail width: 90
2023-03-11 11:35:43 0 [DEBUG] Thumbnail height: 90
2023-03-11 11:35:43 0 [DEBUG] Maximum width resize: 1024
2023-03-11 11:35:43 0 [DEBUG] Maximum height resize: 768
2023-03-11 11:35:43 0 [DEBUG] Watermark: No
2023-03-11 11:35:43 0 [DEBUG] Right margin: No
2023-03-11 11:35:43 0 [DEBUG] Bottom margin: No
2023-03-11 11:35:43 0 [DEBUG] Image:
2023-03-11 11:35:43 0 [DEBUG] URL Username:
2023-03-11 11:35:43 0 [DEBUG] URL Password:
2023-03-11 11:35:43 0 [DEBUG] Retrieve method: post
2023-03-11 11:35:43 0 [DEBUG] Authorization Type: htaccess
2023-03-11 11:35:43 0 [DEBUG] Encode URL: Yes
2023-03-11 11:35:43 0 [DEBUG] Verify SSL: Yes
2023-03-11 11:35:43 0 [DEBUG] Global Rules:
2023-03-11 11:35:43 0 [DEBUG] Lines per import: 1000
2023-03-11 11:35:43 0 [DEBUG] Time between imports: 5
2023-03-11 11:35:43 0 [DEBUG] Override system limits?: No
2023-03-11 11:35:43 0 [DEBUG] Maximum execution time:
2023-03-11 11:35:43 0 [DEBUG] Maximum amount of memory:
2023-03-11 11:35:43 0 [DEBUG] Maximum size of POST data in megabytes:
2023-03-11 11:35:43 0 [DEBUG] Maximum allowed size for uploaded files in megabytes:
2023-03-11 11:35:43 0 [DEBUG] Access token details:
2023-03-11 11:35:43 0 [DEBUG] ==========
2023-03-11 11:35:43 0 [DEBUG] Updating start date and time of import
2023-03-11 11:35:43 0 [QUERY] UPDATE `qldvm_csvi_logs` SET `start` = '2023-03-11 11:35:43' WHERE `csvi_log_id` = 162089
2023-03-11 11:35:43 1 [DEBUG] Use field value for field virtuemart_category_id
2023-03-11 11:35:43 1 [DEBUG] Use field value for field category_parent_id
2023-03-11 11:35:43 1 [DEBUG] Use field value for field category_name
2023-03-11 11:35:43 1 [DEBUG] Use field value for field category_description
2023-03-11 11:35:43 1 [DEBUG] Use field value for field category_path
2023-03-11 11:35:43 1 [DEBUG] Use field value for field customtitle
2023-03-11 11:35:43 1 [DEBUG] Use field value for field metakey
2023-03-11 11:35:43 1 [DEBUG] Use field value for field metadesc
2023-03-11 11:35:43 1 [DEBUG] Use field value for field metarobot
2023-03-11 11:35:43 1 [DEBUG] Use field value for field metaauthor
2023-03-11 11:35:43 1 [DEBUG] Use field value for field file_title
2023-03-11 11:35:43 1 [DEBUG] Use field value for field file_url
2023-03-11 11:35:43 1 [DEBUG] Use field value for field file_meta
2023-03-11 11:35:43 1 [DEBUG] Use field value for field published
2023-03-11 11:35:43 1 [DEBUG] Process line 1
2023-03-11 11:35:43 1 [DEBUG] Check if category path exists: Vari per cucinare
2023-03-11 11:35:43 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `qldvm_virtuemart_categories` AS `c` LEFT JOIN `qldvm_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `qldvm_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Vari per cucinare' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 0
2023-03-11 11:35:43 1 [DEBUG] Load a row
2023-03-11 11:35:43 1 [DEBUG] Check if category path exists: Farine e miscele 1
2023-03-11 11:35:43 1 [QUERY] SELECT `c`.`virtuemart_category_id` FROM `qldvm_virtuemart_categories` AS `c` LEFT JOIN `qldvm_virtuemart_category_categories` AS `x` ON `c`.`virtuemart_category_id` = `x`.`category_child_id` LEFT JOIN `qldvm_virtuemart_categories_en_gb` AS `l` ON `l`.`virtuemart_category_id` = `c`.`virtuemart_category_id` WHERE `l`.`category_name` = 'Farine e miscele 1' AND `x`.`category_child_id` = `c`.`virtuemart_category_id` AND `x`.`category_parent_id` = 144
2023-03-11 11:35:43 1 [DEBUG] Query for Category
2023-03-11 11:35:43 1 [DEBUG] Executed store
2023-03-11 11:35:43 1 [QUERY] INSERT INTO `qldvm_virtuemart_categories` (`category_parent_id`,`virtuemart_vendor_id`,`category_template`,`category_layout`,`category_product_layout`,`products_per_row`,`limit_list_step`,`limit_list_initial`,`ordering`,`published`,`created_on`,`created_by`,`modified_on`,`modified_by`) VALUES ('144','1','14','default','default','3','0','0','46','1','2023-03-11 11:35:43','778','2023-03-11 11:35:43','778')
2023-03-11 11:35:43 1 [DEBUG] Category publish 1
2023-03-11 11:35:43 1 [DEBUG] Check the category language
2023-03-11 11:35:43 1 [QUERY] SELECT `virtuemart_category_id` FROM `qldvm_virtuemart_categories_en_gb` WHERE `virtuemart_category_id` = 191
2023-03-11 11:35:43 1 [DEBUG] Check the category slug
2023-03-11 11:35:43 1 [QUERY] SELECT COUNT(`virtuemart_category_id`) FROM `qldvm_virtuemart_categories_en_gb` WHERE `slug` = 'farine-e-miscele-1' AND `virtuemart_category_id` != 191
2023-03-11 11:35:43 1 [DEBUG] Check the category slug
2023-03-11 11:35:43 1 [QUERY] SELECT COUNT(`virtuemart_category_id`) FROM `qldvm_virtuemart_categories_en_gb` WHERE `slug` = 'farine-e-miscele-1' AND `virtuemart_category_id` != 191
2023-03-11 11:35:43 1 [DEBUG] Add the category language entry
2023-03-11 11:35:43 1 [QUERY] INSERT INTO qldvm_virtuemart_categories_en_gb (`virtuemart_category_id`, `slug`) VALUES (191, 'farine-e-miscele-1')
2023-03-11 11:35:43 1 [DEBUG] Query for CategoryLang
2023-03-11 11:35:43 1 [DEBUG] Executed store
2023-03-11 11:35:43 1 [QUERY] UPDATE `qldvm_virtuemart_categories_en_gb` SET `category_name`='Farine e miscele 1',`slug`='farine-e-miscele-1' WHERE `virtuemart_category_id` = '191'
2023-03-11 11:35:43 1 [ADD] COM_CSVI_TABLE_VirtueMartTableCategoryXref_ADDED
2023-03-11 11:35:43 1 [QUERY] INSERT INTO `qldvm_virtuemart_category_categories` (`category_parent_id`,`category_child_id`) VALUES ('144','191')
2023-03-11 11:35:43 1 [DEBUG] Update has field for parent category
2023-03-11 11:35:43 1 [QUERY] UPDATE `qldvm_virtuemart_categories` SET `has_children` = 1 WHERE `virtuemart_category_id` = 144
2023-03-11 11:35:43 1 [DEBUG] Process remote file: https://domain.com/images/stories/virtuemart/category/nutrifreelogo.jpg
2023-03-11 11:35:43 1 [DEBUG] URL:https://domain.com/images/stories/virtuemart/category/nutrifreelogo.jpg
2023-03-11 11:35:43 1 [DEBUG] Opening socket to ssl://shopglutenfree.it at port 443
2023-03-11 11:35:44 1 [DEBUG] HTTP response:HTTP/1.1 200 OK
2023-03-11 11:35:44 1 [DEBUG] Identity string: ffd8ffe1001845786966000049492a0008000000
2023-03-11 11:35:44 1 [DEBUG] Process image file
2023-03-11 11:35:44 1 [DEBUG] Current file: /var/www/vhosts/domain.com/images/stories/virtuemart/category/nutrifreelogo.jpg
2023-03-11 11:35:44 1 [DEBUG] Remote file stored: https://domain.com/images/stories/virtuemart/category/nutrifreelogo.jpg --> /var/www/vhosts/domain.com/tmp/com_csvi/1678534544640c679014898.jpg
2023-03-11 11:35:44 1 [DEBUG] Identity string: ffd8ffe1001845786966000049492a0008000000
2023-03-11 11:35:44 1 [DEBUG] Mime type found: image/jpeg
2023-03-11 11:35:44 1 [DEBUG] Full name original: /var/www/vhosts/domain.com/tmp/com_csvi/1678534544640c679014898.jpg
2023-03-11 11:35:44 1 [DEBUG] Full name target: images/stories/virtuemart/category/nutrifreelogo.jpg
2023-03-11 11:35:44 1 [DEBUG] Store remote file on server /var/www/vhosts/domain.com/tmp/com_csvi/1678534544640c679014898.jpg --> /var/www/vhosts/domain.com/images/stories/virtuemart/category/nutrifreelogo.jpg
2023-03-11 11:35:44 1 [DEBUG] Checking if the file_url exists
2023-03-11 11:35:44 1 [QUERY] SELECT `virtuemart_media_id` FROM `qldvm_virtuemart_medias` WHERE `file_url` = 'images/stories/virtuemart/category/nutrifreelogo.jpg'
2023-03-11 11:35:44 1 [DEBUG] Query for Media
2023-03-11 11:35:44 1 [DEBUG] Executed store
2023-03-11 11:35:44 1 [QUERY] UPDATE `qldvm_virtuemart_medias` SET `virtuemart_vendor_id`='1',`file_title`='nutrifreelogo.jpg',`file_description`='',`file_meta`='FARINA NUTRIFREE SENZA GLUTINE',`file_class`='',`file_mimetype`='image/jpeg',`file_type`='category',`file_url`='images/stories/virtuemart/category/nutrifreelogo.jpg',`file_url_thumb`='',`file_is_product_image`='0',`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` = '7673'
2023-03-11 11:35:44 1 [DEBUG] Query for Categorymedia
2023-03-11 11:35:44 1 [DEBUG] Executed store
2023-03-11 11:35:44 1 [QUERY] INSERT INTO `qldvm_virtuemart_category_medias` (`virtuemart_category_id`,`virtuemart_media_id`,`ordering`) VALUES ('191','7673','1')
2023-03-11 11:35:44 1 [DEBUG] Store the category image relation
2023-03-11 11:35:44 1 [DEBUG] Query for Category
2023-03-11 11:35:44 1 [DEBUG] Executed store
2023-03-11 11:35:44 1 [QUERY] UPDATE `qldvm_virtuemart_categories` SET `category_parent_id`='144',`virtuemart_vendor_id`='1',`products_per_row`='',`hits`='0',`cat_params`='show_store_desc=\"\"|showcategory_desc=\"\"|showcategory=\"\"|categories_per_row=\"\"|showproducts=\"\"|omitLoaded=\"\"|showsearch=\"\"|productsublayout=\"\"|featured=\"\"|featured_rows=\"\"|omitLoaded_featured=\"\"|discontinued=\"\"|discontinued_rows=\"\"|omitLoaded_discontinued=\"\"|latest=\"\"|latest_rows=\"\"|omitLoaded_latest=\"\"|topten=\"\"|topten_rows=\"\"|omitLoaded_topten=\"\"|recent=\"\"|recent_rows=\"\"|omitLoaded_recent=\"\"',`metarobot`='index, follow',`metaauthor`='track',`ordering`='0',`shared`='0',`published`='1',`has_medias`='1',`created_on`='0000-00-00 00:00:00',`created_by`='0',`modified_on`='2023-03-11 11:35:43',`modified_by`='778',`locked_on`='0000-00-00 00:00:00',`locked_by`='0' WHERE `virtuemart_category_id` = '191'
2023-03-11 11:35:44 1 [DEBUG] Load a row
2023-03-11 11:35:44 1 [DEBUG] Check the category language
2023-03-11 11:35:44 1 [QUERY] SELECT `virtuemart_category_id` FROM `qldvm_virtuemart_categories_en_gb` WHERE `virtuemart_category_id` = 191
2023-03-11 11:35:44 1 [DEBUG] Load a row
2023-03-11 11:35:44 1 [DEBUG] Check the category slug
2023-03-11 11:35:44 1 [QUERY] SELECT COUNT(`virtuemart_category_id`) FROM `qldvm_virtuemart_categories_en_gb` WHERE `slug` = 'farine-e-miscele-1' AND `virtuemart_category_id` != 191
2023-03-11 11:35:44 1 [DEBUG] Check the category slug
2023-03-11 11:35:44 1 [QUERY] SELECT COUNT(`virtuemart_category_id`) FROM `qldvm_virtuemart_categories_en_gb` WHERE `slug` = 'farine-e-miscele-1' AND `virtuemart_category_id` != 191
2023-03-11 11:35:44 1 [DEBUG] Query for CategoryLang
2023-03-11 11:35:44 1 [DEBUG] Executed store
2023-03-11 11:35:44 1 [QUERY] UPDATE `qldvm_virtuemart_categories_en_gb` SET `category_name`='Farine e miscele 1',`category_description`='Farina Nutrifree 4
\r\nFarine, miscele e preparati senza glutine per celiaci e intolleranti
\r\nfarina senza lattosio, farine gluten free, farina multiuso, farina universale, mix per pane, mix per pizza, mix per pasta, mix per dolci,
',`metadesc`='Farina Nutrifree Shopglutenfree - Tanti tipi di farina senza glutine per celiaci e intolleranti, ideali a ogni impasto, per garantire ottimi risultati.',`metakey`='farina senza lattosio, farine gluten free, farina multiuso, farina universale, mix per pane, mix per pizza, mix per pasta, mix per dolci,',`customtitle`='Farina Nutrifree senza glutine per celiaci e intolleranti',`slug`='farine-e-miscele-1' WHERE `virtuemart_category_id` = '191'
2023-03-11 11:35:44 1 [DEBUG] Load a row
2023-03-11 11:35:44 1 [DEBUG] Update has field for parent category
2023-03-11 11:35:44 1 [QUERY] UPDATE `qldvm_virtuemart_categories` SET `has_children` = 1 WHERE `virtuemart_category_id` = 144