Please help us help you and fill where relevant:
Your LimeSurvey version: Version 5.6.5+230214
Own server or LimeSurvey hosting: own server
Survey theme/template: fruity
==================
Hi All,
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. The PostgreSQL log said:
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'))
In the limesurvey/vendor/yiisoft/yii/framework/db/schema/pgsql/CPgsqlSchema.php I've found the source of this problem. Making small modification I could overcome this problem, the contype should be casted to contype::char.
I don't know if it is possible the modify the code in the yii, or find a workaround, but maybe this info will help somebody.
Cheers
Tibor
