- Posts: 176
- Thank you received: 36
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
- Topic Author
- Offline
- Elite Member
Less
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... ).
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
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
Attachments:
The topic has been locked.
- fvanderstarre
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 176
- Thank you received: 36
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....?
Thx Frank
Thx Frank
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
5 years 1 month 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 , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Export problem with LS 2.6.7 LTS and PHP 7.2
Did you try :
github.com/SondagesPro/LimeSurvey-SondagesPro
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
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 176
- Thank you received: 36
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.
Works fine! Thank you Denis.
The following user(s) said Thank You: DenisChenu
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
5 years 1 month ago #179800
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 , plugin development .
I don't answer to private message.
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
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 176
- Thank you received: 36
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 ...
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
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
5 years 1 month ago #180593
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 , plugin development .
I don't answer to private message.
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.
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
- Topic Author
- Offline
- Elite Member
Less
More
- Posts: 176
- Thank you received: 36
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!
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.