View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
20365Bug reportsDatabase designpublic2025-11-21 10:242025-11-21 19:05
Reportermferraz Assigned Toc_schmitz  
PrioritynoneSeveritycrash 
Status resolvedResolutionfixed 
Product Version6.6.x 
Summary20365: Getting an error when trying to upgrade to 6.16.0+251120 (PostgreSQL)
Description

An non-recoverable error happened during the update. Error details:

CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text = integer LINE 10: AND "value" = 1 ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts.

File DatabaseUpdateBase.php, line 47.

Steps To Reproduce

Steps to reproduce

Upgrade to the latest version on a PostgreSQL installation.

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)6.16.0+251120
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 15+248
Server OS (if known)
Webserver software & version (if known)
PHP Version8.1

Users monitoring this issue

There are no users monitoring this issue.

Activities

cbm.it

cbm.it

2025-11-21 17:29

reporter   ~83899

Same here with Postgres 15.14 (Debian version 15.14-0+deb12u1).
c_schmitz

c_schmitz

2025-11-21 18:15

administrator   ~83904

What was your previous versioN?
mferraz

mferraz

2025-11-21 18:21

reporter   ~83905

6.15.24+251117
zufolo441

zufolo441

2025-11-21 18:40

reporter   ~83906

Hi,
the error is in Update_640.php.
Field lime_question_attributes.value is a text, not integer.
rows 31, 38, 40 needs correction:
AND " . $this->db->quoteColumnName("value") . " = '1'
c_schmitz

c_schmitz

2025-11-21 19:05

administrator   ~83907

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

Related Changesets

LimeSurvey: master 9d03a8ad

2025-11-21 19:05

c_schmitz


Details Diff		 Fixed issue 20365: Getting an error when trying to upgrade to 6.16.0+251120 using Postgres Affected Issues
20365
mod - application/helpers/update/updates/Update_640.php Diff File

Issue History

Date Modified Username Field Change
2025-11-21 10:24 mferraz New Issue
2025-11-21 17:29 cbm.it Note Added: 83899
2025-11-21 17:29 cbm.it Bug heat 0 => 2
2025-11-21 18:15 c_schmitz Note Added: 83904
2025-11-21 18:15 c_schmitz Bug heat 2 => 4
2025-11-21 18:21 mferraz Note Added: 83905
2025-11-21 18:21 mferraz Bug heat 4 => 6
2025-11-21 18:40 zufolo441 Note Added: 83906
2025-11-21 18:40 zufolo441 Bug heat 6 => 8
2025-11-21 19:05 c_schmitz Changeset attached => LimeSurvey master 9d03a8ad
2025-11-21 19:05 c_schmitz Note Added: 83907
2025-11-21 19:05 c_schmitz Assigned To => c_schmitz
2025-11-21 19:05 c_schmitz Status new => resolved
2025-11-21 19:05 c_schmitz Resolution open => fixed