- Posts: 1
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.
- Sos_Sosbu
- Topic Author
- Offline
- New Member
Less
More
5 years 4 months ago - 5 years 4 months ago #176726
by Sos_Sosbu
Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF. was created by Sos_Sosbu
Hi,
I'm trying to upgrade limesurvey server from v3.4.3 to 3.15.3 but I'm getting an error
"An non-recoverable error happened during the update. Error details:
CDbCommand ne može da izvrši SQL-Statement: SQLSTATE[23000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert explicit value for identity column in table 'lime_surveymenu' when IDENTITY_INSERT is set to OFF."
I'm using MS SQL 2016 express and I have set "SET IDENTITY_INSERT lime_surveymenu ON" but the error persists.
Any help would be appreciated.
Regards,
I'm trying to upgrade limesurvey server from v3.4.3 to 3.15.3 but I'm getting an error
"An non-recoverable error happened during the update. Error details:
CDbCommand ne može da izvrši SQL-Statement: SQLSTATE[23000]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]Cannot insert explicit value for identity column in table 'lime_surveymenu' when IDENTITY_INSERT is set to OFF."
I'm using MS SQL 2016 express and I have set "SET IDENTITY_INSERT lime_surveymenu ON" but the error persists.
Any help would be appreciated.
Regards,
Last edit: 5 years 4 months ago by Sos_Sosbu.
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
5 years 4 months ago #176735
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.
You shouldn't change the IDENTITY_INSERT.
This is a bug. The updater/installer shouldn't try to set things already set.
I haven't seen a fix in 3.15.4+181109, so please open a bugticket.
This is a bug. The updater/installer shouldn't try to set things already set.
I haven't seen a fix in 3.15.4+181109, so please open a bugticket.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: DenisChenu
The topic has been locked.
- Juseanma_117558
- Visitor
5 years 3 months ago #177636
by Juseanma_117558
Replied by Juseanma_117558 on topic Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.
any news here?
Same error in 3.15.5
Did anyone of you created a bug report?
Same error in 3.15.5
Did anyone of you created a bug report?
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13935
- Thank you received: 2551
5 years 3 months ago #177655
by DenisChenu
But mssql need a function switchMSSQLIdentityInsert for id.
Bug need to be reported
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.
Not really Since we need to set id .jelo wrote: This is a bug. The updater/installer shouldn't try to set things already set.
But mssql need a function switchMSSQLIdentityInsert for id.
Bug need to be reported
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- Juseanma_117558
- Visitor
5 years 3 months ago #177683
by Juseanma_117558
Replied by Juseanma_117558 on topic Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.
The topic has been locked.
- ming123ABC
- Offline
- Senior Member
Less
More
- Posts: 71
- Thank you received: 4
5 years 2 months ago #178853
by ming123ABC
Replied by ming123ABC on topic Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.
Hi, i have same problem,
i try same solution
Limesurvey 3.15 can not work
i try same solution
Limesurvey 3.15 can not work
The topic has been locked.