Back to limesurvey.org

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
6 years 3 months ago - 6 years 3 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,
Last edit: 6 years 3 months ago by Sos_Sosbu.
The topic has been locked.
More
6 years 3 months ago #176735 by jelo
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.
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
  • New Member
  • New Member
More
6 years 2 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?
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team & Official Partner
  • LimeSurvey Community Team & Official Partner
More
6 years 2 months ago #177655 by DenisChenu
Replied by DenisChenu on 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 support - Plugins, theme and development .
I don't answer to private message.
The topic has been locked.
  • Juseanma_117558
  • Juseanma_117558's Avatar
  • New Member
  • New Member
More
6 years 2 months ago #177683 by Juseanma_117558
Replied by Juseanma_117558 on topic Upgrade to v3.15 - SQL error IDENTITY_INSERT is set to OFF.
done
bugs.limesurvey.org/view.php?id=14309
The topic has been locked.
More
6 years 1 month 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
The topic has been locked.
Moderators: holch, tpartner

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source