View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
13857Bug reportsSurvey takingpublic2021-01-13 10:57
ReporterTinumm Assigned Toc_schmitz  
PrioritynoneSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version3.13.x 
Summary13857: Responses cannot be saved
Description

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
    Error:
    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
EINZUGEBENDE DATEN:
token: 123321
114214X7X11: N/A
114214X7X11: N/A
FEHLERHAFTE SQL ANWEISUNG:
FEHLERMELDUNG:

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 (17.1.0.1)
+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.
Attached Files
application.log (3,353 bytes)   
2018/07/04 13:29:46 [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).
2018/07/04 13:33:14 [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).
2018/07/04 13:34:41 [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).
2018/07/04 13:53:27 [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).
2018/07/04 14:40:30 [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).
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).
2018/07/09 13:41:52 [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).
application.log (3,353 bytes)   
Response_error.jpg (48,914 bytes)   
Response_error.jpg (48,914 bytes)   
Bug heat2
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 type & 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

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

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!

c_schmitz

c_schmitz

2021-01-13 10:57

administrator   ~61526

Closed due to missing feedback.

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
2021-01-13 10:57 c_schmitz Status feedback => closed
2021-01-13 10:57 c_schmitz Resolution open => unable to reproduce
2021-01-13 10:57 c_schmitz Note Added: 61526