Resolved VirtueMart export only one record

Hello Monica,

Thank you for the update and glad to hear all is working now.

Hey guys,

In our situation this problem was directly related to something that occurred in our database.

WHM, Cpanel settings, joomla's or VMs plugins were not the cause.

I can confirm that whatever happened in our db did not occur in the csvi tables.

We created a brand new site, reinstalled all the plugins, imported just the articles, recreated menus and imported the virtuemart bare minimum amount of tables and now everything is working as expected again.

Feel free to close this one now.

Cheers,

Monica

Hello Monica,
We would suggest you to create a test site same as your live site where you can reproduce the error and on the test site you can disable or uninstall plugins and see if it gets you a way out.

Hello Roland,

The test site is on the same server and at that level they're identical. Things that differ will be each installations local .htaccess and .ini files plus some joomla plugins and templates.

I did try a few variations of PHP output_buffering and also just fired off your given CSVI template from a cron job but one line remains.

Is disabling plugins as good as uninstalling them? Think I might create an exact clone and if that jiggers the test site I'll work my way back switching things off one by one.

Good plan of attack?

Regards,

Monica

Hello Monica,

Besides the Joomla installation, are you sure the server setup on the test site is exactly the same as the live site? One thing that comes to mind is the PHP setting of output_buffering that may be different. Further the MySQL settings is something to check. If you run the export as a cron job, does it only output 1 record as well?

Thanks Tharuna,

No, not all of the extensions on our live site are on the test. ;(

I did try it a week ago or so with virtually all other plugins disabled and no go, but will give that another shot again later tonight.

2 files attached.

Please let me know if there's anything else I can send through.

Thanks for all your help... Appreciated.

Monica

Hello Monica,
Attached is a simple VirtueMart Order export template with just two fields order_number and order_total. You can restore the template using Maintenance -> CSVI Pro -> Restore template option. Try and let me know.

csvi_vm_order_export_template.xml

Would you be as kind as to send me through the most simple of virtuemart order export templates and I'll use that.

Best regards,

Monica

Hello Monica,
Now that you have done a clean install of CSVI, can you send us the debug log and your template XML of your latest export?

Hello Monica,
Since the issue is something related to your live site and export works on your test site, are the extensions installed on your live site are also installed on your test site?
Can you check if any of the installed plugins on your site is conflicting with CSVI? List of few known plugins are listed in Conflict with plugins document but it is good to disable the other installed plugins and check your export.

Hi guys,

On a test server - Same server and set up settings, CSVI Virtuemart Exports perform as expected.

On our live site no matter what, even the most simple export templates only output the first line of any virtuemart order and nothing else (so I don't believe our issue is related to template set up as the same work on our test site).

Have fully uninstalled CSVI Pro including removing database entries and reinstalled but no matter what, only one line only exports.

I'm at the stage now where I really need a solution so do you have any other ideas or suggestions ?

Regards,

Monica

Many thanks Tharuna,

Has just been emailed.

Cheers,

Mon

Hello Monica,
Thank you for sending us the requested files. We found few notices because of Field combine plugin and would like to check how you have these rules set. Can you send us your template XML file to check? You can get the template XML by going to Maintenance -> CSVI Pro -> Backup template. Download and post the XML file.

Hello Monica,

No problem at all, please email them to contact@csvimproved.com and we will take a look.

Hello Tharuna & Roland,

I want to send through 3 error logs for your perusal but they do contain more than I want to share publicly.

Can I use your contact form or can you share an email just this once?

Pretty please,

M

Many thanks Tharuna,

That was too easy!

Alas, just one line of orders even from there.

Sounds like I'd better send you the stuff Roland was after.

.... But thanks again,

M

Hello Monica,
In your export template settings on Source tab set Destination to be either Save on server or Save on FTP instead of Download and check if your export finishes.

Hello Roland,

Hey thanks for that.

Before we go that way is there a way that I can keep the file on the server so that I can access it via FTP?

The reason I ask is what's happening at the moment is, as soon as I click export, "preparing download" becomes visible and almost instantaneously my CSV opens in Excel with just one line of an orders details... Meanwhile, "preparing download" and "last server response" continues to tick away which looks like it's still at work building the full csv.

So can I store the output in a folder on the server as I might find the full export intact there? If so how and where?

This is a bit of a tricky one... I built a test site, installed your software on it and it's working fine there - Have been doing a spring clean, removing old plugins and modules and sites actually running faster and better now so a worthwhile process.

Mon

Hello Monica,

This is a rare problem otherwise everybody would be hunting us down :woohoo: At the same time it makes it much harder to solve because it is something related to the setup.

Can you post the System Information as text? You can find this by going to System -> System Information -> Download as text. All sensitive data is removed from this file so it is safe to post it.

In addition, can you check the server errors log if there are any other errors or notices other than the one you posted?

Hello Tharuna,

I did update my cpanel and WHM version around the time this prob started.

I'm getting the same error that this guy got:

https://csvimproved.com/forum?view=topic&defaultmenu=1054&catid=44&id=34112&start=0

Status error: 200
Status message: OK

Warning: mysqli_fetch_object(): Couldn't fetch mysqli_result in /home/mysite/public_html/libraries/joomla/database/iterator/mysqli.php on line 41

Warning: mysqli_free_result(): Couldn't fetch mysqli_result in /home/mysite/public_html/libraries/joomla/database/iterator/mysqli.php on line 53

I just installed a fresh copy of Joomla! 3.9.1 over top of my installation but issue persists...

Sounds like a fairly rare problem?