Export problem with LS 2.6.7 LTS and PHP 7.2

More
4 months 6 days ago #178321 by fvanderstarre
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... B)).
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
Attachments:

Please Log in or Create an account to join the conversation.

LimeSurvey Partners
More
2 months 3 weeks ago #179781 by fvanderstarre
Still hoping for some response please....? :unsure:
Thx Frank

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #179782 by DenisChenu

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: fvanderstarre, LouisGac

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #179783 by fvanderstarre
I must have been sleeping... had that version installed as well.
Works fine! Thank you Denis.
The following user(s) said Thank You: DenisChenu

Please Log in or Create an account to join the conversation.

More
2 months 3 weeks ago #179800 by DenisChenu
Great to know :)

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in or Create an account to join the conversation.

More
2 months 2 days ago - 2 months 2 days ago #180591 by fvanderstarre
@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 ... :(
Last edit: 2 months 2 days ago by fvanderstarre. Reason: Additional info

Please Log in or Create an account to join the conversation.

More
2 months 2 days ago #180593 by DenisChenu
You're right : line is here.
github.com/SondagesPro/LimeSurvey-Sondag...ort_helper.php#L1785

Merge request is OK if you can.

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in or Create an account to join the conversation.

More
2 months 2 days ago #180601 by fvanderstarre
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!

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!