1. icinfo
  2. RO CSVI
  3. Thursday, 21 April 2016
  4.  Subscribe via email
Hi,
we have the latest of the component with Virtuemart polugin.

When doing an export template and exporting data, there are a few fields that show up empty in the csv. The fields are:
product_name
category_path
manufacturer_name
product_s_desc
product_desc

I don't understand why, since those fields have data in the text-products.

here is debug info:

Warning: Spoiler Alert! [Toggle message]

2016-04-21 13:46:54 0 [DEBUG] Clean up old logs. Found 12 logs and threshold is 25 logs
2016-04-21 13:46:54 0 [QUERY] SELECT csvi_log_id FROM rossi_csvi_logs ORDER BY csvi_log_id
2016-04-21 13:46:54 0 [DEBUG] Clean up old logs. Found 12 logs and threshold is 25 logs
2016-04-21 13:46:54 0 [QUERY] SELECT csvi_log_id FROM rossi_csvi_logs ORDER BY csvi_log_id
2016-04-21 13:46:54 0 [DEBUG] CSVI Pro Version: 6.5.6
2016-04-21 13:46:54 0 [DEBUG] Joomla! version: 3.5.1
2016-04-21 13:46:54 0 [DEBUG] PHP version: 5.4.45-0+deb7u2
2016-04-21 13:46:54 0 [DEBUG] =========================
2016-04-21 13:46:54 0 [DEBUG] action: export
2016-04-21 13:46:54 0 [DEBUG] component: com_virtuemart
2016-04-21 13:46:54 0 [DEBUG] operation: product
2016-04-21 13:46:54 0 [DEBUG] localpath: /var/www/clients/client86/web668/web
2016-04-21 13:46:54 0 [DEBUG] ftphost:
2016-04-21 13:46:54 0 [DEBUG] ftpport:
2016-04-21 13:46:54 0 [DEBUG] ftproot:
2016-04-21 13:46:54 0 [DEBUG] ftpfile:
2016-04-21 13:46:54 0 [DEBUG] export_email_subject:
2016-04-21 13:46:54 0 [DEBUG] export_email_body:
2016-04-21 13:46:54 0 [DEBUG] export_filename: virtuemartexport.csv
2016-04-21 13:46:54 0 [DEBUG] export_file: csv
2016-04-21 13:46:54 0 [DEBUG] field_delimiter: ,
2016-04-21 13:46:54 0 [DEBUG] text_enclosure:
2016-04-21 13:46:54 0 [DEBUG] include_column_headers: Yes
2016-04-21 13:46:54 0 [DEBUG] signature: Yes
2016-04-21 13:46:54 0 [DEBUG] publish_state: Yes
2016-04-21 13:46:54 0 [DEBUG] recordstart:
2016-04-21 13:46:54 0 [DEBUG] recordend:
2016-04-21 13:46:54 0 [DEBUG] export_date_format: d/m/Y H:i:s
2016-04-21 13:46:54 0 [DEBUG] export_price_format_decimal: 2
2016-04-21 13:46:54 0 [DEBUG] export_price_format_decsep: .
2016-04-21 13:46:54 0 [DEBUG] export_price_format_thousep:
2016-04-21 13:46:54 0 [DEBUG] header:
2016-04-21 13:46:54 0 [DEBUG] body:
2016-04-21 13:46:54 0 [DEBUG] footer:
2016-04-21 13:46:54 0 [DEBUG] language: en-GB
2016-04-21 13:46:54 0 [DEBUG] exportsef: Yes
2016-04-21 13:46:54 0 [DEBUG] producturl_suffix:
2016-04-21 13:46:54 0 [DEBUG] vm_itemid:
2016-04-21 13:46:54 0 [DEBUG] picture_limit: Yes
2016-04-21 13:46:54 0 [DEBUG] featured: No
2016-04-21 13:46:54 0 [DEBUG] category_separator: /
2016-04-21 13:46:54 0 [DEBUG] publish_state_categories: Yes
2016-04-21 13:46:54 0 [DEBUG] incl_subcategory: Yes
2016-04-21 13:46:54 0 [DEBUG] parent_only: No
2016-04-21 13:46:54 0 [DEBUG] child_only: No
2016-04-21 13:46:54 0 [DEBUG] 1: 29
2016-04-21 13:46:54 0 [DEBUG] 2: 30
2016-04-21 13:46:54 0 [DEBUG] 3: 31
2016-04-21 13:46:54 0 [DEBUG] incl_productskufilter: Yes
2016-04-21 13:46:54 0 [DEBUG] productskufilter:
2016-04-21 13:46:54 0 [DEBUG] stocklevelstart:
2016-04-21 13:46:54 0 [DEBUG] stocklevelend:
2016-04-21 13:46:54 0 [DEBUG] shopper_group_price: none
2016-04-21 13:46:54 0 [DEBUG] priceoperator: gt
2016-04-21 13:46:54 0 [DEBUG] pricefrom:
2016-04-21 13:46:54 0 [DEBUG] priceto:
2016-04-21 13:46:54 0 [DEBUG] price_quantity_start:
2016-04-21 13:46:54 0 [DEBUG] price_quantity_end:
2016-04-21 13:46:54 0 [DEBUG] targetcurrency:
2016-04-21 13:46:54 0 [DEBUG] force_shopper_group_price: none
2016-04-21 13:46:54 0 [DEBUG] groupbyfields:
2016-04-21 13:46:54 0 [DEBUG] sortfields:
2016-04-21 13:46:54 0 [DEBUG] use_system_limits: No
2016-04-21 13:46:54 0 [DEBUG] max_execution_time:
2016-04-21 13:46:54 0 [DEBUG] memory_limit:
2016-04-21 13:46:54 0 [DEBUG] =========================
2016-04-21 13:46:54 0 [DEBUG] Export field: product_sku
2016-04-21 13:46:54 0 [DEBUG] Export field: product_name
2016-04-21 13:46:54 0 [DEBUG] Export field: category_path
2016-04-21 13:46:54 0 [DEBUG] Export field: manufacturer_name
2016-04-21 13:46:54 0 [DEBUG] Export field: product_price
2016-04-21 13:46:54 0 [DEBUG] Export field: product_discount_id
2016-04-21 13:46:54 0 [DEBUG] Export field: product_currency
2016-04-21 13:46:54 0 [DEBUG] Export field: product_tax_id
2016-04-21 13:46:54 0 [DEBUG] Export field: file_url
2016-04-21 13:46:54 0 [DEBUG] Export field: file_url_thumb
2016-04-21 13:46:54 0 [DEBUG] Export field: published
2016-04-21 13:46:54 0 [DEBUG] Export field: product_s_desc
2016-04-21 13:46:54 0 [DEBUG] Export field: product_desc
2016-04-21 13:46:54 0 [DEBUG] Export field: category_name
2016-04-21 13:46:54 0 [DEBUG] Export query
2016-04-21 13:46:54 0 [QUERY] SELECT p.virtuemart_product_id FROM rossi_virtuemart_products p LEFT JOIN rossi_virtuemart_product_categories x ON p.virtuemart_product_id = x.virtuemart_product_id LEFT JOIN rossi_virtuemart_categories c ON x.virtuemart_category_id = c.virtuemart_category_id WHERE c.published = '1'
2016-04-21 13:46:54 0 [DEBUG] Export query
2016-04-21 13:46:54 0 [QUERY] SELECT p.virtuemart_product_id FROM rossi_virtuemart_products p WHERE p.product_parent_id IN (40,41,43,45,46,47)
2016-04-21 13:46:54 0 [DEBUG] Export query
SELECT `#__virtuemart_products`.`virtuemart_product_id`,
`#__virtuemart_products`.`product_parent_id`,
`product_sku`,
`#__virtuemart_product_categories`.`virtuemart_category_id`,
`#__virtuemart_product_prices`.`product_price`,
`#__virtuemart_product_prices`.`virtuemart_shoppergroup_id`,
`#__virtuemart_currencies`.`currency_code_3`,
`product_discount_id`,
`product_tax_id`,
`#__virtuemart_products`.`published`
FROM `#__virtuemart_products`
LEFT JOIN `#__virtuemart_product_prices` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_prices`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_product_manufacturers` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_manufacturers`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_manufacturers` ON `#__virtuemart_product_manufacturers`.`virtuemart_manufacturer_id` = `#__virtuemart_manufacturers`.`virtuemart_manufacturer_id`
LEFT JOIN `#__virtuemart_product_categories` ON `#__virtuemart_products`.`virtuemart_product_id` = `#__virtuemart_product_categories`.`virtuemart_product_id`
LEFT JOIN `#__virtuemart_currencies` ON `#__virtuemart_currencies`.`virtuemart_currency_id` = `#__virtuemart_product_prices`.`product_currency`
LEFT JOIN `#__virtuemart_product_shoppergroups` ON `#__virtuemart_product_shoppergroups`.`virtuemart_product_id` = `#__virtuemart_products`.`virtuemart_product_id`
WHERE #__virtuemart_products.virtuemart_product_id IN (40,41,43,45,46,47,47) AND #__virtuemart_products.published = 1
GROUP BY #__virtuemart_products.virtuemart_product_id
2016-04-21 13:46:54 1 [DEBUG] Get cat ID168
2016-04-21 13:46:54 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 168
2016-04-21 13:46:54 1 [DEBUG] Get cat ID167
2016-04-21 13:46:54 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 167
2016-04-21 13:46:54 1 [DEBUG] Get cat ID165
2016-04-21 13:46:54 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 1 [DEBUG] Looking for product images
2016-04-21 13:46:54 1 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 40 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 1 [DEBUG] Found images: images/stories/virtuemart/product/product353.jpg|images/stories/virtuemart/product/product384.jpg|images/stories/virtuemart/product/product24.jpg
2016-04-21 13:46:54 1 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 40 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 1 [DEBUG] Looking for product images
2016-04-21 13:46:54 1 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 40 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 1 [DEBUG] Found images: ||
2016-04-21 13:46:54 1 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 40 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 1 [DEBUG] Get cat ID168
2016-04-21 13:46:54 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 168
2016-04-21 13:46:54 1 [DEBUG] Get cat ID167
2016-04-21 13:46:54 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 167
2016-04-21 13:46:54 1 [DEBUG] Get cat ID165
2016-04-21 13:46:54 1 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 2 [DEBUG] Get cat ID165
2016-04-21 13:46:54 2 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 2 [DEBUG] Looking for product images
2016-04-21 13:46:54 2 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 41 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 2 [DEBUG] Found images: images/stories/virtuemart/product/renkaan-kuva4.jpg|images/stories/virtuemart/product/product538.jpg|images/stories/virtuemart/product/product95.jpg
2016-04-21 13:46:54 2 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 41 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 2 [DEBUG] Looking for product images
2016-04-21 13:46:54 2 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 41 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 2 [DEBUG] Found images: ||
2016-04-21 13:46:54 2 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 41 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 2 [DEBUG] Get cat ID165
2016-04-21 13:46:54 2 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 3 [DEBUG] Get cat ID165
2016-04-21 13:46:54 3 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 3 [DEBUG] Looking for product images
2016-04-21 13:46:54 3 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 43 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 3 [DEBUG] Found images: images/stories/virtuemart/product/renkaan-kuva4.jpg|images/stories/virtuemart/product/product444.jpg|images/stories/virtuemart/product/product61.jpg
2016-04-21 13:46:54 3 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 43 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 3 [DEBUG] Looking for product images
2016-04-21 13:46:54 3 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 43 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 3 [DEBUG] Found images: ||
2016-04-21 13:46:54 3 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 43 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 3 [DEBUG] Get cat ID165
2016-04-21 13:46:54 3 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 4 [DEBUG] Get cat ID165
2016-04-21 13:46:54 4 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 4 [DEBUG] Looking for product images
2016-04-21 13:46:54 4 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 45 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 4 [DEBUG] Found images: images/stories/virtuemart/product/renkaan-kuva3.jpg
2016-04-21 13:46:54 4 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 45 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 4 [DEBUG] Looking for product images
2016-04-21 13:46:54 4 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 45 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 4 [DEBUG] Found images:
2016-04-21 13:46:54 4 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 45 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 4 [DEBUG] Get cat ID165
2016-04-21 13:46:54 4 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 5 [DEBUG] Get cat ID165
2016-04-21 13:46:54 5 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 5 [DEBUG] Looking for product images
2016-04-21 13:46:54 5 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 46 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 5 [DEBUG] Found images: images/stories/virtuemart/product/renkaan-kuva.jpg
2016-04-21 13:46:54 5 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 46 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 5 [DEBUG] Looking for product images
2016-04-21 13:46:54 5 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 46 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 5 [DEBUG] Found images:
2016-04-21 13:46:54 5 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 46 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 5 [DEBUG] Get cat ID165
2016-04-21 13:46:54 5 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 6 [DEBUG] Get cat ID165
2016-04-21 13:46:54 6 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165
2016-04-21 13:46:54 6 [DEBUG] Looking for product images
2016-04-21 13:46:54 6 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 47 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 6 [DEBUG] Found images:
2016-04-21 13:46:54 6 [QUERY] SELECT `file_url` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 47 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 6 [DEBUG] Looking for product images
2016-04-21 13:46:54 6 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 47 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 6 [DEBUG] Found images:
2016-04-21 13:46:54 6 [QUERY] SELECT `file_url_thumb` FROM `rossi_virtuemart_medias` AS `m` LEFT JOIN `rossi_virtuemart_product_medias` AS `p` ON `m`.`virtuemart_media_id` = `p`.`virtuemart_media_id` WHERE `virtuemart_product_id` = 47 AND `file_type` = 'product' ORDER BY p.ordering
2016-04-21 13:46:54 6 [DEBUG] Get cat ID165
2016-04-21 13:46:54 6 [QUERY] SELECT `category_parent_id`,`l`.`category_name` FROM `rossi_virtuemart_category_categories` AS `x` LEFT JOIN `rossi_virtuemart_categories` AS `c` ON `x`.`category_child_id` = `c`.`virtuemart_category_id` LEFT JOIN `rossi_virtuemart_categories_en_gb` AS `l` ON `x`.`category_child_id` = `l`.`virtuemart_category_id` WHERE `category_child_id` = 165

Here is the site under construction:
http://raskas2.demo1.ic4.eu/

What can cause this issue?

- Anne
Accepted Answer Pending Moderation
Hello Anne,

Can you follow the steps in the Missing fields in CSVI and see if that resolves the issues?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Here still the csv file.

- Anne
  1. more than a month ago
  2. RO CSVI
  3. # 2
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!