View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
20472Bug reportsInstallationpublic2026-04-17 18:04
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status resolvedResolutionfixed 
Product Version6.16.x 
Summary20472: Unable to update DB from 470 to 471 via CLI
Description

When update from pre-470 to 471 : receive an error

Steps To Reproduce

Steps to reproduce

Set up a 3.X
Update via console

Expected result

Update OK

Actual result

shnoulle@isis-debian:/media/shnoulle/data/www/master$ php application/commands/console.php updatedb
Update mysql:host=localhost;port=3306;dbname=ls_3X_update; with prefix :lime_ from 366 to 643
PHP Error[2]: include(LimeExpressionManager.php): Failed to open stream: No such file or directory
    in file /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/YiiBase.php at line 463
#0 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/base/CApplication.php(832): CErrorHandler->handle()
#1 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/YiiBase.php(463): ConsoleApplication->handleError()
#2 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/YiiBase.php(463): include()
#3 /media/shnoulle/data/www/master/application/helpers/update/updates/Update_471.php(9): autoload()
#4 /media/shnoulle/data/www/master/application/helpers/update/DatabaseUpdateBase.php(47): LimeSurvey\Helpers\Update\Update_471->up()
#5 /media/shnoulle/data/www/master/application/helpers/update/updatedb_helper.php(88): LimeSurvey\Helpers\Update\Update_471->safeUp()
#6 /media/shnoulle/data/www/master/application/commands/UpdateDbCommand.php(46): db_upgrade_all()
#7 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run()
#8 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#9 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/base/CApplication.php(185): ConsoleApplication->processRequest()
#10 /media/shnoulle/data/www/master/application/commands/console.php(77): ConsoleApplication->run()
shnoulle@isis-debian:/media/shnoulle/data/www/master$ php application/commands/console.php updatedb
Update mysql:host=localhost;port=3306;dbname=ls_3X_update; with prefix :lime_ from 470 to 643
PHP Error[2]: include(LimeExpressionManager.php): Failed to open stream: No such file or directory
    in file /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/YiiBase.php at line 463
#0 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/base/CApplication.php(832): CErrorHandler->handle()
#1 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/YiiBase.php(463): ConsoleApplication->handleError()
#2 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/YiiBase.php(463): include()
#3 /media/shnoulle/data/www/master/application/helpers/update/updates/Update_471.php(9): autoload()
#4 /media/shnoulle/data/www/master/application/helpers/update/DatabaseUpdateBase.php(47): LimeSurvey\Helpers\Update\Update_471->up()
#5 /media/shnoulle/data/www/master/application/helpers/update/updatedb_helper.php(88): LimeSurvey\Helpers\Update\Update_471->safeUp()
#6 /media/shnoulle/data/www/master/application/commands/UpdateDbCommand.php(46): db_upgrade_all()
#7 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run()
#8 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#9 /media/shnoulle/data/www/master/vendor/yiisoft/yii/framework/base/CApplication.php(185): ConsoleApplication->processRequest()
#10 /media/shnoulle/data/www/master/application/commands/console.php(77): ConsoleApplication->run()
TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)6.16.13
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionnot relevant
Server OS (if known)debian or windows
Webserver software & version (if known)nginx OR IIS
PHP Version8.4 and 8.0

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2026-03-25 17:57

developer   ~84527

Last edited: 2026-03-25 17:58

For web : import for all controller
Did we import for all command action ?

commands/ImportSurveyCommand.php:Yii::import('application.helpers.expressions.em_manager_helper', true);
commands/TwigCommand.php:        Yii::import('application.helpers.expressions.em_manager_helper', true);
commands/ValidateExpressionCommand.php:        Yii::import('application.helpers.expressions.em_manager_helper', true);
commands/DemomodeCommand.php:        require_once(dirname(dirname(dirname(__FILE__))) . '/application/helpers/expressions/em_manager_helper.php');
core/LSYii_Validators.php:        Yii::import('application.helpers.expressions.em_core_helper', true); // Already imported in em_manager_helper.php ?
core/LSYii_Controller.php:        $this->loadHelper('expressions.em_manager');
helpers/frontend_helper.php: * submitfailed : used in em_manager_helper.php
helpers/questionHelper.php:        // Please also list the new attribute in the function &TSVSurveyExport($sid) in em_manager_helper.php,
models/services/Quotas.php:                // Array of fieldnames with relevance value : EM fill $_SESSION with default value even is irrelevant (em_manager_helper line 6548)
views/survey/questions/question_help/em_tip.twig: * Question tips. For now, called from em_manager_helper::_ValidateQuestion
views/survey/questions/question_help/error_tip.twig: * Question error tips. For now, called from em_manager_helper::_ValidateQuestion and used for real error (db issue for example)
DenisChenu

DenisChenu

2026-03-25 18:19

developer   ~84528

https://github.com/LimeSurvey/LimeSurvey/pull/4817

DenisChenu

DenisChenu

2026-04-17 15:14

developer   ~84681

Clearly not related here.

See https://bugs.limesurvey.org/view.php?id=20481
and
https://bugs.limesurvey.org/view.php?id=20389

DenisChenu

DenisChenu

2026-04-17 15:15

developer   ~84682

I merge with master

DenisChenu

DenisChenu

2026-04-17 18:04

developer   ~84684

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=39551

Related Changesets

LimeSurvey: master 8c0b0e93

2026-04-17 18:03

DenisChenu

Committer: GitHub


Details Diff
Fixed issue 20472: Unable to update DB from 470 to 471 via CLI (04817) Affected Issues
20472
mod - application/commands/UpdateDbCommand.php Diff File
mod - application/core/ConsoleApplication.php Diff File
mod - application/helpers/expressions/em_manager_helper.php Diff File
mod - application/helpers/update/updatedb_helper.php Diff File

Issue History

Date Modified Username Field Change
2026-03-25 17:28 DenisChenu New Issue
2026-03-25 17:57 DenisChenu Assigned To => DenisChenu
2026-03-25 17:57 DenisChenu Status new => assigned
2026-03-25 17:57 DenisChenu Note Added: 84527
2026-03-25 17:57 DenisChenu Bug heat 0 => 2
2026-03-25 17:58 DenisChenu Note Edited: 84527
2026-03-25 18:19 DenisChenu Note Added: 84528
2026-03-25 18:19 DenisChenu Assigned To DenisChenu => gabrieljenik
2026-03-25 18:19 DenisChenu Status assigned => ready for code review
2026-03-26 20:37 gabrieljenik Assigned To gabrieljenik => tibor.pacalat
2026-03-26 20:37 gabrieljenik Status ready for code review => ready for testing
2026-04-16 19:22 tibor.pacalat Bug heat 2 => 4
2026-04-17 15:14 DenisChenu Note Added: 84681
2026-04-17 15:15 DenisChenu Note Added: 84682
2026-04-17 18:04 DenisChenu Changeset attached => LimeSurvey master 8c0b0e93
2026-04-17 18:04 DenisChenu Note Added: 84684
2026-04-17 18:04 DenisChenu Assigned To tibor.pacalat => DenisChenu
2026-04-17 18:04 DenisChenu Status ready for testing => resolved
2026-04-17 18:04 DenisChenu Resolution open => fixed