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,

So the problem is in the behaviour of component.

Not really, it is only for you where one record is exported. CSV Improved doesn't actually execute the query but Joomla does it for CSV Improved. What I am actually thinking is that the database connection gets closed and as such Joomla thinks there are no more records.

Can you send me a private message with FTP access details? I want to see what happens with the database connection as it is something peculiar to your setup. So I cannot reproduce this on my own system and nobody else has reported such an issue.

Same behaviour on different server. Only the site is the same. Private message arrive in few minutes.

Hello,

It is still the same database server or not?

No, there are two different server on two different machine

Hello,

So I now know why you get one record and that is because of the following. When you run the export a query is executed to get the data from the database. Instead of loading all data into memory the process cycles through the rows one by one. This is needed because otherwise you will run out of memory very fast. As CSVI is going through these records, other parts of the code also execute queries to get additional data. As soon as one of these additional queries is run, the other query is killed. That is why you only get one record in the export.

What I don't understand is why your setups behave that way. As I said before, nobody else has reported an issue like this. There are only some guesses I can take here. The database being used is not MySQL but MariaDB, perhaps that is the reason. Although I am quite sure you are not the only one running MariaDB. Perhaps the issue can be resolved to update to PHP 7.1. The last thing I can think about is that it may be some setting in the database setup not allowing multiple connections. That is something you can look into.

I have sent u a pm

Hello,

If you sent me a new one I did not get it. I did receive the one with the server details and I already responded with my findings, see my previous post.

Yes now is clear.
I have tried on 3 different machine (all with MariaDB) and with different versione of php (only 7.1 is out) but the problem persist. I will try on 7.1 also if i can but 7.1 is too much new for production site.
If u need we can investigate about this problem so you can include the fix on new version of your component.

Hello,

There is nothing I can fix, it works for 1000s of other users just not for you. Officially MariaDB is not supported but only MySQL. As I said before it seems to be a connection problem where the database doesn't allow multiple connections. It is reusing the connection that is already in use and so overwriting what is in progress.

Changing the PHP version is not going to resolve the problem I think because PHP doesn't handle the connections. If that would be the case, everybody would have the problem.

These 3 different machines are with the same hosting provider?

If you setup a test site locally using WAMP/XAMPP, do you still have the problem?

3 setup on 3 different machine and provider.
I have also tried on xampp wich is my daily driver for dev.
The only common thing is the use of mariaDb as sql engigne.

I'll make a test with a particular setup...i'll update you asap about

Ok it's not mariadb or php related.
I have setup a fresh joomla on my localhost with joomla 3.7.2, 5.5.5-10.1.16-MariaDB, php 5.6.24 and Virtuemart 3.0.2 (old version i know but on the production site is the one used) and the virtuemart export example works.
So the problem is the site. Any advice for debug?

Thanks

Hello,

The VirtueMart version is OK, it is still relatively new. The only thing I can think of is the configuration of MariaDB or the configuration of the Operating System. This is beyond my skill level as to where to look specific.

I mean...on the same machine with the same configuration the main site exports only 1 record, the new fresh site with only virtuemart example data exports all products.
i hope it's more clear now and thanks for all your support.

Hello,

Oh ok, I didn't realize it was the same machine. Do you have any plugins/extensions that rewrite database queries such as JoomFish/Rosetta or something like that? That is the only other thing I can think of in this case.

Nothing about this. I have noticed that only 1 or 0 records also with joomla content, users. I have disabled almost of my extesion but nothing change. It's very very strange!

Hello,

That it is strange is for sure. How about you start adding your extensions to the site that does work and see if anything falls over?

I have made another test. I have logged queries executed when i launch vm produtct export. I attach the log here. Can be helpful?
About your test i can try but i think is somenthing related to virtuemart database structure on production site, but no idea what.

Hello,

I attach the log here. Can be helpful?

I have seen the logs already when I was logged into your site. There I saw that the query being executed at that time was overwritten but how exactly that happens or because of what I don't know.

Since you established the export is successful on the same server with a clean Joomla installation, there must be a discrepancy between the installations causing that. You think it may have something to do with the VirtueMart database structure, why not put a copy of the live VirtueMart database into the test site and see what happens?

Today i have updated to latest version and i have tried to launch sample product export. The result is attached...