View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 0
IDProjectCategoryView StatusDate SubmittedLast Update
20355Bug reportsComfortUpdatepublic2025-11-18 10:492025-11-18 10:49
Reportermsvojsik Assigned To 
PrioritynoneSeveritycrash 
Status newResolutionopen 
Product Version6.6.x 
Summary20355: Not able to upgrade from Limesurvey community version 6.15.1 to newer version when running on MSSQL DBMS
Description

While trying update to newer version, the update fails because of T-SQL syntax error with the following details:
Syntax error in upgrade script for MSSQL DBMS.
Upgrade fails when trying to upgrade from DB version 633 (Limesurvey 6.15.0) or 634 (Limesurvey 6.15.1) to 636 (Limesurvey 6.15.4 or newer) with the following error:

CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]Incorrect syntax near the keyword 'backup'.

\application\helpers\update\updates\Update_636.php, line 20

Steps To Reproduce

Steps to reproduce

Upgrade fails when trying to upgrade from DB version 633 (Limesurvey 6.15.0) or 634 (Limesurvey 6.15.1) to 636 (Limesurvey 6.15.4 or newer)

Expected result

successfull upgrade

Actual result

upgrade fails

TagsNo tags attached.
Bug heat0
Complete LimeSurvey version number (& build)6.15.0 (build 250623)
I will donate to the project if issue is resolvedYes
Browser
Database type & versionMSSQL Server 2022
Server OS (if known)Windows server 2022
Webserver software & version (if known)IIS 10
PHP Version8.3.27

Users monitoring this issue

There are no users monitoring this issue.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2025-11-18 10:49 msvojsik New Issue