Newbie Trouble with RubyOnRails Bible

Hello all,

I am new to RoR and am working my way through Timothy Fisher’s Ruby On Rails Bible. I’m stuck on page 81. I have followed the steps leading to this page, i.e.

cd rails_projects

rails contactlist

ruby script/server webrick

open a cmd window and run mysql: create database contactlist_development;

use contactlist_development;

create table contacts (id int not null auto_increment, …etc.);

show tables;

describe contacts;

ruby script/generate model Contact

<look at app/models/contact.rb, which shows:>

class Contact < ActiveRecord:: Base

end

ruby script/console

Loading development environment

my_contact = Contact.new

<here’s the problem: instead of showing me the attributes of the instance, I get the message:

ActiveRecord::StatementInvalid: Could not find table ‘contacts’ from c:\program files\BitNami RubyStack/ruby/lib/ruby/gems… etc… and many other error messages too.

Ohhh! I just noticed that another of the error messages indicates that it is looking for a sqlite3_adapter.rb:29. Hmmm. How do I tell it that I’m using mySQL not sqlite?

For most or all of you, this is probably a trivial question, but for me it is a show stopper. I’m very excited by the language and the framework and the book, but at the moment I’m slamming my forehead on this wall. Please help.

TIA,

Arthur

Hi --

Ohhh! I just noticed that another of the error messages indicates that it is looking for a
sqlite3_adapter.rb:29. Hmmm. How do I tell it that I'm using mySQL not sqlite?

When you create the app, you can do:

   rails myapp --database=mysql

If you've already created the app, do the above on a second app, then
look at config/database.yml and you'll see the difference in
configuration (which you can then adapt for your original app by
editing its database.yml).

David

Also, after creating the app with the appropriate database selected,
you will want to confirm the settings in the db configuration file
"application/config/database.yml". Specifically check the values for
"database", "username", and "password" that are associated with all 3
modes (development, test, production).

By the way, "rails --help" will give you a list of all command line
options.

See also: http://guides.rubyonrails.org/

Here's a helpful resource:

http://guides.rubyonrails.org/getting_started.html

search for 'mysql' and you'll find an example configuration.