Your LimeSurvey version: 5.4.10+221107
Your PHP version: php-8.0.12-nts-Win32-vs16-x64
Your PostgreSQL version: PosgreSQL 15
Your OS version: Windows 10.0.17763.3532
Own server 

Hi all,

I'm trying to install the latest version of Limesurvey 5.4.10 but it seems to be a problem in the administrator settings step (6). After filling the appropriate values for the admin and clicking on next the following error is displayed on the browser:

Internal Server Error
Could not add administrator settings: CDbException: CDbCommand failed to execute the SQL statement: SQLSTATE[42804]: Datatype mismatch: 7 ERROR: los tipos "char" y text no son coincidentes en UNION
LINE 21: CASE WHEN indisprimary THEN
^ in \limesurvey\third_party\yiisoft\yii\framework\db\CDbCommand.php:543
Stack trace:
#0 \limesurvey\third_party\yiisoft\yii\framework\db\CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 \limesurvey\third_party\yiisoft\yii\framework\db\schema\pgsql\CPgsqlSchema.php(278): CDbCommand->queryAll()
#2 \limesurvey\third_party\yiisoft\yii\framework\db\schema\pgsql\CPgsqlSchema.php(115): CPgsqlSchema->findConstraints(Object(CPgsqlTableSchema))
#3 \limesurvey\third_party\yiisoft\yii\framework\db\schema\CDbSchema.php(103): CPgsqlSchema->loadTable('lime_users')
#4 \limesurvey\third_party\yiisoft\yii\framework\db\ar\CActiveRecord.php(2390): CDbSchema->getTable('{{users}}')
#5 \limesurvey\third_party\yiisoft\yii\framework\db\ar\CActiveRecord.php(413): CActiveRecordMetaData->__construct(Object(User))
#6 \limesurvey\third_party\yiisoft\yii\framework\db\ar\CActiveRecord.php(682): CActiveRecord->getMetaData()
#7 \limesurvey\application\models\LSActiveRecord.php(38): CActiveRecord->hasAttribute('created')
#8 \limesurvey\third_party\yiisoft\yii\framework\db\ar\CActiveRecord.php(398): LSActiveRecord->behaviors()
#9 \limesurvey\application\models\User.php(69): CActiveRecord::model('User')
#10 \limesurvey\application\controllers\InstallerController.php(493): User::model()
#11 \limesurvey\application\controllers\InstallerController.php(82): InstallerController->stepOptionalConfiguration()
#12 \limesurvey\third_party\yiisoft\yii\framework\web\CWebApplication.php(282): InstallerController->run('optional')
#13 \limesurvey\third_party\yiisoft\yii\framework\web\CWebApplication.php(141): CWebApplication->runController('installer/optio...')
#14 \limesurvey\third_party\yiisoft\yii\framework\base\CApplication.php(185): CWebApplication->processRequest()
#15 \limesurvey\index.php(192): CApplication->run()
#16 {main}.An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.Thank you.

That's the first time we have tried to integrate Limesurvey with PostgreSQL (before we were using MySQL) and we don't have any problems in the past. Do you know what it is happening?

Cheers and thanks in advance for your help,

Hi, the problem is PGSQL 15. If you downgrade to 13, it works.