View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
20710Bug reportsQuestion editorpublic2026-09-21 21:30
Reporterzufolo441 Assigned Toc_schmitz  
PrioritynoneSeverityblock 
Status closedResolutionfixed 
Product Version7.0.x 
Summary20710: error adding question in v7.1.2
Description

Hi, I get an error when I try to add a new question to a survey.
The problem is in file application/models/SettingsUser.php, line 161.
The error is a casting error from string to integer.
For the moment I patched in this way:
if ($entity_id != null) {
$searchCriteria->addCondition('entity_id::numeric=:entity_id');
$searchParams[':entity_id'] = $entity_id;
} else {
$searchCriteria->addCondition('entity_id IS NULL');
}

Steps To Reproduce

stop a survey hosted by pgsql 18 and try to add a questiom

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)7.1.2
I will donate to the project if issue is resolvedNo
BrowserFirefox 156
Database type & versionPostgreSQL 18
Server OS (if known)RedHat
Webserver software & version (if known)Nginx
PHP Version8.2
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2026-09-19 22:43

administrator   ~85850

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

LimeBot

LimeBot

2026-09-21 21:30

administrator   ~85909

Fixed in Release 7.2.0+260921

Related Changesets

LimeSurvey: master 52f7c30f

2026-09-19 22:38

c_schmitz


Details Diff
Fixed issue 20710: Error adding question when using Postgres Affected Issues
20710
mod - application/models/SettingsUser.php Diff File
add - tests/unit/models/SettingsUserTest.php Diff File

Issue History

Date Modified Username Field Change
2026-09-19 22:07 zufolo441 New Issue
2026-09-19 22:40 c_schmitz Assigned To => c_schmitz
2026-09-19 22:40 c_schmitz Status new => assigned
2026-09-19 22:43 c_schmitz Changeset attached => LimeSurvey master 52f7c30f
2026-09-19 22:43 c_schmitz Note Added: 85850
2026-09-19 22:43 c_schmitz Status assigned => resolved
2026-09-19 22:43 c_schmitz Resolution open => fixed
2026-09-19 22:43 c_schmitz Bug heat 0 => 2
2026-09-21 21:30 LimeBot Note Added: 85909
2026-09-21 21:30 LimeBot Status resolved => closed
2026-09-21 21:30 LimeBot Bug heat 2 => 4