View Issue Details

This issue affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
20864Bug reportsEncryptionpublic2026-11-18 11:36
Reportertwilllig Assigned To 
PrioritynoneSeverityblock 
Status newResolutionopen 
Product Version7.11.x 
Summary20864: Restoring or importing responses from a survey deactivated under LimeSurvey 6 shows encrypted answers as unreadable text
Description

Responses archived on LimeSurvey 6 (when a survey was deactivated) lose their encryption information after the upgrade to LimeSurvey 7. When such an archive is restored on reactivation, or imported with "Import responses from a deactivated survey table", the encrypted answers get encrypted a second time. The response list and exports then show unreadable text instead of the answers.
Two causes: 1. LimeSurvey 6.6.0 to 6.16.x saved the archive settings of the response table under the token table's name (oldtokens<sid>_<timestamp> with type response), which was fixed in 6.17.0. LS6 itself handled this on restore with a name replacement, but LS7 no longer does, and the LS7 database update doesn't correct these entries. So the settings aren't found and all columns count as unencrypted. 2. The LS7 database update renames the columns of archived response tables to the new names (Q123, Q123_S456), but the list of encrypted columns stored in the archive settings keeps the LS6 names (123456X1X123). So even correctly named archives no longer match.

Steps To Reproduce
  1. On LimeSurvey 6.16.x, create a survey with a question set to "Encrypted", activate it and submit a few responses.
  2. Deactivate the survey.
  3. Upgrade to LimeSurvey 7.
  4. Activate the survey again and restore the archived responses (or import them via Responses > Import > "Import responses from a deactivated survey table").
  5. Browse the responses or export them.

Expected: The encrypted answers are shown as entered. Actual: Ciphertext is shown for the encrypted answers of the restored responses.

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)7.11.0
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmysql
Server OS (if known)
Webserver software & version (if known)
PHP Version8.3
Git branch / Pull Request URLN/A

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2026-11-18 11:36 twilllig New Issue