View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
17391Bug reportsImport/Exportpublic2021-09-06 10:59
ReporterMazi Assigned Top_teichmann  
PriorityhighSeverityblock 
Status closedResolutionfixed 
Product Version5.x 
Summary17391: Exporting encrypted results to CSV without a valid decryption key does not show error
Description

When 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 Reproduce

Create 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 Information

When 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
BrowserChrome
Database type & versionMySQL 5
Server OS (if known)Ubuntu 20
Webserver software & version (if known)Apache 2.0
PHP VersionPHP 7.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2021-06-25 10:24

updater   ~65057

Screenshot from exported CSV file

image.png (208,861 bytes)
p_teichmann

p_teichmann

2021-07-06 10:22

administrator   ~65222

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

Mazi

Mazi

2021-07-06 11:07

updater   ~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?!

p_teichmann

p_teichmann

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.

ollehar

ollehar

2021-07-21 16:19

administrator   ~65539

No issue?

p_teichmann

p_teichmann

2021-08-23 10:29

administrator   ~66100

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=32596

Related Changesets

LimeSurvey: master 45b478ba

2021-08-23 10:27:42

p_teichmann

Details Diff
Fixed issue 17391: exporting responses as vv-file does not decrypt values Affected Issues
17391
mod - application/controllers/admin/export.php Diff File

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-06-25 12:49 ollehar Sync to Zoho Project => |Yes|
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-08-13 10:05 p_teichmann Status feedback => assigned
2021-08-23 10:29 p_teichmann Changeset attached => LimeSurvey master 45b478ba
2021-08-23 10:29 p_teichmann Note Added: 66100
2021-08-23 10:29 p_teichmann Resolution open => fixed
2021-08-30 14:02 galads Status assigned => resolved
2021-09-06 10:59 c_schmitz Status resolved => closed