View Issue Details

IDProjectCategoryView StatusLast Update
13857Bug reports[All Projects] Survey takingpublic2019-05-23 09:55
ReporterTinumm Assigned Toc_schmitz  
Status feedbackResolutionopen 
Product Version3.13.x 
Target VersionFixed in Version 
Summary13857: Responses cannot be saved

When taking a survey the answer of the participant cannot be saved.

Steps To Reproduce
  1. Create a new survey with an survey administrator
  2. create question group
  3. create some random question (type doesn't matter) but let's take 'Long free text'
  4. "Activate this survey"
  5. "Open-access mode" / "Closed access mode" doesn't matter
  6. Initialise participant table
  7. Create/Add participant and send invitation
  8. open sent EMail (invitation) and start taking the survey
    Did not save
    An unexpected error has occurred and your responses cannot be saved.
    Your responses have not been lost and have been emailed to the survey administrator and will be entered into our database at a later point.

Indeed the administator will receive following mail:
Beim Speichern Ihrer Fragebogen-Zugangsschl├╝ssel ist ein Fehler aufgetreten. Testo - 114214
token: 123321
114214X7X11: N/A
114214X7X11: N/A

Application.log says:
2018/07/04 16:01:35 [error] [system.db.CDbCommand] CDbCommand::execute() fehlgeschlagen: SQLSTATE[42000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Explicit value must be specified for identity column in table 'lime_survey_665889_timings' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.. Der SQL-Ausdruck war: INSERT INTO [dbo].[lime_survey_665889_timings] ([interviewtime]) VALUES (:yp0).

Additional Information

+Microsoft ODBC Driver 13 for SQL Server (13.1.4414.46)
+Microsoft ODBC Driver 17 for SQL Server (
+Microsoft Visual C++ 2008 Redistributable x64
+Microsoft Visual C++ 2008 Redistributable x86
+Microsoft Visual C++ 2013 Redistributable x64
+Microsoft Visual C++ 2017 Redistributable x64
+Microsoft Visual C++ 2017 Redistributable x86
+PHP extension "php_pdo_sqlsrv_72_nts_x86.dll" & "php_sqlsrv_72_nts_x86.dll"

TagsNo tags attached.
Complete LimeSurvey version number (& build)3.12.3+180627 & limesurvey3.13.1+180629
I will donate to the project if issue is resolvedNo
Browser Mozilla Firefox 59.0.2 / Internet Explorer 11.1480
Database & DB-VersionMSSSQL 14.0.3022.28 (2017)
Server OS (if known)Windows Server 2016 x64 Standard
Webserver software & version (if known)IIS 10
PHP VersionPHP 7.2.5 x64




2018-07-09 15:20


application.log (3,353 bytes)
Response_error.jpg (48,914 bytes)
Response_error.jpg (48,914 bytes)


2019-05-23 09:55

administrator   ~52060

I cannot reproduce this.
Can you still reproduce this using the latest version?
If you can you please attach the sample survey as survey archive (*.lsa) ?
Thank you!

Issue History

Date Modified Username Field Change
2018-07-09 15:20 Tinumm New Issue
2018-07-09 15:20 Tinumm File Added: application.log
2018-07-09 15:20 Tinumm File Added: Response_error.jpg
2018-07-09 16:13 markusfluer Assigned To => c_schmitz
2018-07-09 16:13 markusfluer Status new => assigned
2019-05-23 09:55 c_schmitz Status assigned => feedback
2019-05-23 09:55 c_schmitz Note Added: 52060