Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Could not add administrator settings: CDbException

  • jmluengo
  • jmluengo's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
1 year 4 months ago - 1 year 4 months ago #233953 by jmluengo
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 D:\limesurvey\third_party\yiisoft\yii\framework\db\CDbCommand.php:543
Stack trace:
#0 D:\limesurvey\third_party\yiisoft\yii\framework\db\CDbCommand.php(396): CDbCommand->queryInternal('fetchAll', Array, Array)
#1 D:\limesurvey\third_party\yiisoft\yii\framework\db\schema\pgsql\CPgsqlSchema.php(278): CDbCommand->queryAll()
#2 D:\limesurvey\third_party\yiisoft\yii\framework\db\schema\pgsql\CPgsqlSchema.php(115): CPgsqlSchema->findConstraints(Object(CPgsqlTableSchema))
#3 D:\limesurvey\third_party\yiisoft\yii\framework\db\schema\CDbSchema.php(103): CPgsqlSchema->loadTable('lime_users')
#4 D:\limesurvey\third_party\yiisoft\yii\framework\db\ar\CActiveRecord.php(2390): CDbSchema->getTable('{{users}}')
#5 D:\limesurvey\third_party\yiisoft\yii\framework\db\ar\CActiveRecord.php(413): CActiveRecordMetaData->__construct(Object(User))
#6 D:\limesurvey\third_party\yiisoft\yii\framework\db\ar\CActiveRecord.php(682): CActiveRecord->getMetaData()
#7 D:\limesurvey\application\models\LSActiveRecord.php(38): CActiveRecord->hasAttribute('created')
#8 D:\limesurvey\third_party\yiisoft\yii\framework\db\ar\CActiveRecord.php(398): LSActiveRecord->behaviors()
#9 D:\limesurvey\application\models\User.php(69): CActiveRecord::model('User')
#10 D:\limesurvey\application\controllers\InstallerController.php(493): User::model()
#11 D:\limesurvey\application\controllers\InstallerController.php(82): InstallerController->stepOptionalConfiguration()
#12 D:\limesurvey\third_party\yiisoft\yii\framework\web\CWebApplication.php(282): InstallerController->run('optional')
#13 D:\limesurvey\third_party\yiisoft\yii\framework\web\CWebApplication.php(141): CWebApplication->runController('installer/optio...')
#14 D:\limesurvey\third_party\yiisoft\yii\framework\base\CApplication.php(185): CWebApplication->processRequest()
#15 D:\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,
Last edit: 1 year 4 months ago by jmluengo.

Please Log in to join the conversation.

More
1 year 3 months ago #236600 by zufolo441
Hi, the problem is PGSQL 15. If you downgrade to 13, it works.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose