Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.

More
2 months 5 days ago - 2 months 5 days ago #176726 by Sos_Sosbu
Sos_Sosbu created the topic: Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.
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,
Last Edit: 2 months 5 days ago by Sos_Sosbu.

Please Log in or Create an account to join the conversation.

More
2 months 4 days ago #176735 by jelo
jelo replied the 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.

Are you a student conducting a survey? If yes, tell me why you use LimeSurvey?
www.limesurvey.org/forum/development/116...y-you-use-limesurvey
The following user(s) said Thank You: DenisChenu

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #177636 by efingdmi
efingdmi replied the 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?

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #177655 by DenisChenu
DenisChenu replied the topic: Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.

jelo wrote: This is a bug. The updater/installer shouldn't try to set things already set.

Not really :) Since we need to set id .

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 (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .

Please Log in or Create an account to join the conversation.

More
1 month 2 weeks ago #177683 by efingdmi
efingdmi replied the topic: Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.
The following user(s) said Thank You: DenisChenu

Please Log in or Create an account to join the conversation.

More
1 week 6 days ago #178853 by ming123ABC
ming123ABC replied the 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

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!