View Issue Details

This bug affects 1 person(s).
IDProjectCategoryView StatusLast Update
17391Bug reportsImport/Exportpublic2021-07-21 16:19
ReporterMazi Assigned Top_teichmann  
Status feedbackResolutionopen 
Product Version5.x 
Summary17391: Exporting encrypted results to CSV without a valid decryption key does not show error
DescriptionWhen exporting encrypted results to CSV without a valid decryption key the system directly creates the CSV file and makes it available for download. The user will assume that everything worked fine BUT there actually is a 500 server error. Problem is that this error message is written into the SV file and not shown to the user, see screenshot.
Weird thing is that in my case there are 215 responses and the error only shows up after response 28. All Exported responses show up as "N/A" or empty though there actually are valid responses.
Steps To ReproduceCreate a survey with encypted responses at LS 5.
Activate the survey and add a test data set.
Export the survey and import to another LS 5 system.
At the other system export the results as CSV file
-> Export seems to be running fine but due to the missing decryption key, there actually is a 500 server error.
Additional InformationWhen exporting to Excel the 500 Internal Server Error ("Wrong key for decryption..." is directly shown on screen.
TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)Version 5.0.4+210614
I will donate to the project if issue is resolvedNo
Database & DB-VersionMySQL 5
Server OS (if known)Ubuntu 20
Webserver software & version (if known)Apache 2.0
PHP VersionPHP 7.4




2021-06-25 10:24

partner   ~65057

Screenshot from exported CSV file
image.png (208,861 bytes)


2021-07-06 10:22

administrator   ~65222

Could not reproduce the issue, is this still a problem?


2021-07-06 11:07

partner   ~65227

@p_teichmann, when following the steps to reproduce and copying the survey, this has to raise an error when exporting at the second system because the keys would be different, wouldn't it?!


2021-07-06 12:55

administrator   ~65232

no, the data will be exported unencrypted. So when importing and then exporting from the new system it will use the keys provided by it.


2021-07-21 16:19

administrator   ~65539

No issue?

Issue History

Date Modified Username Field Change
2021-06-25 10:23 Mazi New Issue
2021-06-25 10:24 Mazi Note Added: 65057
2021-06-25 10:24 Mazi File Added: image.png
2021-06-25 12:49 ollehar Assigned To => p_teichmann
2021-06-25 12:49 ollehar Status new => assigned
2021-06-25 12:49 ollehar Priority none => high
2021-07-06 10:22 p_teichmann Note Added: 65222
2021-07-06 10:22 p_teichmann Status assigned => feedback
2021-07-06 11:07 Mazi Note Added: 65227
2021-07-06 11:07 Mazi Status feedback => assigned
2021-07-06 12:55 p_teichmann Note Added: 65232
2021-07-21 16:19 ollehar Status assigned => feedback
2021-07-21 16:19 ollehar Note Added: 65539
2021-07-21 16:19 ollehar Bug heat 4 => 6