View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 0
IDProjectCategoryView StatusDate SubmittedLast Update
20237Bug reportsDatabase designpublic2025-08-21 21:352025-08-21 21:35
Reportermsvojsik Assigned To 
PrioritynoneSeverityblock 
Status newResolutionopen 
Product Version6.6.x 
Summary20237: Unable to upgrade from 6.15.1 to 6.15.4 or newer when using MSSQL DBMS
Description

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 could not execute 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 to newest release

Actual result

upgrade failes with following error message:
CDbCommand could not execute 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

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

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-08-21 21:35 msvojsik New Issue