Hi all,

As a test I am running LimeSurvey 2.6.7 LTS build 171212 on RHEL 7 with PHP 7.2.11, using MS-SQL with FreeTDS (going where no man has gone before... ).
When exporting survey results (SPSS, csv, ...), tokens, or survey structure a x'20' character is always inserted first in the output before the actual data.
This does not occur on RHEL 6 / PHP 5.6.38, our current production situation.
Does anyone have a clue as to why this is happening?
To make exports work at all I had to do some minor tweaking in export_helper.php (see attachment, my tweaks are marked 'FvdS'), but I don't think that's causing my problem.
Any help greatly appreciated!

Frank

Still hoping for some response please....?
Thx Frank

Did you try : github.com/SondagesPro/LimeSurvey-SondagesPro

I must have been sleeping... had that version installed as well.
Works fine! Thank you Denis.

Great to know

@Denis, I was wrong.... problem is still there. Also in 2.6.7 SondagesPro 1.6.4 running under PHP 5.6.40 / RHEL 7. The regular 2.6.7-lts works fine there....

Just found out it has to be because of the changes I made to export_helper.php. Wouldn't have thought so ...

You're right : line is here.
github.com/SondagesPro/LimeSurvey-Sondag...ort_helper.php#L1785

Merge request is OK if you can.

The x'20' character was my own mistake, I put it before the <?php by accident in export_helper.php :ohmy:
So problem is fixed!

@Denis: I don't have a gitHub account, but here are the changes I had to make:

#L1760: $bresult = Yii::app()->db->createCommand($bquery)->query()->readAll(); // FvdS ->readAll() added.

#L1785: foreach($bresult as $brow) // FvdS changed from: while ($brow = $bresult->read())

Thx!