| Description | During the installation process, using PostgreSQL as backend db, at the step of setting admin password (I hope, I remember correctly), I've got an internal server error.
After the modification of the limesurvey/vendor/yiisoft/yii/framework/db/schema/pgsql/CPgsqlSchema.php file, casting contype to contype::char, the error can be avoided. |
|---|
| Steps To Reproduce | Steps to reproduce
Insta
Expected result
The installation process can be finished successfully
Actual result
Internal server error.
The
In the PostgreSQl log:
ERROR: UNION types "char" and text cannot be matched at character 277
SELECT
conname,
consrc,
contype,
indkey
FROM (
SELECT
conname,
pg_catalog.pg_get_constraintdef(oid) AS consrc,
contype,
conrelid AS relid,
NULL AS indkey
FROM
pg_catalog.pg_constraint
WHERE
contype IN ('f', 'c')
UNION ALL
SELECT
pc.relname,
NULL,
CASE WHEN indisprimary THEN
'p'
ELSE
'u'
END,
pi.indrelid,
indkey
FROM
pg_catalog.pg_class pc,
pg_catalog.pg_index pi
WHERE
pc.oid=pi.indexrelid
AND EXISTS (
SELECT 1 FROM pg_catalog.pg_depend d JOIN pg_catalog.pg_constraint c
ON (d.refclassid = c.tableoid AND d.refobjid = c.oid)
WHERE d.classid = pc.tableoid AND d.objid = pc.oid AND d.deptype = 'i' AND c.contype IN ('u', 'p')
)
) AS sub
WHERE relid = (SELECT oid FROM pg_catalog.pg_class WHERE relname='lime_users'
AND relnamespace = (SELECT oid FROM pg_catalog.pg_namespace
WHERE nspname='public')) |
|---|
