updatedb fails: Table 'lime_tutorials' already exists

1 month 5 days ago #192660 by bodonne2

I'm attempting to update from 2.73 to 3.x via the updatedb command line script. The starting db version is 263 and the target is 337. The upgrade gets as far as 321 before it fails with:

CException: Object configuration must be an array containing a "class" element. in /var/www/limesurvey/framework/YiiBase.php:194
Stack trace:
#0 /var/www/limesurvey/framework/base/CModule.php(393): YiiBase::createComponent(Array)
#1 /var/www/limesurvey/application/core/ConsoleApplication.php(20): CModule->getComponent('session')
#2 /var/www/limesurvey/framework/web/auth/CWebUser.php(200): ConsoleApplication->getSession()
#3 /var/www/limesurvey/framework/base/CModule.php(394): CWebUser->init()
#4 /var/www/limesurvey/framework/base/CModule.php(103): CModule->getComponent('user')
#5 /var/www/limesurvey/application/helpers/update/updatedb_helper.php(837): CModule->__get('user')
#6 /var/www/limesurvey/application/commands/UpdateDbCommand.php(42): db_upgrade_all(321)
#7 /var/www/limesurvey/framework/console/CConsoleCommandRunner.php(71): UpdateDBCommand->run(Array)
#8 /var/www/limesurvey/framework/console/CConsoleApplication.php(92): CConsoleCommandRunner->run(Array)
#9 /var/www/limesurvey/framework/base/CApplication.php(185): CConsoleApplication->processRequest()
#10 /var/www/limesurvey/application/commands/console.php(60): CApplication->run()
#11 {main}

If I try via the web update tool, it also fails with a more informative message:

CDbCommand failed to execute the SQL statement: SQLSTATE[42S01]: Base table or view already exists: 1050 Table 'lime_tutorials' already exists. The SQL statement executed was: CREATE TABLE `lime_tutorials` ( `tid` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(128) , `description` text, `active` int DEFAULT 0, `settings` text, `permission` varchar(128) NOT NULL, `permission_grade` varchar(128) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

I have tried dropping the "lime_tutorials" table and running the update again, but it still fails with the same error.

Any help is appreciated!


Please Iniciar sessão or Create an account to join the conversation.

LimeSurvey Partners
1 month 5 days ago #192668 by bodonne2
Looks like dropping these four empty tables "fixed" it. They were all re-created in the process.
| Tables_in_saa_limesurvey_migrationtest (lime_%tut%) |
| lime_map_tutorial_users                             |
| lime_tutorial_entries                               |
| lime_tutorial_entry_relation                        |
| lime_tutorials                                      |
4 rows in set (0.03 sec)

Please Iniciar sessão or Create an account to join the conversation.

Começar agora!

Basta criar a sua conta e comece a usar o LimeSurvey hoje mesmo.

Registar agora
Subscreva o nosso boletim informativo!

Iniciar sessão