Need help please

The thing that sucks is I'm following a video guide, and my stuff should be the exact same as the guys, and when i do the rake db:migrate, it gives me that error but the guy's just works with no issues. IDK what the hell im doing wrong, i tried the "bundle exec rake db:schema:load" and it just said this: (I also ran db:migrate afterwords)

lithium@ubuntu:~/blog$ bundle exec rake db:schema:load
-- create_table("comments", {:force=>true})
   -> 0.8508s
-- create_table("posts", {:force=>true})
   -> 0.0448s
-- create_table("users", {:force=>true})
   -> 0.0464s
-- add_index("users", ["email"], {:unique=>true, :name=>"index_users_on_email"})
   -> 0.0502s
-- initialize_schema_migrations_table()
   -> 0.0016s
-- assume_migrated_upto_version(20110814141025, "db/migrate")
   -> 0.0024s
lithium@ubuntu:~/blog$ rake db:migrate
==  CreateUsers: migrating ====================================================
-- create_table(:users)
rake aborted!
An error has occurred, this and all later migrations canceled:

SQLite3::SQLException: table "users" already exists: CREATE TABLE "users" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "name" varchar(255), "email" varchar(255), "state" varchar(255), "city" varchar(255), "years" integer, "created_at" datetime, "updated_at" datetime)

Tasks: TOP => db:migrate
(See full trace by running task with --trace)

I got past the other issue i posted by simply destroying the table and then rake, but it's annoying to have to do that ***** again.

Last edited by _lithium_ (2011-08-15 17:57:39)

Just in case anyone else is struggling with this spot in Michael Hartl's tutorial . . . you're not alone. I have no idea why he doesn't update his tutorial to address this issue . . .

Here's what I did: skip that first bundle exec rake db:migrate.

Follow along with all the validation stuff. (I'm skipping the testing stuff so I don't know if that will screw things up by not doing this rake.)

Be sure to do this in section 6.22:
class AddIndexToUsersEmail < ActiveRecord::Migration
  def change
    add_index :users, :email, unique: true
  end
end

Then do bundle exec rake db:migrate. This will work because the users table will be created now, not back at the beginning of the chapter.

Not sure what will happen when I get further into the tutorial because I see that this same issue rears it's head again.

If anybody knows Michael Hartl, please call him up and ask him to address this issue. He's got a lot of people paying for his tutorial, including me, and this isn't acceptable.

Last edited by charliemagee (2012-05-23 18:38:01)