View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
18264Bug reportsResponse browsingpublic2026-10-13 18:16
Reportergabrieljenik Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status resolvedResolutionfixed 
Product Version5.3.x 
Summary18264: Importing responses from an old table with "Preserve response IDs" may fail
Description

Importing responses from an old table with the "Preserve response IDs" option fails if there are already responses with the same ID: Integrity constraint violation: 1062 Duplicate entry '1' for key 'lime_survey_591164.PRIMARY

Steps To Reproduce

Steps to reproduce

(Replace this text with detailed step-by-step instructions on how to reproduce the issue)

Expected result

(Write here what you expected to happen)

Actual result

(Write here what happened instead)

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)5.x
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMysql
Server OS (if known)
Webserver software & version (if known)
PHP Version7

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-07-20 11:33

developer   ~71049

Need same options than import VV …

c_schmitz

c_schmitz

2026-10-13 18:16

administrator   ~86436

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=40831

Related Changesets

LimeSurvey: master 1644ed07

2026-10-13 18:16

c_schmitz


Details Diff
Fixed issue 18264: Importing responses from an archived table with "Preserve response IDs" failed when a response with the same ID already existed
Dev Added the same existing-ID options as the VV import (skip/renumber/replace/replace answers), only map timings of saved responses, sync the pgsql response ID sequence
Affected Issues
18264
mod - application/controllers/admin/DataEntry.php Diff File
mod - application/views/admin/dataentry/import.php Diff File
mod - application/views/admin/dataentry/import_result.php Diff File

Issue History

Date Modified Username Field Change
2022-07-19 21:52 gabrieljenik New Issue
2022-07-19 21:52 gabrieljenik Issue generated from: 18263
2022-07-19 21:52 gabrieljenik Status new => confirmed
2022-07-19 21:53 gabrieljenik Issue cloned: 18265
2022-07-20 11:33 DenisChenu Note Added: 71049
2022-07-20 11:33 DenisChenu File Added: Capture d’écran du 2022-07-20 11-33-25.png
2022-07-20 11:33 DenisChenu Bug heat 0 => 2
2022-07-20 14:44 gabrieljenik Description Updated
2026-10-13 18:16 c_schmitz Changeset attached => LimeSurvey master 1644ed07
2026-10-13 18:16 c_schmitz Note Added: 86436
2026-10-13 18:16 c_schmitz Assigned To => c_schmitz
2026-10-13 18:16 c_schmitz Status confirmed => resolved
2026-10-13 18:16 c_schmitz Resolution open => fixed
2026-10-13 18:16 c_schmitz Bug heat 2 => 4