Resolved VirtueMart export only one record

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.

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

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.

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

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.

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

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.