Resolved Export error

Hello,
You have set filter by category id 101 in your export template and the query in debug log shows 3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3323,3324 these are the product ids in the category id 101 and are included in your export query. Can you tell me which product from the above virtuemart_product_id is in exported file? Can you also run the below query in PhpMyAdmin and see if you see all the product rows? To run the query, access your site PhpMyAdmin, click on your database and click on SQL tab on the right panel. Paste the below query and click on Go. How many records do you see? Make sure that you replace #__ with the your table prefix before running the query.

SELECT `#__virtuemart_products`.`virtuemart_product_id`,

`#__virtuemart_products`.`product_parent_id`,

`#__virtuemart_products`.`published`,

`product_group`,

`#__virtuemart_product_categories`.`virtuemart_category_id`,

`#__virtuemart_product_prices`.`product_price`,

`#__virtuemart_product_prices`.`virtuemart_shoppergroup_id`,

`#__virtuemart_currencies`.`currency_code_3`,

`product_in_stock`,

`product_sku`,

`#__virtuemart_products`.`product_params`

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 (3313,3314,3315,3316,3317,3318,3319,3320,3321,3322,3323,3324)

GROUP BY #__virtuemart_products.virtuemart_product_id

Product 3313 of the above virtuemart_product_id is in the exported file.
Made access PhpMyAdmin
Result attached
All products are there, but they are not in the export file.

Hello,

The issue is quite elusive because this happens only from time to time. The product export is probably one of the most used exports in CSVI, if it were an easy problem, many people would have export issues. So we need to find out, why on your system only 1 product is exported. As you said, the products are there, the query we run is good because you can see the result in PhpMyAdmin.

Can you run another type of export (user export) for example and see if only 1 user is exported in that case?

Hello,

When exporting categories too 1
When exporting users - 2...


Another oddity: "Destination - Download"
but the download does not happen, the file is saved the folder Temp
other options work correctly

Hello,

other options work correctly

Does this mean that you are seeing one or two items in export file only when you set the destination to be Download? When you set other destination options, export works with all the records?

No i mean that with others destination options true

Save on server - Saved on server
Email file - sent to the email

but the content of the file is still 1 line


when I select Download, the file is saved, but not downloaded, and also still 1 line

Hello,
File not getting downloaded could be because of your browser settings. Can you try using another browser for export and check?

For export having one record in export file, Try the two options below

1. Check if there is any error in your server error log. There is no error shown on export but we need to find why one record is being written to export file. Just wanted to check if there is any error logged in server error logs.

2. Can you also check the export with another fresh Joomla instance and only CSVI Pro installed?