| Description | Setting up a bilingual survey, I try to import a bilingual question with corresponding languages. This results in error message:
"SQLSTATE[HY000]: General error: 20018 Cannot insert explicit value for identity column in table 'questions' when IDENTITY_INSERT is set to OFF. [20018] (severity 16)" when importing a question lsq file
and
"SQLSTATE[HY000]: General error: 20018 Explicit value must be specified for identity column in table 'questions' either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column. [20018] (severity 16) [(null)]"
when importing a group lsg file. In the latter case, questions are partly imported but answer options are missing. |
|---|
| Additional Information | Already happens in 2.6.4 lts build 170202, and 3.0.3 also (with mssql).
I think the problem is that in mssql, qid is defined as "identity" column, so when you try to insert another row in the questions table with the same qid but another language, you get this error (identity column containing unique values). |
|---|
