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)
> r...@beezwax:/var/www/typo#
> r...@beezwax:/var/www/typo#
> r...@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
>
_______________________________________________
Typo-list mailing list
Typo-list@rubyforge.org
http://rubyforge.org/mailman/listinfo/typo-list
