Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Export problem with LS 2.6.7 LTS and PHP 7.2

  • fvanderstarre
  • fvanderstarre's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
5 years 3 months ago #178321 by fvanderstarre
Export problem with LS 2.6.7 LTS and PHP 7.2 was created 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
The topic has been locked.
  • fvanderstarre
  • fvanderstarre's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
5 years 1 month ago #179781 by fvanderstarre
Replied by fvanderstarre on topic Export problem with LS 2.6.7 LTS and PHP 7.2
Still hoping for some response please....? :unsure:
Thx Frank
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 1 month ago #179782 by DenisChenu
Replied by DenisChenu on topic Export problem with LS 2.6.7 LTS and PHP 7.2

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The following user(s) said Thank You: fvanderstarre
The topic has been locked.
  • fvanderstarre
  • fvanderstarre's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
5 years 1 month ago #179783 by fvanderstarre
Replied by fvanderstarre on topic Export problem with LS 2.6.7 LTS and PHP 7.2
I must have been sleeping... had that version installed as well.
Works fine! Thank you Denis.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 1 month ago #179800 by DenisChenu
Replied by DenisChenu on topic Export problem with LS 2.6.7 LTS and PHP 7.2
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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • fvanderstarre
  • fvanderstarre's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
5 years 1 month ago - 5 years 1 month ago #180591 by fvanderstarre
Replied by fvanderstarre on topic Export problem with LS 2.6.7 LTS and PHP 7.2
@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: 5 years 1 month ago by fvanderstarre. Reason: Additional info
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 1 month ago #180593 by DenisChenu
Replied by DenisChenu on topic Export problem with LS 2.6.7 LTS and PHP 7.2
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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • fvanderstarre
  • fvanderstarre's Avatar Topic Author
  • Offline
  • Elite Member
  • Elite Member
More
5 years 1 month ago #180601 by fvanderstarre
Replied by fvanderstarre on topic Export problem with LS 2.6.7 LTS and PHP 7.2
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!
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose