View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
17356Bug reportsInstallationpublic2021-07-13 16:38
ReportersdsAdm1n Assigned Toc_schmitz  
PrioritylowSeveritypartial_block 
Status closedResolutionfixed 
Product Version5.x 
Summary17356: Error [SQL Server]IDENTITY_INSERT is already ON for table 'limesurvey_quota_languagesettings'
Description

I manually update limesurvey to latest versions. my current version was 4.6 and I have installed the latest version 5.0.
and after installation complition, I received the following error message upon calling the admin page for database schema upgrade :
[error] [exception.PDOException] PDOException: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]IDENTITY_INSERT is already ON for table 'limesurvey_quota_languagesettings'. Cannot perform SET operation for table 'limesurvey_assessments'. in limesurvey\application\helpers\common_helper.php:5004

after the error message appeared I called the admin page again, and the login page appeared and I was able to access the system.

Steps To Reproduce
  1. Manually update from version 4.6 to 5.0
  2. after installing call the admin page. e.g. https://www.example.com/limesurvey/admin
  3. the error message will show
TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)5.0.2+210607
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome
Database type & versionMS SQL Server 2016
Server OS (if known)Win Server 2019
Webserver software & version (if known)IIS 10
PHP Version7.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2021-06-09 13:33

administrator   ~64796

Guess state should be checked before calling

5004 Yii::app()->db->pdoInstance->exec('SET IDENTITY_INSERT ' . Yii::app()->db->tablePrefix . $table . ' ON');

c_schmitz

c_schmitz

2021-07-12 11:53

administrator   ~65353

Release done.

c_schmitz

c_schmitz

2021-07-13 16:38

administrator   ~65427

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=32182

Related Changesets

LimeSurvey: master f6cfac27

2021-07-12 11:05:48

c_schmitz

Details Diff
Fixed issue 17356: Error [SQL Server]IDENTITY_INSERT is already ON for table 'limesurvey_quota_languagesettings' when using quotas and MSSQL Affected Issues
17356
mod - application/core/plugins/Authdb/Authdb.php Diff File
mod - application/helpers/common_helper.php Diff File

Issue History

Date Modified Username Field Change
2021-06-08 08:48 sdsAdm1n New Issue
2021-06-08 15:01 ollehar Priority none => normal
2021-06-09 13:33 ollehar Note Added: 64796
2021-06-09 13:33 ollehar Priority normal => low
2021-07-12 10:24 c_schmitz View Status private => public
2021-07-12 11:04 c_schmitz Assigned To => c_schmitz
2021-07-12 11:04 c_schmitz Status new => assigned
2021-07-12 11:06 c_schmitz Status assigned => resolved
2021-07-12 11:06 c_schmitz Resolution open => fixed
2021-07-12 11:53 c_schmitz Note Added: 65353
2021-07-12 11:53 c_schmitz Status resolved => closed
2021-07-13 16:38 c_schmitz Changeset attached => LimeSurvey master f6cfac27
2021-07-13 16:38 c_schmitz Note Added: 65427