View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
19749Bug reportsImport/Exportpublic2026-09-14 08:46
ReporterDenisChenu Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version6.6.x 
Summary19749: Unable to import LSA with invalid value in Response
Description

Unsure on the invalid response and why it broke, but when you import it broke with a white page with debug=0 and a Exception with debug=2

Steps To Reproduce

Steps to reproduce

Try to import LSA included (done with 3.X on mSSQL i think, came from https://bugs.limesurvey.org/view.php?id=18550)

Expected result

Survey is imported with response

Actual result

White page, no response imported

TagsNo tags attached.
Attached Files
Bug heat4
Complete LimeSurvey version number (& build)6.6.2
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionnot relevant
Server OS (if known)not relevant
Webserver software & version (if known)not relevant
PHP Versionnot relevant
Git branch / Pull Request URLN/A

Relationships

related to 20689 closedDenisChenu Unable to import this survey 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2024-09-16 12:19

developer   ~81030

Exception.html.zip (5,257 bytes)
DenisChenu

DenisChenu

2024-09-16 12:19

developer   ~81031

Exception

Error: Failed to insert data in response table<br />

/media/shnoulle/data/webdev/master/application/helpers/admin/import_helper.php(2626)

2614                             } else {
2615                                 if (in_array($sFieldname, $DestinationFields)) {
2616                                     $aInsertData[$sFieldname] = '';
2617                                 }
2618                             }
2619                         }
2620                         try {
2621                             $iNewID = SurveyDynamic::model($iSurveyID)->insertRecords($aInsertData);
2622                             if (!$iNewID) {
2623                                 throw new Exception("Error, no entry id was returned.", 1);
2624                             }
2625                         } catch (Exception $e) {
2626                             throw new Exception(gT("Error") . ": Failed to insert data in response table<br />");
2627                         }
2628                         $results['responses']++;
2629                     }
2630                 }
2631             }
2632         }
2633         $oXMLReader->close();
c_schmitz

c_schmitz

2026-09-11 22:23

administrator   ~85682

Hello DenisChenu,
I checked this with the latest version and could not reproduce, so this is most likely fixed for good.
Therefore, I am closing this issue. If you still can reproduce the issue using the latest version, please feel free to re-open the issue.
Thank you!

c_schmitz

DenisChenu

DenisChenu

2026-09-14 08:35

developer   ~85715

Have another issu with debug=2 currently. I create a new report

DenisChenu

DenisChenu

2026-09-14 08:46

developer   ~85718

@c_schmitz it break too but before with latest version ...

Issue History

Date Modified Username Field Change
2024-09-16 12:19 DenisChenu New Issue
2024-09-16 12:19 DenisChenu File Added: survey_archive_MSSQL_compare.lsa
2024-09-16 12:19 DenisChenu Note Added: 81030
2024-09-16 12:19 DenisChenu File Added: Exception.html.zip
2024-09-16 12:19 DenisChenu Bug heat 0 => 2
2024-09-16 12:19 DenisChenu Note Added: 81031
2026-09-11 22:23 c_schmitz Assigned To => c_schmitz
2026-09-11 22:23 c_schmitz Status new => closed
2026-09-11 22:23 c_schmitz Resolution open => fixed
2026-09-11 22:23 c_schmitz Note Added: 85682
2026-09-11 22:23 c_schmitz Bug heat 2 => 4
2026-09-14 08:35 DenisChenu Note Added: 85715
2026-09-14 08:46 DenisChenu Relationship added related to 20689
2026-09-14 08:46 DenisChenu Note Added: 85718