View Issue Details

This issue affects 2 person(s).
 6
IDProjectCategoryView StatusLast Update
19670Feature requestsInstallationpublic2025-11-21 21:01
Reporterlozam Assigned To 
PrioritynoneSeverity@70@ 
Status newResolutionopen 
Summary19670: Allow different schema in Postgres or MSSQL
Description

If we install LimeSurvey with PostgreSQL using a schema 'DEFAULT_SCHEMA' different from public, the installation fails and returns the error 'Limesurvey table settings_global not found in database'.

The problem arises from the fact that the class https://github.com/LimeSurvey/LimeSurvey/blob/master/vendor/yiisoft/yii/framework/db/schema/pgsql/CPgsqlSchema.php has the schema type as a class constant const DEFAULT_SCHEMA='public';

Do you have a solution to configure the schema from LimeSurvey or to provide an enhancement plz ?

Steps To Reproduce

Install LimeSurvey 6.5.18 with Php 8.3 and postgresql 14.12
change your PostgreySQL Schema name for exemple dblime01 instead public

TagsNo tags attached.
Bug heat6
Story point estimate
Users affected %

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
2024-07-29 10:24 lozam New Issue
2025-06-11 12:39 guest Bug heat 0 => 6
2025-11-21 19:22 c_schmitz Summary Installation issue with PostgreSQ => Allow different schema in Postgres or MSSQL
2025-11-21 21:01 c_schmitz Project Bug reports => Feature requests