On Feb 23, 2007, at 1:17 PM, bsag wrote: > On Fri Feb 23 03:08:59 UTC 2007, <[EMAIL PROTECTED]> wrote: >> I get this error when running "rake migrate": >> >> # rake migrate --trace >> (in /var/www/tracks-local/tracks) >> ** Invoke migrate (first_time) >> ** Invoke db:migrate (first_time) >> ** Invoke environment (first_time) >> ** Execute environment >> ** Execute db:migrate >> == AddTagSupport: migrating >> =================================================== >> -- create_table(:taggings) >> rake aborted! >> Mysql::Error: Table 'taggings' already exists: CREATE TABLE >> taggings (`id` >> int(11) DEFAULT NULL auto_increment PRIMARY KEY, `taggable_id` int >> (11) >> DEFAULT NULL, `tag_id` int(11) DEFAULT NULL, `taggable_type` >> varchar(255) >> DEFAULT NULL, `user_id` int(11) DEFAULT NULL) ENGINE=InnoDB > > What version of schema_info were you at before you migrated? I > wonder if you somehow missed one of the migrations? Because it > shouldn't go back and try to re-run the tagging migration if you'd > already passed it. You could try going back down to before the > tagging migration, then coming back up again. So: > > rake db:migrate VERSION=25 > > then, > > rake db:migrate > > Note that you'll lose any tags you have in the table if you do that. > > cheers, > > bsag
I'm not sure which version I was at. I did get an error when I tried running migrated with the version specified. # rake db:migrate VERSION=25 (in /var/www/tracks-local/tracks) == AddTagSupport: migrating =================================================== -- create_table(:taggings) rake aborted! Mysql::Error: Table 'taggings' already exists: CREATE TABLE taggings (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `taggable_id` int(11) DEFAULT NULL, `tag_id` int(11) DEFAULT NULL, `taggable_type` varchar(255) DEFAULT NULL, `user_id` int(11) DEFAULT NULL) ENGINE=InnoDB (See full trace by running task with --trace) I don't know whether this will be a problem going forward since I can complete a next action by leaving the box checked and hitting the "home" link. Stephen _______________________________________________ Tracks-discuss mailing list [email protected] http://lists.rousette.org.uk/mailman/listinfo/tracks-discuss
