View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
20444Bug reportsComfortUpdatepublic2026-03-04 09:262026-03-04 11:39
Reporterginosupport Assigned Toc_schmitz  
PrioritynoneSeveritycrash 
Status resolvedResolutionfixed 
Product Version6.16.x 
Summary20444: SQL error during update from 6.16.10 to 6.16.11
Description

Yesterday I used comfortupdate to update from 6.16.4 to 6.16.10. This morning i saw that there was a new update (6.16.11), which i tried to install using comfortupdate as well. This failed with an SQL error.
It looks like it might be using the wrong type of quote characters?

Steps To Reproduce

Steps to reproduce

Install version 6.16.10
Use comfortupdate to update to 6.16.11

Expected result

Update succesful

Actual result

SQL error (i hope the dutch text is good enough to find the problem):
CDbCommand faalde tijdens het uitvoeren van volgend SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "" LINE 1: ...tle = 'Workspace', buttontext = 'View workspace',desc` = '... ^

Bestand DatabaseUpdateBase.php, regel 47.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)6.16.10/6.16.11
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgres 17
Server OS (if known)
Webserver software & version (if known)
PHP Version8.2.30

Users monitoring this issue

There are no users monitoring this issue.

Activities

guest

guest

2026-03-04 11:37

viewer   ~84387

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

guest

2026-03-04 11:37

viewer   ~84388

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

c_schmitz

2026-03-04 11:39

administrator   ~84389

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

Related Changesets

LimeSurvey: master 7151c88b

2026-03-04 11:37

Stefan K

Committer: GitHub


Details Diff		 Fixed issue 20444: SQL error during update to 6.16.11 and using MSSQL Affected Issues
20444
mod - application/helpers/update/updates/Update_643.php Diff File

LimeSurvey: master 7151c88b

2026-03-04 11:37

Stefan K

Committer: GitHub


Details Diff		 Fixed issue 20444: SQL error during update to 6.16.11 and using MSSQL Affected Issues
20444
mod - application/helpers/update/updates/Update_643.php Diff File

LimeSurvey: master 079829be

2026-03-04 11:37

Stefan K

Committer: c_schmitz


Details Diff		 Fixed issue 20444: SQL error during update to 6.16.11 and using Postgres Affected Issues
20444
mod - application/helpers/update/updates/Update_643.php Diff File

Issue History

Date Modified Username Field Change
2026-03-04 09:26 ginosupport New Issue
2026-03-04 10:16 tibor.pacalat Assigned To => gabrieljenik
2026-03-04 10:16 tibor.pacalat Status new => assigned
2026-03-04 11:06 c_schmitz Assigned To gabrieljenik => stefankotes
2026-03-04 11:34 stefankotes Status assigned => ready for code review
2026-03-04 11:37 Changeset attached => LimeSurvey master 7151c88b
2026-03-04 11:37 Changeset attached => LimeSurvey master 7151c88b
2026-03-04 11:37 guest Note Added: 84387
2026-03-04 11:37 guest Note Added: 84388
2026-03-04 11:37 guest Bug heat 0 => 2
2026-03-04 11:37 guest Bug heat 0 => 2
2026-03-04 11:39 c_schmitz Changeset attached => LimeSurvey master 079829be
2026-03-04 11:39 c_schmitz Note Added: 84389
2026-03-04 11:39 c_schmitz Assigned To stefankotes => c_schmitz
2026-03-04 11:39 c_schmitz Status ready for code review => resolved
2026-03-04 11:39 c_schmitz Resolution open => fixed
2026-03-04 11:39 c_schmitz Bug heat 2 => 4