- Posts: 9
- Thank you received: 0
- Forum
- English support forums
- Installation & update issues
- updatedb fails: Table 'lime_tutorials' already exists
updatedb fails: Table 'lime_tutorials' already exists
1 month 5 days ago #192660
by bodonne2
updatedb fails: Table 'lime_tutorials' already exists was created by bodonne2
Hello,
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:
If I try via the web update tool, it also fails with a more informative message:
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!
Thanks
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_ciI have tried dropping the "lime_tutorials" table and running the update again, but it still fails with the same error.
Any help is appreciated!
Thanks
Please Log in or Create an account to join the conversation.
1 month 5 days ago #192668
by bodonne2
Replied by bodonne2 on topic updatedb fails: Table 'lime_tutorials' already exists
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 Log in or Create an account to join the conversation.