View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
19910Bug reportsDatabase designpublic2024-12-20 18:522025-01-08 15:50
Reporterzufolo441 Assigned Totibor.pacalat  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version6.6.x 
Summary19910: error upgrading database to version 627 in MSSQL
Description

Hi,
I encountered an error upgrading LS to 6.9.0 and consequently database to schema version 627. function in Update_627.php tries to set values to ID field, but it's an identity field, so MSSQL doesn't permit to explicitly set it. I had to remove 'id' => '1' etcetera in private $boxes in order to execute successfully the update.

Steps To Reproduce

upgrade LS to 6.9.0 in an installation based on MSSQL.

TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)6.9.0
I will donate to the project if issue is resolvedNo
BrowserFirefox 133.0.3
Database type & versionMSSQL 2015
Server OS (if known)
Webserver software & version (if known)
PHP Version8.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

gabrieljenik

gabrieljenik

2025-01-02 17:00

manager   ~81729

https://github.com/LimeSurvey/LimeSurvey/pull/4124
DenisChenu

DenisChenu

2025-01-06 08:50

developer   ~81733

Don't think need testing. Code is clear
LimeBot

LimeBot

2025-01-08 15:50

administrator   ~81770

Fixed in Release 6.10.0+250106

Issue History

Date Modified Username Field Change
2024-12-20 18:52 zufolo441 New Issue
2024-12-23 13:51 tibor.pacalat Assigned To => gabrieljenik
2024-12-23 13:51 tibor.pacalat Status new => assigned
2025-01-02 17:00 gabrieljenik Assigned To gabrieljenik => DenisChenu
2025-01-02 17:00 gabrieljenik Status assigned => ready for code review
2025-01-02 17:00 gabrieljenik Note Added: 81729
2025-01-02 17:00 gabrieljenik Bug heat 0 => 2
2025-01-06 08:50 DenisChenu Assigned To DenisChenu => tibor.pacalat
2025-01-06 08:50 DenisChenu Status ready for code review => ready for testing
2025-01-06 08:50 DenisChenu Note Added: 81733
2025-01-06 08:50 DenisChenu Bug heat 2 => 4
2025-01-06 13:01 tibor.pacalat Status ready for testing => resolved
2025-01-06 13:01 tibor.pacalat Resolution open => fixed
2025-01-08 15:50 LimeBot Note Added: 81770
2025-01-08 15:50 LimeBot Status resolved => closed
2025-01-08 15:50 LimeBot Bug heat 4 => 6