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
  • Sos_Sosbu's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
5 years 4 months ago - 5 years 4 months 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: 5 years 4 months ago by Sos_Sosbu.
The topic has been locked.
More
5 years 4 months 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
The topic has been locked.
  • Juseanma_117558
  • Juseanma_117558's Avatar
  • Visitor
  • Visitor
5 years 3 months ago #177636 by Juseanma_117558
any news here?
Same error in 3.15.5
Did anyone of you created a bug report?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
5 years 3 months 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 , plugin development .
I don't answer to private message.
The topic has been locked.
  • Juseanma_117558
  • Juseanma_117558's Avatar
  • Visitor
  • Visitor
5 years 3 months ago #177683 by Juseanma_117558
The topic has been locked.
More
5 years 2 months ago #178853 by ming123ABC
Hi, i have same problem,

i try same solution

Limesurvey 3.15 can not work
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose