View Issue Details

This issue affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
20054Bug reportsImport/Exportpublic2026-01-09 16:19
ReporterMazi Assigned To 
PrioritynoneSeverityblock 
Status closedResolutionunable to reproduce 
Product Version6.6.x 
Summary20054: Answer labels get lost when copying a survey
Description

When copying a lengthy survey (attached) with many languages, answer labels are lost at the survey copy, see attached screenshots.

More findings:

  1. Same applies when using LSS export/import
  2. The LSS export file of the original survey is a little larger than the export generated from the copy so my guess is export works fine but the issues shows up during import. Original survey is #788158, export created from copy is survey #912813.
  3. This mostly affects options with code A2.
  4. While the logic file shows answer options as not existing, you will see an empty label when editing the question, see screenshot.
Steps To Reproduce

Steps to reproduce

Import the attached survey. Check questions P05, P06, P08.

Expected result

  1. See empty answer labels at the logic file instead of no A2 answers at all.
  2. Import all answer labels from the LSS file correctly.

Actual result

  1. These answer options appear to be completely missing at the logic file. But you see thme when editing the question.
  2. Some answer labels are missing for unknown reasons.
TagsNo tags attached.
Attached Files
edit_p06_orig.jpg (130,447 bytes)
edit_p06_at_copy.jpg (129,405 bytes)
survey_size.jpg (26,612 bytes)   
survey_size.jpg (26,612 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)6.12.4
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL 5
Server OS (if known)
Webserver software & version (if known)
PHP Version8.3

Relationships

related to 20397 new LSS export import leads to missing answer labels at multilingual surveys while LSG export/import works fine 

Users monitoring this issue

There are no users monitoring this issue.

Activities

Mazi

Mazi

2025-04-09 11:45

updater   ~82399

I forgot to mentioned that this survey was created with Limesurvey 3.x. Then the customer updated to version 6.x. They reported that at 3.x they could copy the survey just fine. Only at 6.x the missing label issues shows up.
@DenisChenu, could this be related to the underlying DB adjustments for multilingual surveys?

DenisChenu

DenisChenu

2025-04-10 10:33

developer   ~82408

Didn't know

Mazi

Mazi

2025-04-10 10:38

updater   ~82410

