View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
17118Bug reportsImport/Exportpublic2023-06-16 20:04
Reporterdsiegfried Assigned Togabrieljenik  
PrioritynoneSeverityminor 
Status closedResolutionunable to reproduce 
Product Version4.4.7 
Summary17118: SPSS Export failes
Description

The export of the response to SPSS fails and an "ERR_INVALID_RESPONSE" browser message is displayed. The problem is that the code apparently generates warnings in the background that destroy the export.

The reason is that a "constant" is called in /var/www/limesurvey/application/helpers/export_helper.php which does not exist. Probably the variable $ field is meant.

echo quoteSPSS (date ('d-m-Y H: i: s', mktime ($ hour, $ minute, $ second, $ month, $ day, $ year)), $ q, $ field);
instead of
echo quoteSPSS (date ('d-m-Y H: i: s', mktime ($ hour, $ minute, $ second, $ month, $ day, $ year)), $ q, field);

Steps To Reproduce

Try spss-Export

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)4.4.10
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMariDB
Server OS (if known)
Webserver software & version (if known)
PHP Version7.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

gabrieljenik

gabrieljenik

2022-06-06 14:48

manager   ~70232

Hello dsiegfried,
This ticket has been open for quite some time.
Do you have any new info / feedback?
Can you please check if this issue still exists in the latest version of LimeSurvey and let us know?
Thank you!

cvvcvergara

cvvcvergara

2023-06-15 22:54

reporter   ~75651

I have the same (or similar) problem:
I get the following when trying to export participants:

This site can’t be reached
The webpage at https://limesurvey.xxxx.org/index.php?r=admin/tokens/sa/exportdialog/surveyid/244477
might be temporarily down or it may have moved permanently to a new web address.
ERR_INVALID_RESPONSE

Visually participants can be seen using the "Display participants" button
This is using Limesurvey 5.6

gabrieljenik

gabrieljenik

2023-06-16 14:32

manager   ~75674

Will try to reproduce.

The reason of the error commented by the reporte should be fixed by now.
https://github.com/LimeSurvey/LimeSurvey/blob/5.x/application/helpers/export_helper.php#L175

Still @cvvcvergara can you please set debug to 2 and try again to see if you get more details of the error?

gabrieljenik

gabrieljenik

2023-06-16 18:10

manager   ~75683

We have tried reproducing the issue not with much luck.

Can you provide more details to reproduce?
Maybe add a sample survey and responses (LSA)?

What's the minor version you have installed? 5.6.xxx?

cvvcvergara

cvvcvergara

2023-06-16 19:03

reporter   ~75684

Version: Version 5.6.14+230403
Test survey, go to survey participants:
Display participants work well.
Export, Shows the form, where "Download csv" button, which fails with that message.

About setting debug to 2, I will figure it out, I am not the admin (yet)

image.png (46,547 bytes)   
image.png (46,547 bytes)   
image-2.png (38,493 bytes)   
image-2.png (38,493 bytes)   
gabrieljenik

gabrieljenik

2023-06-16 19:23

manager   ~75685

But that is not SPSS export... is it?

cvvcvergara

cvvcvergara

2023-06-16 19:34

reporter   ~75686

Don't know, its csv.
maybe I am in the wrong issue.

gabrieljenik

gabrieljenik

2023-06-16 19:58

manager   ~75687

I can't reproduce the issue either.
Please, can you open a new ticket and attach a sample LSA faiing?
Also, please, let's try to set the debug to 2. That will give more information.

Thanks

gabrieljenik

gabrieljenik

2023-06-16 20:04

manager   ~75688

As per the comments, will be closing the ticket.
Please add any comments in case it should be reopened.
Thanks

Issue History

Date Modified Username Field Change
2021-02-22 14:19 dsiegfried New Issue
2022-06-06 14:48 gabrieljenik Assigned To => gabrieljenik
2022-06-06 14:48 gabrieljenik Status new => feedback
2022-06-06 14:48 gabrieljenik Note Added: 70232
2022-06-06 14:48 gabrieljenik Bug heat 0 => 2
2023-06-15 22:54 cvvcvergara Note Added: 75651
2023-06-15 22:54 cvvcvergara Bug heat 2 => 4
2023-06-16 14:32 gabrieljenik Note Added: 75674
2023-06-16 18:10 gabrieljenik Note Added: 75683
2023-06-16 19:03 cvvcvergara Note Added: 75684
2023-06-16 19:03 cvvcvergara File Added: Screenshot from 2023-06-16 10-53-38.png
2023-06-16 19:03 cvvcvergara File Added: image.png
2023-06-16 19:03 cvvcvergara File Added: image-2.png
2023-06-16 19:23 gabrieljenik Note Added: 75685
2023-06-16 19:34 cvvcvergara Note Added: 75686
2023-06-16 19:58 gabrieljenik Note Added: 75687
2023-06-16 20:04 gabrieljenik Status feedback => closed
2023-06-16 20:04 gabrieljenik Resolution open => unable to reproduce
2023-06-16 20:04 gabrieljenik Note Added: 75688