- Posts: 1
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Could not add administrator settings: CDbException
4 months 6 days ago - 4 months 6 days ago #233953
by jmluengo
Could not add administrator settings: CDbException was created 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
\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,
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:543Stack 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,
Last edit: 4 months 6 days ago by jmluengo.
Please Log in to join the conversation.
