Resolved export only one record

Executing query report me all records i need as in image. So the problem is in the behaviour of component.

Hello,

Tharuna meant that you go to PhpMyAdmin in your hosting and then execute this query

SELECT `#__virtuemart_products`.`virtuemart_product_id`,

`#__virtuemart_products`.`product_parent_id`,

`product_sku`,

`product_in_stock`,

`product_ordered`

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`

GROUP BY #__virtuemart_products.virtuemart_product_id

You need to replace the #_ with your own prefix. What we want to see is if you get only 1 record here as well or more.

It certainly makes no sense why you only get 1 record in the export. This would mean that the database is only returning 1 record. So we are interested to see what result PhpMyAdmin returns.

I have no log as in screen

Hello Mattia,
Before we look into your site, Can you copy the export query from export debug log and run it from phpmyadmin? Can you update us on what you see?

Hello roland, i'm Mattia, the dev of website profumeriaverde.

I have upgraded to latest Joomla version and to php 7.0.1.
Also i have deleted all csvi tables and files to make a fresh installation but i can export only one record.

I have made a sandbox to make some try if u need. i can send you credential in private message for sandbox if u need.

All the best

Edit: i have restored example templates and no luck....for "Example VirtueMart Product export" only one record is exported.

Please keep us updated.

Thanks a lot, I try to update and let you know

Hello,
Your latest debug log shows no group by fields so you are good. Checking into your site we found that any export we do gets only one record so this should be something to do with your PHP version. How about you update your PHP version and check the export? You also need to update your Joomla to latest 3.7.1 version.

hello rolandD
this is the latest debug log
thanks

Hello,

Please post your latest debug log for me to check. If you are still getting one product, the grouping is still happening I think.

Hello,
Can you send me a private message of your site access details? Let me check the export on your site.

I imported the template but continues to export one record
mystery..............

Hello,
Can you restore the attached template and check your export? To restore template Select CSVI Pro on first option and Restore template on second option. Select the template XML and click continue. You then need to use this restored template on your export page.

csvi_templates_20170519.xml

many thaks

Hello,
I can still see that you have group by fields in your template as per your debug log. Can you post me your template XML file? To get template XML file go to CSVI maintenance page, Select CSVI Pro on first option and Backup template on second option. Select your template and click continue. Download the XML file and post it. I will test the export with your template here and send the modified template.

hello,
this is the situation:
I tried with your changes but still exports one product (I tried to specify the brand, zip file)
The history is this: after updating to joomla 3.7.0 I installed the new csvi pro and as you can see from image 01, I managed to export 1750 records.
The next few days doing the same operation, I appeared the error message (image 02)
Yesterday I tried to uninstall and then re install csvi: the error message no longer appears. However, csvi exports only one record.
I can not understand why ?!
thank you

Hello,
I still see the group by fields in your export template. Click on your template name on Templates page, go to fields tab, click on group fields select button and remove the fields added there, save the template. Check the export after that.

this debug log is correct?
thanks

Hello,
You have added all your export fields to group by fields in your template, how about you remove these group by fields and do the export?

Thanks, I have also attached the debug log