[typo] Mysql db migration jams up with Typo 5.4.4

Cyril Mougel cyril.mougel at gmail.com
Fri Apr 23 08:10:29 EDT 2010


It's seems that this error because you don't starting your database by
migration.

Can you send us the result of :

select * from schema_migrations;

On Fri, Apr 23, 2010 at 1:30 PM, Simon Brown <simon_b at beezwax.net> wrote:
> 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
>>
>
>
> _______________________________________________
> Typo-list mailing list
> Typo-list at rubyforge.org
> http://rubyforge.org/mailman/listinfo/typo-list
>



-- 
Cyril Mougel
http://blog.shingara.fr


More information about the Typo-list mailing list