@tibor.pacalat, can you also reproduce this one? Looks like an underlying major issue to me :-(

gabrieljenik

gabrieljenik

2025-05-01 15:35

manager   ~82550

@Mazi do you have the original LS3 lss?

The "original" LSS is already broken. The options you mark in the image are not present in the attached LSS of 788158.

Can you confirm the orig_correct.jpg is from LS6?
I mean, can you confirm the options are in place before exporting from LS6?

Also, perhaps the problem is in the XML export and not the import.

Mazi

Mazi

2025-05-02 11:27

updater   ~82558

@gabrieljenik
RE "do you have the original LS3 lss?" -> No
RE "Can you confirm the orig_correct.jpg is from LS6?" -> Yes, the old 3.x system doesn't exist any more. It was updated to 6.x and the screenshot was taken from there.
RE "can you confirm the options are in place before exporting from LS6?" -> Yes, at least that is what the logic file tells me.
RE "perhaps the problem is in the XML export and not the import." -> Possible!

gabrieljenik

gabrieljenik

2025-05-07 15:49

manager   ~82603

@mazi

Seems like an export issue.
Can I please ask you to run this? I want to see how the data is store before it gets exported.

SELECT lime_answer_l10ns.* FROM lime_answer_l10ns JOIN lime_answers ON lime_answers.aid=lime_answer_l10ns.aid JOIN lime_questions ON lime_answers.qid=lime_questions.qid WHERE lime_questions.sid=788158 ORDER BY lime_answers.sortorder;

Another possible test, apart from the previous comment, is to export the LSQ of questions P05 and P06. Can you?

Mazi

Mazi

2025-05-07 16:18

updater   ~82604

@gabrieljenik, unfortunately, I do not have access to the DB at the customer system. But here comes the LSQ file of the requested questions...

Mazi

Mazi

2025-05-08 11:07

updater   ~82605

@gabrieljenik: I contacted the customer IT and asked for running the query. Please find the results atached.

gabrieljenik

gabrieljenik

2025-05-09 19:12

manager   ~82636

I am sorry @Mazi. In order to be able to know more, I would need direct access to the DB.
So far, wasn't able to reproduce the issue. Not sure how to move forward.

@tibor.pacalat

Mazi

Mazi

2025-05-10 16:37

updater   ~82642

@gabrieljenik, that may be a problem. I can ask but I have my doubts that the customer wants to provide this.
Would a backup of the DB before the update (LS3 -> LS6) help?

tibor.pacalat

tibor.pacalat

2025-05-12 12:15

administrator   ~82649

@Mazi I am sorry, I thought I responded to this earlier, but I guess I didn't. I also couldn't reproduce this, but I thought Gabriel knew where the issue could possibly occur.

Mazi

Mazi

2025-05-14 12:13

updater   ~82670

@gabrieljenik, we are now facing the exact same issue with another customer. They also updated from 3.x to 6.x and had a larger master survey created at the old version. When copying that survey, answer labels get lost or mixed up, see screenshot.
Please find attached the original master survey #116434 and a copy created (#111111) as LSS files. Though they should be exactly the same, there is a different in size, the copy file size is slightly smaller.
I am also attaching screenshots showing at which parts the copy differs.

file_size.png (5,543 bytes)   
file_size.png (5,543 bytes)   
issues_with_copy.png (234,902 bytes)
Mazi

Mazi

2025-05-14 22:26

updater   ~82671

@gabrieljenik, some further feedback to track this down. The customer did more testing:
"I have also explored further with the new limesurvey instance installed locally on my server. My steps:
I have saved the lss file for 111111 survey and imported it to my limesurvey v6.13.3. the new survey had missing labesls as expected. I have corrected them and then copied the survey again to a second survey. The second suvey appeared ok with modifications.
The above steps do not work on live instance so I think it is s software or version issue.
This is probably why limesurvey dev team cannot replicate the issue."

-> The systems the customers are exporting from are running 6.5.2 and 6.10.2. My guess is that this is not an issue with IMporting the data but with EXporting the data from the older versions.
Could this be the case? Have there been any recent adjustments to the export function?

tibor.pacalat

tibor.pacalat

2025-05-15 12:22

administrator   ~82675

@Mazi I will try to reproduce this a bit more, but if I can not, I will close this ticket since it is not reproducible.

Advice for the client - When they export the data from 3.x they should try to import it back and see if it is missing there. In that case, since we don't support this version any more, there is also nothing to be done on our side.

Mazi

Mazi

2025-05-15 12:25

updater   ~82676

@tibor.pacalat: Please try importing the survey #116434 into an older LS 6.5 version and then export from there. That may show the issue when the re-importing the exported survey according to my conclusion.

Mazi

Mazi

2025-06-13 11:31

updater   ~82880

@tibor.pacalat, were you able to reproduce this?

tibor.pacalat

tibor.pacalat

2025-06-13 17:19

administrator   ~82885

Hi Mazi, I have looked into this some more and I think the original lss file could be corrupted.
After analysis of the original file
Question P06 is missing option A2 after I imported limesurvey_survey_788158.lss. At least this is your claim. I checked the original file (not imported) and found out that there was no data for this option.
From screenshot you can see what question I am looking at.
The other two screenshots are with options that are in lss file.
The second option does not exist in it. If you want to can check it yourself ( has aid 95660).

Also tested with 6.5.0 and also other survey 116434. Could not see that something goes missing after exporting and reimporting.

Mazi

Mazi

2025-06-13 22:44

updater   ~82887

@tibor.pacalat, thanks for testing. This really is a mystery. There surely is an issue because two users have reported the same problems after updating from 3.x to 6.x. But it seems very difficult to reproduce.
What do you suggest? Should they adjust their copy of the core survey and then try to create further copies based on the fixed version?

tibor.pacalat

tibor.pacalat

2025-06-16 17:23

administrator   ~82888

IF there is an issue at all, and not a corrupted data problem - there shouldn't be any issues with copies after the survey in current version is "corrected" (meaning missing options are added).

Mazi

Mazi

2025-06-28 16:27

updater   ~83010

We did some further in-depth testing with different systems. It turns out that the issue actually seems to be an export problem at outdated LimeSurvey versions. If you import a broken survey into the latest version, add the missing labels and then create a copy, everything's working fine. But if you're exporting the survey at an outdated LimeSurvey version and importing it at the latest version, then the export already seems to be missing some of the labels.
At newer versions the export seems to be working fine.

tibor.pacalat

tibor.pacalat

2025-07-04 11:45

administrator   ~83022

Last edited: 2025-07-04 11:45

Ok, thank you for confirming.

Issue History

Date Modified Username Field Change
2025-04-09 11:43 Mazi New Issue
2025-04-09 11:43 Mazi File Added: limesurvey_survey_LSS_files.zip
2025-04-09 11:43 Mazi File Added: orig_correct.jpg
2025-04-09 11:43 Mazi File Added: edit_p06_orig.jpg
2025-04-09 11:43 Mazi File Added: edit_p06_at_copy.jpg
2025-04-09 11:43 Mazi File Added: survey_size.jpg
2025-04-09 11:43 Mazi File Added: copy_missing.jpg
2025-04-09 11:45 Mazi Note Added: 82399
2025-04-09 11:45 Mazi Bug heat 6 => 8
2025-04-10 10:33 DenisChenu Note Added: 82408
2025-04-10 10:33 DenisChenu Bug heat 8 => 10
2025-04-10 10:38 Mazi Note Added: 82410
2025-04-24 21:52 tibor.pacalat Assigned To => gabrieljenik
2025-04-24 21:52 tibor.pacalat Status new => assigned
2025-05-01 15:35 gabrieljenik Note Added: 82550
2025-05-01 15:35 gabrieljenik Bug heat 10 => 12
2025-05-02 11:27 Mazi Note Added: 82558
2025-05-07 15:49 gabrieljenik Note Added: 82603
2025-05-07 16:18 Mazi Note Added: 82604
2025-05-07 16:18 Mazi File Added: limesurvey_question_56336-P05.lsq
2025-05-07 16:18 Mazi File Added: limesurvey_question_56337-P06.lsq
2025-05-08 11:07 Mazi Note Added: 82605
2025-05-08 11:07 Mazi File Added: survey_select.txt
2025-05-09 19:12 gabrieljenik Note Added: 82636
2025-05-09 19:16 gabrieljenik Status assigned => feedback
2025-05-10 16:37 Mazi Note Added: 82642
2025-05-10 16:37 Mazi Status feedback => assigned
2025-05-12 12:15 tibor.pacalat Note Added: 82649
2025-05-12 12:15 tibor.pacalat Bug heat 12 => 14
2025-05-14 12:13 Mazi Note Added: 82670
2025-05-14 12:13 Mazi File Added: limesurvey_survey_111111.lss
2025-05-14 12:13 Mazi File Added: limesurvey_survey_116434.lss
2025-05-14 12:13 Mazi File Added: file_size.png
2025-05-14 12:13 Mazi File Added: issues_with_copy.png
2025-05-14 22:26 Mazi Note Added: 82671
2025-05-15 12:22 tibor.pacalat Note Added: 82675
2025-05-15 12:25 Mazi Note Added: 82676
2025-06-13 11:31 Mazi Note Added: 82880
2025-06-13 17:19 tibor.pacalat Note Added: 82885
2025-06-13 17:19 tibor.pacalat File Added: Screenshot 2025-06-13 at 17.12.35.png
2025-06-13 17:19 tibor.pacalat File Added: Screenshot 2025-06-13 at 17.10.11.png
2025-06-13 17:19 tibor.pacalat File Added: Screenshot 2025-06-13 at 17.06.46.png
2025-06-13 22:44 Mazi Note Added: 82887
2025-06-16 17:23 tibor.pacalat Note Added: 82888
2025-06-16 17:24 tibor.pacalat Status assigned => closed
2025-06-16 17:24 tibor.pacalat Resolution open => unable to reproduce
2025-06-28 16:27 Mazi Note Added: 83010
2025-07-04 11:45 tibor.pacalat Note Added: 83022
2025-07-04 11:45 tibor.pacalat Note Edited: 83022
2026-01-09 15:20 Mazi Relationship added related to 20397
2026-01-09 16:17 c_schmitz File Deleted: limesurvey_survey_LSS_files.zip
2026-01-09 16:17 c_schmitz File Deleted: orig_correct.jpg
2026-01-09 16:17 c_schmitz File Deleted: copy_missing.jpg
2026-01-09 16:18 c_schmitz File Deleted: limesurvey_question_56336-P05.lsq
2026-01-09 16:18 c_schmitz File Deleted: limesurvey_question_56337-P06.lsq
2026-01-09 16:18 c_schmitz File Deleted: limesurvey_survey_111111.lss
2026-01-09 16:18 c_schmitz File Deleted: limesurvey_survey_116434.lss
2026-01-09 16:18 c_schmitz File Deleted: survey_select.txt
2026-01-09 16:19 c_schmitz Assigned To gabrieljenik =>
2026-01-09 16:19 c_schmitz View Status private => public
2026-01-09 16:19 c_schmitz Bug heat 14 => 8