Welcome to the LimeSurvey Community Forum

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

3 036 LimeSurvey 7: Updating an existing database failed

More
8 hours 14 minutes ago #273706 by riqcles
Please help us help you and fill where relevant:
LimeSurvey version: LimeSurvey Community Edition [url=https://192.168.56.113/limesurvey7/index.php/admin/databaseupdate/sa/db#modalSystemInformation] Version 7.0.0-beta1+260121 [/url]]
Own server:
Survey theme/template: vanilla
==================

I tested updating my LimeSurvey installation (in a VM).

I got an error (see end of message).

I tried again, installing a clean version 6.15.22.

I imported 4 questionnaires, then installed version 7.

No problem updating the database.

So, the problem seems to be with one or more of my questionnaires, but I have over 3,000.

Debugging enabled or disabled makes no difference. There's nothing in the Postgres logs.

I disabled the update in the config.ini file, to no avail.

I might be an isolated case, so if others are experiencing this, we could report the bug.

P.S.: The release_notes.txt file for version 6.16.5 is empty.

P.S. 2: Should we add a section dedicated to version 7 to the bug tracker?

Error message:

///////////////////////////////////////////

Update pgsql:host=serveurBdd;port=5432;user=limesurvey7;password=limesurvey7;dbname=limesurvey7; with prefix :lime_ from 640 to 700
PHP Error[2]: Undefined array key 0 
in file /var/www/html/limesurvey7/application/helpers/common_helper.php at line 1425
#0 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/base/CApplication.php(832): CErrorHandler->handle()
#1 /var/www/html/limesurvey7/application/helpers/common_helper.php(1425): ConsoleApplication->handleError()
#2 /var/www/html/limesurvey7/application/helpers/update/updates/Update_700.php(1074): getFieldName()
#3 /var/www/html/limesurvey7/application/helpers/update/DatabaseUpdateBase.php(47): LimeSurvey\Helpers\Update\Update_700->up()
#4 /var/www/html/limesurvey7/application/helpers/update/updatedb_helper.php(88): LimeSurvey\Helpers\Update\Update_700->safeUp()
#5 /var/www/html/limesurvey7/application/commands/UpdateDbCommand.php(46): db_upgrade_all()
#6 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run()
#7 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#8 /var/www/html/limesurvey7/vendor/yiisoft/yii/framework/base/CApplication.php(185): ConsoleApplication->processRequest()
#9 /var/www/html/limesurvey7/application/commands/console.php(77): ConsoleApplication->run()
[root@serveurIntranet config]#

/////////////////////////////////////////

Your system configuration: 
LimeSurvey version : 251103
Operating system
Linux Intranet server 5.14.0-611.16.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Mon Dec 22 12:21:56 UTC 2025 x86_64
PHP version 8.2.30
Web Server Name 192.168.56.113
Web Server Software Apache/2.4.62 (Rocky Linux) OpenSSL/3.5.1
Web Server Information Database Driver pgsql
Database Connector Version 17.7
Database Server Information PID: 2314; Client Encoding: UTF8; Is Superuser: on; Session Authorization: postgres; Date Style: ISO, MDY
Database Server Version 17.7

////////////////////////////////////////////////

 

LimeSurvey version 6.6.6
OS : RockyLinux / PHP 8.2.X
BDD : PostGresql 17.x /

Future LimeSurvey version 6.10.5
OS : RockyLinux / PHP 8.2.X
BDD : PostGresql 17.x /

Please Log in to join the conversation.

Moderators: holchtpartner

Lime-years ahead

Online-surveys for every purse and purpose