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
Git branch / Pull Request URL
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