View Issue Details

This issue affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
20365Bug reportsDatabase designpublic2025-11-21 10:24
Reportermferraz Assigned To 
PrioritynoneSeveritycrash 
Status newResolutionopen 
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 heat0
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

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2025-11-21 10:24 mferraz New Issue