View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
19859Bug reportsImport/Exportpublic2024-12-04 09:142025-11-24 18:45
ReporterDenisChenu Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status in code reviewResolutionopen 
Product Version6.6.x 
Summary19859: Some broken LSA can not be imported
Description

I have some broken LSA where startlanguage are set to NULL (MSSQL DB : don't know how it's happen)
Exports LSA work but

  1. can not be imported in 5 and 6
  2. Don't have any information on reason
Steps To Reproduce

Steps to reproduce

Try to import included LSA

Expected result

LSA is imported with all response with or without warning
or
LSA is not imported : but have a reason to report an issue on LimeSurvey bug system

Actual result

Exception (debug or not)

TagsNo tags attached.
Attached Files
survey_archive_BrokenLSA.lsa (5,166 bytes)
Bug heat6
Complete LimeSurvey version number (& build) 6.8.1
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmariadb
Server OS (if known)debian
Webserver software & version (if known)nginx
PHP Version8.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2024-12-04 09:16

developer   ~81576

My opinion :

  1. No try/cast in SurveyDynamic->insertRecords (maybe with option)
  2. Fix startlanguage (and startdate) or allow it to be NULL (i report a feature request for this)
tibor.pacalat

tibor.pacalat

2025-02-03 11:47

administrator   ~81941

Tested this on local, I can reproduce the error.
c_schmitz

c_schmitz

2025-11-24 11:13

administrator   ~83914

See https://github.com/LimeSurvey/LimeSurvey/pull/4563
DenisChenu

DenisChenu

2025-11-24 18:45

developer   ~83922

The response are not imported, and the error are shown

but simple user have no way to edit response … except unzip, update XML (can be hard), zip and try again.

Why not set a default value in place of set as required ?

Capture d’écran du 2025-11-24 18-42-22.png (29,845 bytes)   
Capture d’écran du 2025-11-24 18-42-22.png (29,845 bytes)   

Issue History

Date Modified Username Field Change
2024-12-04 09:14 DenisChenu New Issue
2024-12-04 09:14 DenisChenu File Added: survey_archive_BrokenLSA.lsa
2024-12-04 09:16 DenisChenu Note Added: 81576
2024-12-04 09:16 DenisChenu Bug heat 0 => 2
2024-12-05 08:10 urdundersh Bug heat 2 => 4
2024-12-05 08:13 DenisChenu Bug heat 4 => 2
2024-12-13 10:36 DenisChenu Summary Some borken LSA can not be imported => Some broken LSA can not be imported
2025-02-03 11:47 tibor.pacalat Assigned To => tibor.pacalat
2025-02-03 11:47 tibor.pacalat Status new => confirmed
2025-02-03 11:47 tibor.pacalat Note Added: 81941
2025-02-03 11:47 tibor.pacalat Bug heat 2 => 4
2025-02-03 11:47 tibor.pacalat Assigned To tibor.pacalat =>
2025-11-24 11:13 c_schmitz Note Added: 83914
2025-11-24 11:13 c_schmitz Bug heat 4 => 6
2025-11-24 11:13 c_schmitz Assigned To => c_schmitz
2025-11-24 11:13 c_schmitz Status confirmed => assigned
2025-11-24 11:13 c_schmitz Status assigned => ready for testing
2025-11-24 11:13 c_schmitz Status ready for testing => ready for code review
2025-11-24 18:45 DenisChenu Note Added: 83922
2025-11-24 18:45 DenisChenu File Added: Capture d’écran du 2025-11-24 18-42-22.png
2025-11-24 18:45 DenisChenu Status ready for code review => in code review