View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
17917Bug reportsDatabase designpublic2022-03-01 06:542022-04-11 14:07
ReportersdsAdm1n Assigned Togalads  
PrioritynoneSeveritycrash 
Status closedResolutionfixed 
Product Version5.2.x 
Summary17917: A non-recoverable error happened during the update to LS 5.3
Description

After installing the files of LS version 5.3.0, and upon calling the admin page; an error produced stating :
"CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot define PRIMARY KEY constraint on nullable column in table 'ls_message'."

Steps To Reproduce

Steps to reproduce

updating LS v 5.2 into LS v5.3

Expected result

having the system successfully updated into LS v5.3

Actual result

attached db error preventing the update process

TagsNo tags attached.
Attached Files
DB Error_5.3.png (38,181 bytes)   
DB Error_5.3.png (38,181 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)5.3.1+220301
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionMS SQL Server 2016
Server OS (if known)Win Server 2019
Webserver software & version (if known)IIS 10
PHP Version7.4

Relationships

Relationship GraphDependency Graph
related to 17927 closedc_schmitz update from 5.2.13 to 5.3.2 in Postgresql 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-03-01 08:47

developer   ~68465

Please : can you test this update : https://github.com/LimeSurvey/LimeSurvey/pull/2275/files
DenisChenu

DenisChenu

2022-03-01 13:45

developer   ~68472

Last edited: 2022-03-02 08:14

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

LimeBot

2022-03-01 17:24

administrator   ~68480

Last edited: 2022-03-02 08:14

Fixed in Release 5.3.1+220301
sdsAdm1n

sdsAdm1n

2022-03-02 06:45

reporter   ~68484

Last edited: 2022-03-02 08:14

Thanks a lot for the prompt response, I have installed LS 5.3.1, but I am still getting an error as per attached

DB Error_5.3.1.png (35,151 bytes)   
DB Error_5.3.1.png (35,151 bytes)   
DenisChenu

DenisChenu

2022-03-02 08:14

developer   ~68486

Last edited: 2022-03-02 08:14

This is another issue : https://github.com/LimeSurvey/LimeSurvey/commit/8fdbfdabd6be1c29725766aa684f1f5881805d2e
c_schmitz

c_schmitz

2022-03-02 12:39

administrator   ~68515

@sdsAdm1n: For that last error apply this fix manually:

https://github.com/LimeSurvey/LimeSurvey/commit/a59512a2b4b72ba70aac9b6fb3fa680d322ef08c
sdsAdm1n

sdsAdm1n

2022-03-03 07:49

reporter   ~68530

many thanks @c_schmitz and all team, this is to confirm issue have been resolved after applying the fix here https://github.com/LimeSurvey/LimeSurvey/commit/a59512a2b4b72ba70aac9b6fb3fa680d322ef08c

Related Changesets

LimeSurvey: master 58965665

2022-03-01 13:45:22

DenisChenu


Committer: GitHub Details Diff 		Fixed issue 17917: A non-recoverable error happened during the update when using MSSQL (#2275) Affected Issues
17917
mod - application/config/version.php Diff File
mod - application/helpers/update/updates/Update_480.php Diff File
add - application/helpers/update/updates/Update_482.php Diff File
mod - installer/create-database.php Diff File

Issue History

Date Modified Username Field Change
2022-03-01 06:54 sdsAdm1n New Issue
2022-03-01 06:54 sdsAdm1n File Added: DB Error_5.3.png
2022-03-01 08:16 DenisChenu Assigned To => DenisChenu
2022-03-01 08:16 DenisChenu Status new => assigned
2022-03-01 08:47 DenisChenu Note Added: 68465
2022-03-01 08:47 DenisChenu Bug heat 0 => 2
2022-03-01 10:08 galads Zoho Project Synchronization => |Yes|
2022-03-01 13:45 DenisChenu Changeset attached => LimeSurvey master 58965665
2022-03-01 13:45 DenisChenu Note Added: 68472
2022-03-01 13:45 DenisChenu Resolution open => fixed
2022-03-01 13:47 c_schmitz Status assigned => resolved
2022-03-01 17:24 LimeBot Zoho Project Synchronization Yes => |Yes|
2022-03-01 17:24 LimeBot Note Added: 68480
2022-03-01 17:24 LimeBot Status resolved => closed
2022-03-01 17:24 LimeBot Bug heat 2 => 4
2022-03-02 06:45 sdsAdm1n Note Added: 68484
2022-03-02 06:45 sdsAdm1n File Added: DB Error_5.3.1.png
2022-03-02 06:45 sdsAdm1n Bug heat 4 => 6
2022-03-02 08:14 DenisChenu Assigned To DenisChenu => galads
2022-03-02 08:14 DenisChenu Status closed => feedback
2022-03-02 08:14 DenisChenu Resolution fixed => reopened
2022-03-02 08:14 DenisChenu Complete LimeSurvey version number (& build) 5.2.14 build 220214 => 5.3.1+220301
2022-03-02 08:14 DenisChenu Note Added: 68486
2022-03-02 12:39 c_schmitz Note Added: 68515
2022-03-02 12:39 c_schmitz Bug heat 6 => 8
2022-03-03 07:49 sdsAdm1n Note Added: 68530
2022-03-03 07:49 sdsAdm1n Status feedback => assigned
2022-03-07 10:46 c_schmitz Relationship added related to 17927
2022-03-07 10:50 c_schmitz Status assigned => resolved
2022-03-07 10:50 c_schmitz Resolution reopened => fixed
2022-04-11 14:07 galads Status resolved => closed