View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
13857 | Bug reports | Survey taking | public | 2018-07-09 15:20 | 2021-01-13 10:57 |
Reporter | Tinumm | Assigned To | c_schmitz | ||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 3.13.x | ||||
Summary | 13857: Responses cannot be saved | ||||
Description | When taking a survey the answer of the participant cannot be saved. | ||||
Steps To Reproduce |
Indeed the administator will receive following mail: Application.log says: | ||||
Additional Information | +Microsoft ODBC Driver 13 for SQL Server (13.1.4414.46) | ||||
Tags | No 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). | ||||
Bug heat | 2 | ||||
Complete LimeSurvey version number (& build) | 3.12.3+180627 & limesurvey3.13.1+180629 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Mozilla Firefox 59.0.2 / Internet Explorer 11.1480 | ||||
Database type & version | MSSSQL 14.0.3022.28 (2017) | ||||
Server OS (if known) | Windows Server 2016 x64 Standard | ||||
Webserver software & version (if known) | IIS 10 | ||||
PHP Version | PHP 7.2.5 x64 | ||||
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 |
|
Assigned To | => c_schmitz |
2018-07-09 16:13 |
|
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 |