[typo] Mysql db migration jams up with Typo 5.4.4

Simon Brown simon_b at beezwax.net
Fri Apr 23 07:30:58 EDT 2010


Hello all,

I'm trying to migrate a 5.3 typo system to 5.44, but I am getting errors on the database migration step. At the start I see:

> Current database version: 84
> 
> New database version: 88
> 
> Your database supports migrations: yes
> 
> Needed migrations
> 
> 	• Add article parent draft
> 	• Add user last connection
> 	• Drop blacklist patterns
> 	• Drop session table
> 
>  may take a moment
> 

But as soon as I perform the migration by clicking on the button (or using rake RAILS_ENV=production db:migrate
 for that matter) I get the error below.

Of course, there definitely is an existing users table. But this also can't be an unexpected situation either. How do I get this fixed? Edit the 001_initial_schema.rb file in some way?


TIA,

Simon


> Processing Admin::SettingsController#migrate (for 76.191.223.69 at 2010-04-23 10:55:05) [POST]
>   Parameters: {"authenticity_token"=>"/xzzzzzzzzzzzzzzzzzzzzzzzzzzzQ="}
> Migrating to InitialSchema (1)
> 
> StandardError (An error has occurred, all later migrations canceled:
> 
> Mysql::Error: Table 'users' already exists: CREATE TABLE `users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `login` varchar(255), `password` varchar(255)) ENGINE=InnoDB):
>   db/migrate//001_initial_schema.rb:16:in `up_without_benchmarks'
>   db/migrate//001_initial_schema.rb:15:in `up_without_benchmarks'
>   lib/migrator.rb:26:in `migrate'
>   app/controllers/admin/settings_controller.rb:59:in `migrate'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/rack/request_handler.rb:81:in `process_request'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_request_handler.rb:203:in `main_loop'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/railz/application_spawner.rb:340:in `start_request_handler'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/railz/application_spawner.rb:298:in `handle_spawn_application'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/utils.rb:181:in `safe_fork'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/railz/application_spawner.rb:296:in `handle_spawn_application'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server.rb:337:in `__send__'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server.rb:337:in `main_loop'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server.rb:187:in `start_synchronously'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server.rb:154:in `start'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/railz/application_spawner.rb:192:in `start'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/spawn_manager.rb:257:in `spawn_rails_application'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server_collection.rb:126:in `lookup_or_add'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/spawn_manager.rb:251:in `spawn_rails_application'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server_collection.rb:80:in `synchronize'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/spawn_manager.rb:250:in `spawn_rails_application'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/spawn_manager.rb:153:in `spawn_application'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/spawn_manager.rb:282:in `handle_spawn_application'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server.rb:337:in `__send__'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server.rb:337:in `main_loop'
>   /var/lib/gems/1.8/gems/passenger-2.2.2/lib/phusion_passenger/abstract_server.rb:187:in `start_synchronously'
> 
> Rendering /var/www/typo/public/500.html (500 Internal Server Error)
> root at beezwax:/var/www/typo# 
> root at beezwax:/var/www/typo# 
> root at beezwax:/var/www/typo# rake RAILS_ENV=production db:migrate
> (in /var/www/typo)
> ==  InitialSchema: migrating ==================================================
> -- create_table(:users)
> rake aborted!
> An error has occurred, all later migrations canceled:
> 
> Mysql::Error: Table 'users' already exists: CREATE TABLE `users` (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `login` varchar(255), `password` varchar(255)) ENGINE=InnoDB
> 




More information about the Typo-list mailing list