- Posts: 15
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
updatedb fails: Table 'lime_tutorials' already exists
- bodonne2
- Topic Author
- Offline
- New Member
Less
More
4 years 3 months 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:
Code:
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:
Code:
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!
Thanks
The topic has been locked.
- bodonne2
- Topic Author
- Offline
- New Member
Less
More
- Posts: 15
- Thank you received: 0
4 years 3 months 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.
Code:
+-----------------------------------------------------+ | 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)
The topic has been locked.