Cannot export data

Asked by Joost on 2017-06-28

I cannot export the data (all responses) from one of my surveys. It's only one survey which gives an error, I can export the data from all the other surveys without any problems.

Steps taken:
- go to quexs Administration Panel
- go to Results
- go to 'Data uitvoer' (Data export in English I think)
- choose 'Download data for this questionnaire via Limesurvey'

Now when I click on 'Export syntax or 'Export data' in in the SPSS format window I get this error:
"Error while loading data from dataoutput.php, try with Frefox"

In Firefox I get this error:
"Cannot open http://x.x.x.x/quexs/include/limesurvey/admin/admin.php?filterinc=show&quexsfilterinc=26:0&spssver=2&sid=769366&action=exportspss&dlstructure=Export+syntax&checksessionbypost=janhrndigt "

The error only appears when I choose 'all responses' or 'incomplete responses only' at 'data selection'. When I choose 'complete responses only' everything is working fine. What is wrong here? Is there a corrupt incomplete respons or something?

Question information

Language:
English Edit question
Status:
Solved
For:
queXS Edit question
Assignee:
No assignee Edit question
Solved by:
Joost
Solved:
2017-06-29
Last query:
2017-06-29
Last reply:
Joost (joostvdhorst) said : #1

PS
I found this disturbing line in my apache error log after trying to export it to SPSS:

[Thu Jun 29 12:54:08.273045 2017] [:error] [pid 12998] [client 192.168.20.88:62744] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 88 bytes) in /var/www/html/quexs/include/limesurvey/classes/adodb/adodb.inc.php on line 3447, referer: http://192.168.20.101/quexs/include/limesurvey/admin/admin.php?filterinc=show&quexsfilterinc=26%3A0&spssver=2&sid=769366&action=exportspss&checksessionbypost=cfvkvn3emk

Joost (joostvdhorst) said : #2

Fixed it by increasing the memory limit in php.ini.
From:

memory_limit = 128M

to

memory_limit = 256M