View Issue Details

IDProjectCategoryView StatusLast Update
13857Bug reports[All Projects] Survey takingpublic2018-07-09 16:13
ReporterTinummAssigned Toc_schmitz 
PrioritynoneSeveritymajor 
Status assignedResolutionopen 
Product Version3.13.x 
Target VersionFixed in Version 
Summary13857: Responses cannot be saved
DescriptionWhen taking a survey the answer of the participant cannot be saved.
Steps To Reproduce1. 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.
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)
Operating System (Server)Windows Server 2016 x64 Standard
Webserver software & versionIIS 10
PHP VersionPHP 7.2.5 x64

Activities

Tinumm

Tinumm

2018-07-09 15:20

reporter  

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

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