Support is online

NOt exporting all Virtuemart fields #8209

Open icinfo opened this topic Thursday, 21 April 2016 · 2 replies
Author

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:

[spoiler]
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
[/spoiler]
Here is the site under construction:
http://raskas2.demo1.ic4.eu/

What can cause this issue?

  • Anne
Author

Here still the csv file.

  • Anne
Support

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

Log in to reply to this topic.