View Issue Details

This bug affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
20185Bug reportsSurvey editingpublic2025-07-22 13:55
ReporterTonisOrmisson Assigned To 
PrioritynoneSeverityminor 
Status newResolutionopen 
Product Version6.6.x 
Summary20185: Answer Options Not Deleted When Changing Question Type to Multiple Choice
Description

When changing a question type from single-choice questions (like L - List Radio) to M (Multiple Choice), LimeSurvey fails to clean up the old answer options from the database,
causing orphaned records and data inconsistency.

Steps To Reproduce
  1. Create a new survey
  2. Add a question with type L (List Radio)
  3. Add several answer options (e.g., "Option A", "Option B", "Option C")
  4. Save the question
  5. Change the question type to M (Multiple Choice)
  6. Save the question
  7. Check database:
    • SELECT * FROM lime_answers WHERE qid = [question_id]
    • SELECT al.* FROM lime_answer_l10ns al JOIN lime_answers a ON al.aid = a.aid WHERE a.qid = [question_id]
TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)6.13.0
I will donate to the project if issue is resolvedNo
Browser
Database type & versionn/a
Server OS (if known)
Webserver software & version (if known)
PHP Versionn/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
2025-07-22 10:42 TonisOrmisson New Issue
2025-07-22 13:55 TonisOrmisson Product Version => 6.6.x