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
  • bodonne2's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 3 months ago #192660 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:

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
  • bodonne2's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 3 months ago #192668 by bodonne2
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.

Lime-years ahead

Online-surveys for every purse and purpose