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 <[email protected]> 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) >> 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 > [email protected] > http://rubyforge.org/mailman/listinfo/typo-list > -- Cyril Mougel http://blog.shingara.fr _______________________________________________ Typo-list mailing list [email protected] http://rubyforge.org/mailman/listinfo/typo-list
