1. gelatina
  2. RO CSVI
  3. Thursday, 18 May 2017
  4.  Subscribe via email
hello
I've created a template for exporting the virtuemart catalog but when I launch export, csvi exports me only one record.
Where could the problem be?
thank you so much expoprodotti.xlsx
Accepted Answer Pending Moderation
Executing query report me all records i need as in image. So the problem is in the behaviour of component.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 21
Accepted Answer Pending Moderation
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.
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. # 22
Accepted Answer Pending Moderation
Same behaviour on different server. Only the site is the same. Private message arrive in few minutes.
  1. more than a month ago
  2. RO CSVI
  3. # 23
Accepted Answer Pending Moderation
Hello,

It is still the same database server or not?
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. # 24
Accepted Answer Pending Moderation
No, there are two different server on two different machine
  1. more than a month ago
  2. RO CSVI
  3. # 25
Accepted Answer Pending Moderation
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.
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. # 26
Accepted Answer Pending Moderation
I have sent u a pm
  1. more than a month ago
  2. RO CSVI
  3. # 27
Accepted Answer Pending Moderation
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.
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. # 28
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 29
Accepted Answer Pending Moderation
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?
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. # 30
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 31
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 32
Accepted Answer Pending Moderation
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.
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. # 33
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 34
Accepted Answer Pending Moderation
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.
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. # 35
Accepted Answer Pending Moderation
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!
  1. more than a month ago
  2. RO CSVI
  3. # 36
Accepted Answer Pending Moderation
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?
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. # 37
Accepted Answer Pending Moderation
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.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 38
Accepted Answer Pending Moderation
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?
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. # 39
Accepted Answer Pending Moderation
Today i have updated to latest version and i have tried to launch sample product export. The result is attached...
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 40
  • Page :
  • 1
  • 2
  • 3


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