| Description | I am attempting to run db migration before starting up LS under FPM and am currently on db version 348. Note that LS version 3.9.0 needs to migrate to db version 349. I run (in application/commands directory)
php console.php updatedb
and get the following output:
Update pgsql:host=postgres;port=5432;user=XXXXX;password=XXXXX;dbname=dev; with prefix : from 348 to 349
Error: Call to undefined function setGlobalSetting() in /app/application/helpers/update/updatedb_helper.php:2268
Stack trace:
#0 /app/application/commands/UpdateDbCommand.php(42): db_upgrade_all(348)
#1 /app/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run(Array)
#2 /app/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run(Array)
#3 /app/framework/base/CApplication.php(185): CConsoleApplication->processRequest()
#4 /app/application/commands/console.php(64): CApplication->run()
#5 {main}limesurvey_fpm_1 exited with code 1 |
|---|
| Steps To Reproduce | Run the updatedb command but you must actually need a db migration. DB version 349 performs these updates (FYI - in case you need to back them out while testing):
ALTER TABLE "users" DROP COLUMN "one_time_pw"
ALTER TABLE "users" ADD COLUMN "one_time_pw" text
UPDATE "settings_global" SET "stg_value"='349' WHERE stg_name='DBVersion'
UPDATE "lime"."settings_global" SET "stg_name"='DBVersion', "stg_value"='349' WHERE "lime"."settings_global"."stg_name"='DBVersion'
INSERT INTO "lime"."notifications" ("status", "importance", "display_class", "entity", "entity_id", "title", "message", "created", "first_read") VALUES ('new', 1, 'default', 'user', 1, 'Database update', 'The database has been updated from version 348 to version 349.', NOW(), NULL)
INSERT INTO "lime"."settings_global" ("stg_name", "stg_value") VALUES ('defaulttheme', 'vanilla') |
|---|
| Additional Information | To fix the issue I added one line to UpdateDbCommand.php:
--- a/base/limesurvey/application/commands/UpdateDbCommand.php
+++ b/base/limesurvey/application/commands/UpdateDbCommand.php
@@ -39,6 +39,7 @@ class UpdateDBCommand extends CConsoleCommand
echo Yii::app()->db->tablePrefix." from {$currentDbVersion} to {$newDbVersion}\n";
Yii::import('application.helpers.common_helper', true);
Yii::import('application.helpers.update.updatedb_helper', true);
- Yii::import('application.helpers.globalsettings_helper', true);
$result = db_upgrade_all($currentDbVersion);
if ($result) {
echo "Database has been successfully upgraded to version $newDbVersion \n";
|
|---|
