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

More
4 months 1 week ago - 4 months 1 week ago #176726 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,
Last edit: 4 months 1 week ago by Sos_Sosbu.

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

LimeSurvey Partners
More
4 months 1 week ago #176735 by jelo
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.

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

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

More
3 months 2 weeks ago #177636 by efingdmi
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
3 months 2 weeks ago #177655 by DenisChenu

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
3 months 2 weeks ago #177683 by efingdmi
The following user(s) said Thank You: DenisChenu

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

More
2 months 2 weeks ago #178853 by ming123ABC
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!