1. cursor
  2. RO CSVI
  3. Saturday, 03 February 2018
  4.  Subscribe via email
Hello,

I have the same problem. Virtuemart orders and categories export return always only one record.

PHP version 7.1.13
Joomla! version 3.8.4
VirtueMart 3.2.12
Database schema version 7.4.1

You can see attached files.

Do you have any idea to solve this problem?

Tahnks,

Vaclav
Accepted Answer Pending Moderation
Hello Vaclav,

Looking at your debug log I see some strange things. It seems to me that these templates used to be for another type of export. The fields to export show these for example:
2018-02-03 20:23:50 0 [DEBUG] Export field: dobirka
2018-02-03 20:23:50 0 [DEBUG] Export field: jmeno prijemce
2018-02-03 20:23:50 0 [DEBUG] Export field: spolecnost prijemce
2018-02-03 20:23:50 0 [DEBUG] Export field: ulice prijemce
2018-02-03 20:23:50 0 [DEBUG] Export field: mesto prijemce
2018-02-03 20:23:50 0 [DEBUG] Export field: psc prijemce
2018-02-03 20:23:50 0 [DEBUG] Export field: stat prijemce
2018-02-03 20:23:50 0 [DEBUG] Export field: telefon prijemce
2018-02-03 20:23:50 0 [DEBUG] Export field: id odesilatele
2018-02-03 20:23:50 0 [DEBUG] Export field: jmeno odesilatele
2018-02-03 20:23:50 0 [DEBUG] Export field: var symbol
2018-02-03 20:23:50 0 [DEBUG] Export field: pocet baliku
2018-02-03 20:23:50 0 [DEBUG] Export field: e-mail prijemce
2018-02-03 20:23:50 0 [DEBUG] Export field: vaha
2018-02-03 20:23:50 0 [DEBUG] Export field: prijmeni
2018-02-03 20:23:50 0 [DEBUG] Export field: jmeno
These are not VirtueMart order fields. Are these fields correct for your setup?

The second thing to check is the group by settings. This is now set to order_numer. If you leave this empty, do you get more records?

As for the categories export, CSVI is exporting from this table #__virtuemart_categories_cs_cz, is there any data in them? We have seen in other posts that the data is actually stored in the #__virtuemart_categories_en_gb tables. So you can check if that is the case for you.
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. # 1
Accepted Answer Pending Moderation
Hello Roland,

Thanks for response.

The strange names are only coloumn header in Czech :)

For easer example I prepared very simply export in English:

I want to export order numbers only. I deleted group fields, but in debug log is still groupbyfields: {"name":[]}. I don't know why.

In attachement I'm sending csv a debug log.

When I used the SQL query from the log (with my table prefix) it returns me 58 records.

Thanks.

Vaclav order-number-export.csv com_csvi.log.73.zip
Attachments (2)
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hello Vaclav,

I see nothing wrong in your export file. Check the MySQL adapter you are using by going to System -> Global Configuration -> Server -> Database Type. Is this set to MySQLi? If not, it must be set to that.
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. # 3
Accepted Answer Pending Moderation
Hi Roland,

Database Type was set to MySQLi all the time.

I'm trying to disable some plugins or modules. But no effect - still returns only one record.

Only when I disable productXport plugin - it shows this error:

Status error: 200
Status message: parsererror

Warning: mysqli_fetch_object(): Couldn't fetch mysqli_result in /www/doc/http://www.oplechovani.cz/www/libraries/joomla/database/iterator/mysqli.php on line 41

Warning: mysqli_free_result(): Couldn't fetch mysqli_result in /www/doc/http://www.oplechovani.cz/www/libraries/joomla/database/iterator/mysqli.php on line 53
{"process":false,"records":1,"downloadurl":"https:\/\/http://www.oplechovani.cz\/administrator\/index.php?option=com_csvi&task=exports.downloadfile&tmpl=component&file=L3d3dy9kb2Mvd3d3Lm9wbGVjaG92YW5pLmN6L3d3dy90bXAvY29tX2NzdmkvZXhwb3J0L29yZGVyLW51bWJlci1leHBvcnQuY3N2","url":"https:\/\/www.oplechovani.cz\/administrator\/index.php?option=com_csvi&view=logdetails&run_id=75&return=aHR0cHM6Ly93d3cub3BsZWNob3ZhbmkuY3ovYWRtaW5pc3RyYXRvci9pbmRleC5waHA\/b3B0aW9uPWNvbV9jc3ZpJnZpZXc9ZXhwb3J0cw=="}

Maybe some conflict?

Vaclav
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
Hello Vaclav,

Maybe some conflict?
Perhaps but you are on the right track. Something is interfering with the request. This looks like that while CSVI is trying to export something else is closing the database connection.

Warning: mysqli_free_result(): Couldn't fetch mysqli_result in /www/doc/http://www.oplechovani.cz/www/libraries/joomla/database/iterator/mysqli.php on line 53
This means something else has already closed the connection. That probably has happened after the first record has been exported. That would explain why you only see one record in the export file.

The difficult part now is to find out which plugin is doing this. We have a list of plugins we know cause conflicts that you can check if you have any of those. If you have none, it would be a matter of trying to find out which one.

My guess is it would be a plugin that is part of the system group.
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. # 5
Accepted Answer Pending Moderation
Same prob here.

Was all fine and has been for ages and now suddenly I only get 1 order per export no matter what.

Just tried with all plugins disabled - same deal.

Adapter remains set to MySQLi ...

Any other possibilities or pointers?

PHP version 7 (Have tried 7.1 and 7.2)
Joomla! 3.9.1
VirtueMart 3.4.2
Database schema version: 3.9.0-2018-10-21
CSVI Pro 7.9.0
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hello,
Was all fine and has been for ages and now suddenly I only get 1 order per export no matter what.

Was there any recent updates on your server?

Any other possibilities or pointers?

Can you post your debug log to check? Let us see if we can get any clue from the debug log.
Kind regards,

Tharuna

=========================
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. # 7
Accepted Answer Pending Moderation
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?
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
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?
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. # 9
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
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. # 11
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 13
Accepted Answer Pending Moderation
Hello Monica,

No problem at all, please email them to contact@csvimproved.com and we will take a look.
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. # 14
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
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. # 15
Accepted Answer Pending Moderation
Many thanks Tharuna,

Has just been emailed.

Cheers,

Mon
  1. more than a month ago
  2. RO CSVI
  3. # 16
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 17
Accepted Answer Pending Moderation
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.
Kind regards,

Tharuna

=========================
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. # 18
Accepted Answer Pending Moderation
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?
Kind regards,

Tharuna

=========================
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. # 19
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 20
  • Page :
  • 1
  • 2


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