Following Learn Ruby On Rails Tutorial, Cant add users to database -

Following Learn Ruby On Rails Tutorial, Cant add users to database -

im trying follow learn ruby on rails tutorial michael hartl. i'm on chapter 7 grabs user info database display pages. however, maintain getting error there no user id of one. can't verify info in database (since sql database viewer says cant open file , have no thought how install 1.1 version allegedly fixes problem).

i tried adding user in console , seems succeed, sec go find user created, doesn't exist (see below). help? i'm frustrated @ moment.

user.find 1.9.3-p327 :001 > user.find(1) user load (31.4ms) select "users".* "users" "users"."id" = $1 limit 1 [["id", 1]] activerecord::recordnotfound: couldn't find user id=1 /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/relation/finder_methods.rb:341:in `find_one' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/relation/finder_methods.rb:312:in `find_with_ids' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/relation/finder_methods.rb:107:in `find' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/querying.rb:5:in `find' (irb):1 /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/railties-3.2.9/lib/rails/commands/console.rb:47:in `start' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/railties-3.2.9/lib/rails/commands/console.rb:8:in `start' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/railties-3.2.9/lib/rails/commands.rb:41:in `<top (required)>' script/rails:6:in `require' script/rails:6:in `<main>' user.create 1.9.3-p327 :002 > user.create(name: "md", email: "md@example.com", password: "foobar", password_confirmation: "foobar") (22.6ms) savepoint active_record_1 user exists (56.7ms) select 1 1 "users" lower("users"."email") = lower('md@example.com') limit 1 sql (153.7ms) insert "users" ("created_at", "email", "name", "password_digest", "updated_at") values ($1, $2, $3, $4, $5) returning "id" [["created_at", mon, 11 feb 2013 00:59:52 utc +00:00], ["email", "md@example.com"], ["name", "md"], ["password_digest", "$2a$10$nfeb9pspqusegbj8.toilefjzmgtajxcfhexzpgzmlov72uffjoue"], ["updated_at", mon, 11 feb 2013 00:59:52 utc +00:00]] (0.4ms) release savepoint active_record_1 => #<user id: 4, name: "md", email: "md@example.com", created_at: "2013-02-11 00:59:52", updated_at: "2013-02-11 00:59:52", password_digest: "$2a$10$nfeb9pspqusegbj8.toilefjzmgtajxcfhexzpgzmlov..."> user.find 1.9.3-p327 :003 > user.find(1) user load (2.2ms) select "users".* "users" "users"."id" = $1 limit 1 [["id", 1]] activerecord::recordnotfound: couldn't find user id=1 /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/relation/finder_methods.rb:341:in `find_one' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/relation/finder_methods.rb:312:in `find_with_ids' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/relation/finder_methods.rb:107:in `find' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/activerecord-3.2.9/lib/active_record/querying.rb:5:in `find' (irb):3 /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/railties-3.2.9/lib/rails/commands/console.rb:47:in `start' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/railties-3.2.9/lib/rails/commands/console.rb:8:in `start' /home/gerard/.rvm/gems/ruby-1.9.3-p327/gems/railties-3.2.9/lib/rails/commands.rb:41:in `<top (required)>' script/rails:6:in `require' script/rails:6:in `<main>'

i guess, you've run 'rake db:migrate' in command line , sqlite3 database files generated in db folder.

ruby-on-rails ruby database user railstutorial.org