Resolved mysqli.php error

Hello,

Which MySQL version is your database? There seems to be an issue with that. Best is to have MySQL 5.6.

You can find this version by going to System -> System Information and then there is the Database version.

What is in the debug log? You haven't enclosed that so I can't see the query being executed.

Hi Roland.

Db version 5.6.38

I forgot the error logs. sorry. it is attached.

Best Regards.

Hello,
The query in the debug log looks good. The error you see will happen when the query processing is still on but the connection to MySQL gets closed. Since we are not able to reproduce this error on our local server, Can you send me your site Joomla administrator access details and FTP details to check on the export? You can either send it as a private message or post a email to tharuna@csvimproved.com.

Hello Tharuna

The information you requested has been sent.

Best regards...

Hello,
Yes received your email. Will check and let you know on what i find.

Hello. Thank you Tharuna. Good works.
Kind regards.

Hello,
I had a look at your site and did few tests on export. From what i can see is that database connection is getting lost after one record. Running the same export query using PHPMyAdmin is retrieving all the records so query is not an issue. The Error reporting was set to Maximum on your site and i set it to System Default so now there is an export file generated but with only one record instead of 7000 records. This looks like something wrong with your database settings and it is a unique issue as we haven't got any user complaints like this before.

One option is to check by setting your site locally using WAMP or XAMPP and See if the export works.

Hi Tharuna

Did I get right; I can not use Csvimproved 7.3.0
Then

- I do not want to try my transfer locally (WAMP or XAMPP etc)
- I am using Csvimproved 5.21.2 with the same database (although it's not normal)
- should I downgrade to version 5.21.2

Best regards...

Hello,

- I do not want to try my transfer locally (WAMP or XAMPP etc)

I told to move your site locally so to check if export works locally. This will also confirm us if the database settings on server are not right.

- I am using Csvimproved 5.21.2 with the same database (although it's not normal)

Does the CSVI exports work in this site?

- should I downgrade to version 5.21.2

No, if there is an issue in database settings downgrade will also not help.

Hello.

Same database, same server and another domains. 5.21.2 with I export xml csv.

joomla files

libraries/cms

I upload the file from an older version (Quoting from Joomla 3.5 or 3.6 libraries/cms)

I am doing csv and xml exports with this database in this way

Kind regards.

Hello,

I upload the file from an older version (Quoting from Joomla 3.5 or 3.6 libraries/cms)

Not sure if i get you right but are you saying you moved libraries/cms folder from old Joomla version and export in CSVI 5.21.2 version works?

Yeah. do you want to try it on another domain with the same copy database

Hello,

Yeah. do you want to try it on another domain with the same copy database

In that case your current Joomla installation is a mess. I would suggest you to try fresh Joomla installation with latest CSVI 7.3.0 version and check the export.

Hello.

This account is installed from scratch (joomla 3.7.0) and last version updated (joomla 3.7.4)

I will once again setup from scratch. and I will notify

Kind regards.