20281: MSSQL Database Upgrade fail 636 to 637 (LimeSurvey Community 6.15.9 to 6.15.15)

This bug affects 4 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

20281	Bug reports	ComfortUpdate	public	2025-10-01 10:00	2025-10-27 14:40

Reporter	FredJackson	Assigned To	gabrieljenik
Priority	none	Severity	crash
Status	assigned	Resolution	open

Summary	20281: MSSQL Database Upgrade fail 636 to 637 (LimeSurvey Community 6.15.9 to 6.15.15)
Description	Ran the comfort update to update from 6.15.9 to 6.15.15 and presented with an SQL error when trying to access any surveys/admin. CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. Also tried to manually upgrade the database via cli; Update sqlsrv:Server=10.174.129.118;TrustServerCertificate=1;Database=limesurvey with prefix :lime_ from 636 to 637 CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near 'LIMIT'. in /var/www/html/vendor/yiisoft/yii/framework/db/CDbCommand.php:543 Stack trace: #0 /var/www/html/vendor/yiisoft/yii/framework/db/CDbCommand.php(415): CDbCommand->queryInternal() #1 /var/www/html/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1359): CDbCommand->queryRow() #2 /var/www/html/application/models/LSActiveRecord.php(72): CActiveRecord->query() #3 /var/www/html/vendor/yiisoft/yii/framework/db/ar/CActiveRecord.php(1494): LSActiveRecord->query() #4 /var/www/html/application/models/Survey.php(1003): CActiveRecord->findByPk() #5 /var/www/html/application/helpers/common_helper.php(3786): Survey->findByPk() #6 /var/www/html/application/helpers/update/updatedb_helper.php(3108): fixLanguageConsistency() #7 /var/www/html/application/helpers/update/updatedb_helper.php(154): fixLanguageConsistencyAllSurveys() #8 /var/www/html/application/commands/UpdateDbCommand.php(46): db_upgrade_all() #9 /var/www/html/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run() #10 /var/www/html/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run() #11 /var/www/html/vendor/yiisoft/yii/framework/base/CApplication.php(185): CConsoleApplication->processRequest() #12 /var/www/html/application/commands/console.php(77): CApplication->run()
Steps To Reproduce	Steps to reproduce Comfort update from version 6.15.9 to 6.15.15 Expected result Successful database upgrade Actual result Database did not upgrade and was presented with SQL error. Thankfully I backed up the previous version and was able to reinstate back to 6.15.9 as business critical
Tags	No tags attached.

Bug heat	28
Complete LimeSurvey version number (& build)	6.15.9+250826
I will donate to the project if issue is resolved	No
Browser
Database type & version	MSSQL 2022 (ODBC Driver 18 for SQL Server)
Server OS (if known)
Webserver software & version (if known)
PHP Version	8.1.2

User List	lsbugtrack, msvojsik, Packages support

Date Modified	Username	Field	Change
2025-10-01 10:00	FredJackson	New Issue
2025-10-01 10:27	tibor.pacalat	Assigned To	=> gabrieljenik
2025-10-01 10:27	tibor.pacalat	Status	new => assigned
2025-10-01 22:05	lsbugtrack	Issue Monitored: lsbugtrack
2025-10-01 22:05	lsbugtrack	Bug heat	0 => 2
2025-10-02 09:18	guest	Bug heat	2 => 8
2025-10-02 09:18	msvojsik	Issue Monitored: msvojsik
2025-10-02 09:18	msvojsik	Bug heat	8 => 10
2025-10-02 09:25	msvojsik	Bug heat	10 => 12
2025-10-08 11:34	guest	Bug heat	12 => 18
2025-10-13 12:22	guest	Bug heat	18 => 24
2025-10-13 13:13	Packages support	Issue Monitored: Packages support
2025-10-13 13:13	Packages support	Bug heat	24 => 26
2025-10-27 14:40	FredJackson	Note Added: 83674
2025-10-27 14:40	FredJackson	Bug heat	26 => 28

View Issue Details

Steps to reproduce

Expected result

Actual result

Users monitoring this issue

Activities

Issue History

FredJackson 2025-10-27 14:40 reporter ~83674	Any further updates on this? I see a number of updates have been released since raising this (looking at your change notes) but nothing to fix this?